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: 35766
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 37807
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 34763
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 24540 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 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
- 50714 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- What formula to use for table lookup?
by Olegs Andrejevskis » Sun Apr 11, 2021 3:57 pm
- 1 Replies
- 43 Views
- Last post by MrProgrammer
Sun Apr 11, 2021 6:31 pm
- What formula to use for table lookup?
-
- I have a corrupted spreadsheet file which I can't repair
by thenax » Sat Apr 10, 2021 10:48 pm
- 10 Replies
- 146 Views
- Last post by John_Ha
Sun Apr 11, 2021 12:35 pm
- I have a corrupted spreadsheet file which I can't repair
-
- [Issue] How to change default Borders thickness?
by quyda » Wed Jan 07, 2009 11:07 am - 16 Replies
- 24626 Views
- Last post by Hagar Delest
Sun Apr 11, 2021 11:43 am
- [Issue] How to change default Borders thickness?
-
- Disabling autocorrect in Calc
1, 2 by evand » Thu Apr 23, 2009 10:20 pm
- 39 Replies
- 50006 Views
- Last post by Villeroy
Sat Apr 10, 2021 2:59 pm
- Disabling autocorrect in Calc
-
- Saving to csv caused data loss in ods file
by waynec444 » Fri Apr 09, 2021 5:09 pm - 14 Replies
- 180 Views
- Last post by waynec444
Fri Apr 09, 2021 11:57 pm
- Saving to csv caused data loss in ods file
-
- [Solved]Search column from specific cell and copy the result
by manosdet » Tue Apr 06, 2021 5:46 pm
- 5 Replies
- 162 Views
- Last post by arthurserafin
Fri Apr 09, 2021 11:44 am
- [Solved]Search column from specific cell and copy the result
-
- [Solved] Can an IF statement return a value based on......?
by smartcooky » Wed Apr 07, 2021 9:28 am - 4 Replies
- 168 Views
- Last post by smartcooky
Thu Apr 08, 2021 6:40 am
- [Solved] Can an IF statement return a value based on......?
-
- [Solved] Split rows for multiple categories
by TCLynx » Mon Apr 05, 2021 2:13 am
- 24 Replies
- 496 Views
- Last post by RoryOF
Wed Apr 07, 2021 3:50 pm
- [Solved] Split rows for multiple categories
-
- Need a Formula to convert text into SEO url
by carl2k17 » Tue Apr 17, 2018 4:12 pm
- 3 Replies
- 812 Views
- Last post by jansharp
Wed Apr 07, 2021 8:08 am
- Need a Formula to convert text into SEO url
-
- Move duplicate rows to new column
by MGear » Mon Apr 05, 2021 10:40 am
- 6 Replies
- 199 Views
- Last post by MrProgrammer
Tue Apr 06, 2021 9:42 pm
- Move duplicate rows to new column
-
- [Solved] What formula use with INDEX/MATCH?
by Olegs Andrejevskis » Fri Apr 02, 2021 10:41 am
- 5 Replies
- 311 Views
- Last post by MrProgrammer
Sat Apr 03, 2021 12:01 am
- [Solved] What formula use with INDEX/MATCH?
-
- Want a time cell turned to ready when it is below Zero
by neitro » Thu Apr 01, 2021 9:06 pm - 3 Replies
- 203 Views
- Last post by Villeroy
Fri Apr 02, 2021 9:58 pm
- Want a time cell turned to ready when it is below Zero
-
- Need a Formula to convert text into SEO url
by JanxRwj » Sun Mar 28, 2021 10:20 pm - 2 Replies
- 195 Views
- Last post by Zizi64
Thu Apr 01, 2021 7:34 am
- Need a Formula to convert text into SEO url
-
- [Solved] Organize sheets into tabs
by StuDucklow1 » Tue Mar 30, 2021 2:19 am - 3 Replies
- 217 Views
- Last post by Villeroy
Wed Mar 31, 2021 9:22 pm
- [Solved] Organize sheets into tabs
-
- [Solved] Filter table through a dedicated input cell value?
by Honze7 » Thu Mar 11, 2021 9:10 am
- 6 Replies
- 486 Views
- Last post by Villeroy
Tue Mar 30, 2021 6:38 pm
- [Solved] Filter table through a dedicated input cell value?
-
- Too many x-axis labels and need to reduce
by joniverson » Mon Mar 29, 2021 4:31 pm
- 15 Replies
- 289 Views
- Last post by Villeroy
Tue Mar 30, 2021 5:07 pm
- Too many x-axis labels and need to reduce
-
- [Solved] Inputting text from an email to Calc
by radardoug » Mon Mar 29, 2021 10:25 am
- 12 Replies
- 327 Views
- Last post by radardoug
Tue Mar 30, 2021 10:55 am
- [Solved] Inputting text from an email to Calc
-
- [Solved] Min/Max data validation for cells (0 to 100)
by [AS]_Princess » Sat Mar 27, 2021 5:18 pm
- 7 Replies
- 324 Views
- Last post by MrProgrammer
Sun Mar 28, 2021 6:03 pm
- [Solved] Min/Max data validation for cells (0 to 100)
-
- [Solved] Creating a stock sales P&L spreadsheet
by walscho » Sat Mar 27, 2021 6:17 pm - 1 Replies
- 183 Views
- Last post by RoryOF
Sat Mar 27, 2021 6:25 pm
- [Solved] Creating a stock sales P&L spreadsheet
-
- [Solved] Count criteria in multiple columns with blanks
by abelt » Fri Mar 26, 2021 10:31 pm - 4 Replies
- 270 Views
- Last post by abelt
Fri Mar 26, 2021 11:23 pm
- [Solved] Count criteria in multiple columns with blanks
-
- [Solved] Extend logic formula from 16 conditions to 21
by Canada » Tue Mar 23, 2021 7:37 pm
- 27 Replies
- 612 Views
- Last post by Canada
Fri Mar 26, 2021 1:49 pm
- [Solved] Extend logic formula from 16 conditions to 21
-
- [Solved] Modify paragraph style dialog box doesn't open
by floris v » Fri Mar 26, 2021 1:04 pm - 2 Replies
- 161 Views
- Last post by floris v
Fri Mar 26, 2021 1:20 pm
- [Solved] Modify paragraph style dialog box doesn't open
-
- [Solved] How to sum numbers with "." and "," correctly
by oli007 » Fri Mar 26, 2021 12:47 pm - 1 Replies
- 155 Views
- Last post by Villeroy
Fri Mar 26, 2021 1:09 pm
- [Solved] How to sum numbers with "." and "," correctly
-
- [SOLVED] Highlight entire row with the active cell
by Bambamn » Fri Mar 26, 2021 1:37 am
- 7 Replies
- 255 Views
- Last post by eeigor
Fri Mar 26, 2021 6:37 am
- [SOLVED] Highlight entire row with the active cell
-
- [Solved] Get value based on alternatives; IF function?
by Cruise105 » Tue Mar 23, 2021 9:25 am
- 2 Replies
- 247 Views
- Last post by MrProgrammer
Thu Mar 25, 2021 5:03 pm
- [Solved] Get value based on alternatives; IF function?
-
- [Solved] Exporting Calc to PDF
by prswan » Wed Mar 24, 2021 4:00 pm
- 6 Replies
- 251 Views
- Last post by prswan
Thu Mar 25, 2021 12:40 pm
- [Solved] Exporting Calc to PDF
-
- [Solved] Removing a Decimal point after a Number
by Zen1 » Wed Mar 24, 2021 2:31 pm
- 2 Replies
- 201 Views
- Last post by Zen1
Thu Mar 25, 2021 8:41 am
- [Solved] Removing a Decimal point after a Number
-
- [SOLVED] SUMIF not working consistently
by Rhed » Tue Mar 23, 2021 7:44 pm
- 5 Replies
- 254 Views
- Last post by Rhed
Thu Mar 25, 2021 4:54 am
- [SOLVED] SUMIF not working consistently
-
- [Solved] Increase value in one cell based on another cell
by Mike0 » Tue Mar 23, 2021 10:58 pm
- 7 Replies
- 270 Views
- Last post by Mike0
Wed Mar 24, 2021 10:28 pm
- [Solved] Increase value in one cell based on another cell
-
- [Dropped] Cannot open PMDX spreadsheet format
by moggie44 » Wed Mar 24, 2021 12:26 am - 1 Replies
- 175 Views
- Last post by FJCC
Wed Mar 24, 2021 12:45 am
- [Dropped] Cannot open PMDX spreadsheet format
-
- [Solved] Remove Conditional Formatting
by Faith Denham » Tue Mar 23, 2021 4:35 am - 1 Replies
- 190 Views
- Last post by FJCC
Tue Mar 23, 2021 5:10 am
- [Solved] Remove Conditional Formatting
-
- [SOLVED] MAXIFS help
by AWoodShed » Mon Mar 22, 2021 7:23 am
- 4 Replies
- 290 Views
- Last post by AWoodShed
Tue Mar 23, 2021 3:51 am
- [SOLVED] MAXIFS help
-
- [Issue] Paste cell to more than one non-contiguous cell
by HillCalc » Thu Mar 18, 2021 5:08 am
- 8 Replies
- 459 Views
- Last post by eeigor
Mon Mar 22, 2021 9:55 pm
- [Issue] Paste cell to more than one non-contiguous cell
-
- Replicate "non-repeating" row labels
by eeigor » Mon Mar 22, 2021 7:39 pm
- 4 Replies
- 273 Views
- Last post by eeigor
Mon Mar 22, 2021 9:22 pm
- Replicate "non-repeating" row labels
-
- Shortcut for time and date
by Krassegrand » Mon Mar 15, 2021 7:43 pm - 7 Replies
- 495 Views
- Last post by Krassegrand
Mon Mar 22, 2021 9:41 am
- Shortcut for time and date
-
- [Solved] Transfer formula to adjoining cell
by crabmann » Sat Mar 20, 2021 2:30 am
- 11 Replies
- 370 Views
- Last post by crabmann
Mon Mar 22, 2021 3:20 am
- [Solved] Transfer formula to adjoining cell
-
- [Solved] How do I split field text at specific char ?
by mOrloff » Sat Apr 14, 2012 12:46 am - 10 Replies
- 33066 Views
- Last post by Lupp
Sun Mar 21, 2021 9:48 pm
- [Solved] How do I split field text at specific char ?
-
- [Solved] Convert cell formula to its value
by hrbolliger » Sun Mar 21, 2021 5:51 pm - 1 Replies
- 206 Views
- Last post by Villeroy
Sun Mar 21, 2021 6:05 pm
- [Solved] Convert cell formula to its value
-
- [Solved] Set "page break" (for printout) to XX Rows
by Nemesis » Sat Mar 20, 2021 7:49 pm - 5 Replies
- 284 Views
- Last post by Villeroy
Sun Mar 21, 2021 12:51 am
- [Solved] Set "page break" (for printout) to XX Rows
-
- [Solved] Use a Row as header on all pages?
by Nemesis » Sat Mar 20, 2021 4:31 pm - 1 Replies
- 217 Views
- Last post by MrProgrammer
Sat Mar 20, 2021 4:50 pm
- [Solved] Use a Row as header on all pages?
-
- [Solved] Insert dates at specific intervals
by StuDucklow1 » Fri Mar 19, 2021 3:51 pm - 5 Replies
- 280 Views
- Last post by StuDucklow1
Sat Mar 20, 2021 3:45 pm
- [Solved] Insert dates at specific intervals
-
- [Solved] Hide rows for clearer look
by brannsiu » Thu Mar 18, 2021 7:29 am
- 12 Replies
- 459 Views
- Last post by MrProgrammer
Fri Mar 19, 2021 9:28 pm
- [Solved] Hide rows for clearer look
-
- [Solved] Foumula in one cell does not work
by johnoo » Fri Mar 19, 2021 7:58 pm - 3 Replies
- 231 Views
- Last post by johnoo
Fri Mar 19, 2021 9:21 pm
- [Solved] Foumula in one cell does not work
-
- Extend formula range on adding rows?
by mike4smg » Fri Mar 19, 2021 8:22 am - 3 Replies
- 261 Views
- Last post by Villeroy
Fri Mar 19, 2021 10:22 am
- Extend formula range on adding rows?
-
- [Solved] Calc/spreadsheet takes an hour to open
by JimmyJames » Thu Mar 18, 2021 7:21 pm - 4 Replies
- 296 Views
- Last post by JimmyJames
Thu Mar 18, 2021 8:10 pm
- [Solved] Calc/spreadsheet takes an hour to open
-
- [Solved] Warn me if I unknowingly convert formula to text?
by heplee3 » Fri Mar 12, 2021 10:21 am
- 7 Replies
- 405 Views
- Last post by Villeroy
Thu Mar 18, 2021 7:14 pm
- [Solved] Warn me if I unknowingly convert formula to text?
-
- [Solved] Remove unwanted file from Recent Documents list
by waynec444 » Thu Mar 18, 2021 3:20 pm - 5 Replies
- 285 Views
- Last post by Hagar Delest
Thu Mar 18, 2021 6:47 pm
- [Solved] Remove unwanted file from Recent Documents list
-
- [Solved] "Search key not found" but I can see it
by kmarler18 » Thu Mar 18, 2021 5:49 pm - 3 Replies
- 216 Views
- Last post by Zizi64
Thu Mar 18, 2021 6:18 pm
- [Solved] "Search key not found" but I can see it
-
- [Solved] Can't format numbers pasted in
by StuDucklow1 » Mon Mar 15, 2021 10:43 pm - 4 Replies
- 304 Views
- Last post by robleyd
Wed Mar 17, 2021 11:34 pm
- [Solved] Can't format numbers pasted in
Who is online
Users browsing this forum: Majestic-12 [Bot] and 18 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
|