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: 36059
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 38116
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 35075
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 28432 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
- 51056 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Calendar date selection dialog
by ggeerits » Wed Apr 21, 2021 11:07 am
- 3 Replies
- 100 Views
- Last post by Villeroy
Wed Apr 21, 2021 5:31 pm
- Calendar date selection dialog
-
- [Solved] No data in pivot table
by McBryde » Sat Apr 17, 2021 6:02 pm
- 9 Replies
- 232 Views
- Last post by John_Ha
Tue Apr 20, 2021 10:09 am
- [Solved] No data in pivot table
-
- [Solved] NOW() produces negative numbers
by Hilly Bill » Sun Apr 18, 2021 9:31 am
- 7 Replies
- 191 Views
- Last post by John_Ha
Mon Apr 19, 2021 12:24 am
- [Solved] NOW() produces negative numbers
-
- How to display filtered Pivot table data on separate sheets?
by eeigor » Sat Apr 17, 2021 9:29 am
- 7 Replies
- 205 Views
- Last post by Villeroy
Sun Apr 18, 2021 10:30 pm
- How to display filtered Pivot table data on separate sheets?
-
- [Solved] Copying From Calc, And Pasting Into MS Word. How ?
by Robert11 » Sat Apr 17, 2021 11:40 pm - 5 Replies
- 149 Views
- Last post by Robert11
Sun Apr 18, 2021 9:06 pm
- [Solved] Copying From Calc, And Pasting Into MS Word. How ?
-
- [Solved] Importing CSV file from my Fidelity Account
by realitybytez » Sat Apr 17, 2021 6:59 pm - 7 Replies
- 127 Views
- Last post by peterj3527
Sun Apr 18, 2021 12:04 pm
- [Solved] Importing CSV file from my Fidelity Account
-
- [Solved] Filtering without using the Filter in Tools
by Mandy22 » Sat Apr 17, 2021 12:27 pm
- 2 Replies
- 88 Views
- Last post by Mandy22
Sat Apr 17, 2021 2:37 pm
- [Solved] Filtering without using the Filter in Tools
-
- [Solved] Inserting rows breaks my spreadsheet..
by abrogard » Thu Apr 15, 2021 10:28 pm
- 2 Replies
- 133 Views
- Last post by abrogard
Sat Apr 17, 2021 12:09 am
- [Solved] Inserting rows breaks my spreadsheet..
-
- [Solved] Add data points to chart in spreadsheet
by legalnan » Sun Apr 11, 2021 10:23 pm
- 8 Replies
- 279 Views
- Last post by legalnan
Fri Apr 16, 2021 8:12 pm
- [Solved] Add data points to chart in spreadsheet
-
- Where is my autosave backup
1, 2 by waynec444 » Tue Apr 13, 2021 6:50 pm
- 42 Replies
- 504 Views
- Last post by waynec444
Fri Apr 16, 2021 2:34 pm
- Where is my autosave backup
-
- [Solved] Conditional Formatting formula not updating
by Acidello » Thu Apr 15, 2021 12:59 pm - 7 Replies
- 177 Views
- Last post by eeigor
Fri Apr 16, 2021 6:59 am
- [Solved] Conditional Formatting formula not updating
-
- Import/Pull BitCoin price into a spreadsheet
by Baryngyl » Thu Dec 26, 2019 11:38 am - 2 Replies
- 14129 Views
- Last post by adamspike
Fri Apr 16, 2021 1:39 am
- Import/Pull BitCoin price into a spreadsheet
-
- Merge cells in a row, for many rows
by TrishaSeliya » Thu Apr 15, 2021 3:48 pm - 1 Replies
- 113 Views
- Last post by FJCC
Thu Apr 15, 2021 4:18 pm
- Merge cells in a row, for many rows
-
- Trying to import data from website
by dannyboi93 » Mon Apr 12, 2021 1:22 pm
- 2 Replies
- 178 Views
- Last post by MrProgrammer
Thu Apr 15, 2021 12:19 am
- Trying to import data from website
-
- [Solved] Filter table through a dedicated input cell value?
by Honze7 » Thu Mar 11, 2021 9:10 am
- 8 Replies
- 673 Views
- Last post by Villeroy
Wed Apr 14, 2021 10:31 pm
- [Solved] Filter table through a dedicated input cell value?
-
- Intrinsic Value Calculator
by martyd0060 » Wed Apr 14, 2021 8:54 pm - 1 Replies
- 90 Views
- Last post by FJCC
Wed Apr 14, 2021 10:24 pm
- Intrinsic Value Calculator
-
- Adding up totals for multiple users
by mrmagnum1973 » Wed Apr 14, 2021 4:24 pm
- 2 Replies
- 124 Views
- Last post by mrmagnum1973
Wed Apr 14, 2021 5:14 pm
- Adding up totals for multiple users
-
- [Solved] Move duplicate rows to new column
by MGear » Mon Apr 05, 2021 10:40 am
- 7 Replies
- 330 Views
- Last post by MGear
Wed Apr 14, 2021 9:51 am
- [Solved] Move duplicate rows to new column
-
- [Solved] Calc file not opening: "not responding"
by sjgrt » Tue Apr 13, 2021 4:09 am - 2 Replies
- 134 Views
- Last post by sjgrt
Tue Apr 13, 2021 8:59 pm
- [Solved] Calc file not opening: "not responding"
-
- [Solved] Preview in web browser issue
by AlexandraNyx » Mon Apr 12, 2021 6:38 pm - 3 Replies
- 142 Views
- Last post by AlexandraNyx
Tue Apr 13, 2021 8:06 pm
- [Solved] Preview in web browser issue
-
- [Solved] My customers can't open XLSX files I create
by Emilio » Mon Apr 12, 2021 11:28 pm
- 9 Replies
- 242 Views
- Last post by Emilio
Tue Apr 13, 2021 7:16 pm
- [Solved] My customers can't open XLSX files I create
-
- [Solved] Incrementing dates in NON-Adjacent cells in calc
by dmb1319 » Mon Apr 12, 2021 6:14 pm
- 8 Replies
- 202 Views
- Last post by robleyd
Tue Apr 13, 2021 12:31 am
- [Solved] Incrementing dates in NON-Adjacent cells in calc
-
- [Solved] Shift list with color problems
by DigiNorse » Mon Apr 12, 2021 9:30 am
- 3 Replies
- 157 Views
- Last post by MrProgrammer
Mon Apr 12, 2021 5:05 pm
- [Solved] Shift list with color problems
-
- [Solved] Remove email link but leave formatting
by bobjbkln » Mon Apr 12, 2021 4:56 am - 4 Replies
- 152 Views
- Last post by bobjbkln
Mon Apr 12, 2021 4:32 pm
- [Solved] Remove email link but leave formatting
-
- [Solved] What formula to use for table lookup?
by Olegs Andrejevskis » Sun Apr 11, 2021 3:57 pm
- 1 Replies
- 132 Views
- Last post by MrProgrammer
Sun Apr 11, 2021 6:31 pm
- [Solved] 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
- 237 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
- 24751 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
- 50174 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
- 275 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 & copy the result
by manosdet » Tue Apr 06, 2021 5:46 pm
- 5 Replies
- 238 Views
- Last post by arthurserafin
Fri Apr 09, 2021 11:44 am
- [Solved] Search column from specific cell & copy the result
-
- [Solved] Can an IF statement return a value based on......?
by smartcooky » Wed Apr 07, 2021 9:28 am - 4 Replies
- 240 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
- 627 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
- 865 Views
- Last post by jansharp
Wed Apr 07, 2021 8:08 am
- Need a Formula to convert text into SEO url
-
- [Solved] What formula use with INDEX/MATCH?
by Olegs Andrejevskis » Fri Apr 02, 2021 10:41 am
- 5 Replies
- 408 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
- 276 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
- 274 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
- 295 Views
- Last post by Villeroy
Wed Mar 31, 2021 9:22 pm
- [Solved] Organize sheets into tabs
-
- [Solved] Too many x-axis labels and need to reduce
by joniverson » Mon Mar 29, 2021 4:31 pm
- 15 Replies
- 429 Views
- Last post by Villeroy
Tue Mar 30, 2021 5:07 pm
- [Solved] 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
- 437 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
- 391 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
- 238 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
- 335 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
- 777 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
- 226 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
- 207 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
- 319 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
- 307 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
- 326 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
- 262 Views
- Last post by Zen1
Thu Mar 25, 2021 8:41 am
- [Solved] Removing a Decimal point after a Number
Who is online
Users browsing this forum: No registered users and 14 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
|