User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Calc
-
- Forum
- Topics
- Posts
- Last post
-
-
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML - Total redirects: 32599
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 34458
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 31430
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.8 released
by robleyd » Wed Nov 11, 2020 1:47 am
- 2 Replies
- 9712 Views
- Last post by MrProgrammer
Thu Nov 12, 2020 5:59 am
- Apache OpenOffice 4.1.8 released
-
- Topics
- Replies
- Views
- Last post
-
- Templates: a dedicated repository in the OpenOffice web site
by Hagar Delest » Sun Feb 01, 2009 12:25 am - 6 Replies
- 47458 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Unable to open file, shows ASCII Filter Options dialog
by jefflyon6502 » Wed Dec 02, 2020 4:26 pm - 5 Replies
- 76 Views
- Last post by jefflyon6502
Wed Dec 02, 2020 11:10 pm
- Unable to open file, shows ASCII Filter Options dialog
-
- [Solved] Does Calc have feature like unique in Google Sheets
by polly » Wed Dec 02, 2020 6:20 pm - 4 Replies
- 60 Views
- Last post by polly
Wed Dec 02, 2020 10:54 pm
- [Solved] Does Calc have feature like unique in Google Sheets
-
- Misbehaving data validity
by morphingstar » Wed Dec 02, 2020 12:56 am
- 2 Replies
- 83 Views
- Last post by Zizi64
Wed Dec 02, 2020 8:25 am
- Misbehaving data validity
-
- Returning/Displaying Most Displayed Text from a Column Range
by johnarthur » Mon Nov 30, 2020 1:06 am
- 1 Replies
- 85 Views
- Last post by MrProgrammer
Wed Dec 02, 2020 5:30 am
- Returning/Displaying Most Displayed Text from a Column Range
-
- Line break in function if cell is not empty
by manosdet » Mon Nov 30, 2020 12:05 pm
- 6 Replies
- 41 Views
- Last post by manosdet
Tue Dec 01, 2020 4:53 pm
- Line break in function if cell is not empty
-
- [Solved] What Can I Hide?
by Bloodknot » Mon Nov 30, 2020 4:04 pm - 5 Replies
- 114 Views
- Last post by Bloodknot
Tue Dec 01, 2020 12:10 am
- [Solved] What Can I Hide?
-
- [Solved] Sum a column based on matches in other columns
by cul » Tue Sep 29, 2020 2:08 pm
- 6 Replies
- 658 Views
- Last post by cul
Mon Nov 30, 2020 8:15 am
- [Solved] Sum a column based on matches in other columns
-
- [Solved] Naming tables in Calc 4.1.8
by h8ids » Sun Nov 29, 2020 7:26 pm
- 2 Replies
- 102 Views
- Last post by h8ids
Mon Nov 30, 2020 4:13 am
- [Solved] Naming tables in Calc 4.1.8
-
- [Solved] Format error discovered in the file in sub-document
by nph2011 » Fri Jan 14, 2011 11:21 am
- 21 Replies
- 26101 Views
- Last post by Gangadhar
Sat Nov 28, 2020 6:38 pm
- [Solved] Format error discovered in the file in sub-document
-
- [Solved] Calculate hours in work schedule
by carwena » Thu Nov 12, 2020 10:28 pm
- 10 Replies
- 328 Views
- Last post by carwena
Sat Nov 28, 2020 5:59 pm
- [Solved] Calculate hours in work schedule
-
- [Solved] Extract uppercase words to a different cell
by fiona87 » Wed Nov 25, 2020 6:27 pm
- 4 Replies
- 204 Views
- Last post by lader
Fri Nov 27, 2020 6:07 pm
- [Solved] Extract uppercase words to a different cell
-
- [Solved] Telefon number format
by Emilio » Mon Nov 23, 2020 5:04 pm
- 11 Replies
- 262 Views
- Last post by Emilio
Fri Nov 27, 2020 5:49 pm
- [Solved] Telefon number format
-
- Remove blue arrow which hides cell content
by kleajmp » Fri Nov 27, 2020 1:23 am
- 2 Replies
- 71 Views
- Last post by MrProgrammer
Fri Nov 27, 2020 4:47 pm
- Remove blue arrow which hides cell content
-
- [Solved] Put border around group of selected cells
by jimbir » Thu Nov 26, 2020 9:22 pm - 1 Replies
- 91 Views
- Last post by RoryOF
Thu Nov 26, 2020 9:30 pm
- [Solved] Put border around group of selected cells
-
- [Solved] #NAME? error in Spreadhsheet
by 06honda » Wed Nov 18, 2020 4:25 pm
- 6 Replies
- 230 Views
- Last post by 06honda
Wed Nov 25, 2020 5:30 pm
- [Solved] #NAME? error in Spreadhsheet
-
- Mid function relative reference changes but outcome does not
by jelket » Wed Nov 25, 2020 1:28 pm - 4 Replies
- 127 Views
- Last post by DiGro
Wed Nov 25, 2020 4:01 pm
- Mid function relative reference changes but outcome does not
-
- [Solved] How to shift columns up or down
by cjoh11 » Tue Nov 24, 2020 4:00 pm - 3 Replies
- 154 Views
- Last post by Villeroy
Tue Nov 24, 2020 6:21 pm
- [Solved] How to shift columns up or down
-
- Font is changed when pasting into Calc
by porttownsend119 » Tue Nov 24, 2020 1:03 am - 0 Replies
- 126 Views
- Last post by porttownsend119
Tue Nov 24, 2020 1:03 am
- Font is changed when pasting into Calc
-
- [Solved] Writer (an archaic version) Date problem
by Hrodlanson » Mon Nov 23, 2020 7:23 pm - 3 Replies
- 178 Views
- Last post by Villeroy
Mon Nov 23, 2020 10:10 pm
- [Solved] Writer (an archaic version) Date problem
-
- [Solved] Want to split data, multiple rows
by drp_61 » Sun Nov 22, 2020 10:18 am - 3 Replies
- 174 Views
- Last post by drp_61
Mon Nov 23, 2020 10:30 am
- [Solved] Want to split data, multiple rows
-
- Calc crashes every time I use "Find"
by manoman » Sun Nov 22, 2020 3:44 am
- 3 Replies
- 149 Views
- Last post by RoryOF
Sun Nov 22, 2020 5:31 pm
- Calc crashes every time I use "Find"
-
- [Solved] Want to split data
by drp_61 » Sun Nov 22, 2020 6:41 am
- 1 Replies
- 178 Views
- Last post by robleyd
Sun Nov 22, 2020 6:57 am
- [Solved] Want to split data
-
- How to specify x axis
by ronhud » Sat Nov 21, 2020 2:16 pm - 5 Replies
- 158 Views
- Last post by Villeroy
Sat Nov 21, 2020 7:41 pm
- How to specify x axis
-
- Corrupted file - having issues
by mistahjoe » Sat Nov 21, 2020 6:17 pm
- 1 Replies
- 123 Views
- Last post by RusselB
Sat Nov 21, 2020 6:27 pm
- Corrupted file - having issues
-
- Newer version message when opening Calc document
by officevortex » Sat Nov 21, 2020 12:07 am - 1 Replies
- 124 Views
- Last post by robleyd
Sat Nov 21, 2020 1:16 am
- Newer version message when opening Calc document
-
- [Solved] Multiplying columns
by Nitrocowboy » Mon Jan 12, 2009 5:15 am - 5 Replies
- 17500 Views
- Last post by universe
Sat Nov 21, 2020 1:14 am
- [Solved] Multiplying columns
-
- [Solved] Calc is not exporting whole document to PDF
by officevortex » Sat Nov 21, 2020 12:28 am - 0 Replies
- 88 Views
- Last post by officevortex
Sat Nov 21, 2020 12:28 am
- [Solved] Calc is not exporting whole document to PDF
-
- Format Cell as Date - LibreOffice
by Alex in Grimsby » Fri Nov 20, 2020 1:53 pm - 11 Replies
- 214 Views
- Last post by Villeroy
Fri Nov 20, 2020 10:35 pm
- Format Cell as Date - LibreOffice
-
- [Solved] Count cells (COUNTIF?) containing the word «and»
by 73and6man » Fri Nov 20, 2020 1:12 pm - 7 Replies
- 163 Views
- Last post by 73and6man
Fri Nov 20, 2020 9:27 pm
- [Solved] Count cells (COUNTIF?) containing the word «and»
-
- Show Bitcoin price "at the time"
by snowman123 » Sat Dec 16, 2017 10:26 pm
- 11 Replies
- 4558 Views
- Last post by pjmcclore
Fri Nov 20, 2020 6:28 pm
- Show Bitcoin price "at the time"
-
- Lost the handy tools window at right side of calc pages
by oldnavyabm@yahoo.com » Fri Nov 20, 2020 3:04 pm - 1 Replies
- 93 Views
- Last post by RoryOF
Fri Nov 20, 2020 3:19 pm
- Lost the handy tools window at right side of calc pages
-
- [Solved] Stop cursor moving down to next cell
by Jude58c » Fri Nov 20, 2020 2:38 pm - 2 Replies
- 106 Views
- Last post by Jude58c
Fri Nov 20, 2020 3:16 pm
- [Solved] Stop cursor moving down to next cell
-
- [Solved] Compare a single cell to a group of cells?
by Acidello » Thu Nov 19, 2020 1:19 am - 2 Replies
- 167 Views
- Last post by Acidello
Thu Nov 19, 2020 7:42 pm
- [Solved] Compare a single cell to a group of cells?
-
- [Solved] Beginner questions
by weygtya » Wed Mar 27, 2019 6:01 pm
- 16 Replies
- 672 Views
- Last post by weygtya
Wed Nov 18, 2020 5:25 pm
- [Solved] Beginner questions
-
- [Solved] Listbox text alignment
by Bloodknot » Sun Nov 15, 2020 6:28 pm
- 3 Replies
- 155 Views
- Last post by Bloodknot
Wed Nov 18, 2020 12:47 pm
- [Solved] Listbox text alignment
-
- [SOLVED] Create Pivot Table
by sf_of » Tue Nov 10, 2020 7:53 am
- 6 Replies
- 227 Views
- Last post by Villeroy
Wed Nov 18, 2020 12:10 pm
- [SOLVED] Create Pivot Table
-
- Set value in D based on value in A (1,2,3,…)
by onlyjohn » Tue Nov 17, 2020 2:34 pm - 1 Replies
- 121 Views
- Last post by FJCC
Tue Nov 17, 2020 4:55 pm
- Set value in D based on value in A (1,2,3,…)
-
- [Solved] Find rows with same prefix (different suffix)
by raykt » Fri Nov 13, 2020 4:51 pm
- 3 Replies
- 201 Views
- Last post by MrProgrammer
Mon Nov 16, 2020 7:34 pm
- [Solved] Find rows with same prefix (different suffix)
-
- [Solved] Calculating weekly pay in Australia
by ozishbob » Fri Nov 13, 2020 9:54 am
- 9 Replies
- 369 Views
- Last post by Villeroy
Mon Nov 16, 2020 11:50 am
- [Solved] Calculating weekly pay in Australia
-
- In Calc do hyperlinks remain unchanged ?
by DEMURRAYM » Sun Nov 15, 2020 8:17 pm - 2 Replies
- 158 Views
- Last post by Villeroy
Sun Nov 15, 2020 9:22 pm
- In Calc do hyperlinks remain unchanged ?
-
- DBF file getting auto populated
by bl4ckh4t » Thu Nov 05, 2020 9:59 pm - 3 Replies
- 203 Views
- Last post by Villeroy
Sun Nov 15, 2020 5:58 pm
- DBF file getting auto populated
-
- Spreadsheet won't open; Filled with ####
by Robin Hall » Sun Nov 15, 2020 11:28 am - 5 Replies
- 154 Views
- Last post by RoryOF
Sun Nov 15, 2020 4:53 pm
- Spreadsheet won't open; Filled with ####
-
- OpenOffice 4.1.8 cannot open spreadsheets (recovery)
by Grandma of 8 » Sun Nov 15, 2020 1:00 am - 1 Replies
- 147 Views
- Last post by RusselB
Sun Nov 15, 2020 3:03 am
- OpenOffice 4.1.8 cannot open spreadsheets (recovery)
-
- [Solved] Transfer a number to a different sheet
by TheOldThug » Wed Nov 11, 2020 7:50 pm
- 6 Replies
- 215 Views
- Last post by FJCC
Sun Nov 15, 2020 12:19 am
- [Solved] Transfer a number to a different sheet
-
- [Solved] Compound interest calculator
by judgesinel » Fri Nov 13, 2020 8:11 am
- 2 Replies
- 149 Views
- Last post by judgesinel
Fri Nov 13, 2020 10:21 pm
- [Solved] Compound interest calculator
-
- [Solved] Combining two formulae in one cell
by MarkPavlovich » Tue Nov 10, 2020 4:23 pm - 6 Replies
- 295 Views
- Last post by MarkPavlovich
Fri Nov 13, 2020 4:29 pm
- [Solved] Combining two formulae in one cell
-
- [Solved] Is there a SUMIFS function in Calc?
by GRMH4948 » Wed Nov 11, 2020 10:13 pm - 3 Replies
- 189 Views
- Last post by Lupp
Thu Nov 12, 2020 12:56 pm
- [Solved] Is there a SUMIFS function in Calc?
-
- [Solved] Copy/paste criteria of <0 RELATIVE to cells
by MarkPavlovich » Tue Nov 10, 2020 9:14 pm - 1 Replies
- 143 Views
- Last post by MrProgrammer
Wed Nov 11, 2020 9:35 pm
- [Solved] Copy/paste criteria of <0 RELATIVE to cells
-
- [Solved] Looking for a shortcut in special paste
by steve4810 » Mon Feb 20, 2012 8:43 pm - 8 Replies
- 5053 Views
- Last post by CapCrockett
Wed Nov 11, 2020 6:13 pm
- [Solved] Looking for a shortcut in special paste
Who is online
Users browsing this forum: No registered users and 25 guests
Forum permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|