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: 30407
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 32153
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 28884
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 70182 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 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
- 40990 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Being able to activate an mp4 file direct from Calc
by mipak » Sat Apr 04, 2020 7:36 pm - 2 Replies
- 51 Views
- Last post by mipak
Sun Apr 05, 2020 3:41 pm
- Being able to activate an mp4 file direct from Calc
-
- Search in a Dynamic Range
by arghmeinaugen » Sun Apr 05, 2020 11:23 am
- 4 Replies
- 53 Views
- Last post by Lupp
Sun Apr 05, 2020 1:39 pm
- Search in a Dynamic Range
-
- Importing png files to the spreadsheet
by templii » Sun Apr 05, 2020 12:32 pm - 2 Replies
- 28 Views
- Last post by RoryOF
Sun Apr 05, 2020 1:16 pm
- Importing png files to the spreadsheet
-
- [Solved] Multiple Cells into a Single Cell - Bulk
by arghmeinaugen » Sat Apr 04, 2020 11:44 am
- 8 Replies
- 122 Views
- Last post by arghmeinaugen
Sun Apr 05, 2020 11:20 am
- [Solved] Multiple Cells into a Single Cell - Bulk
-
- Put TAB in a cell
by carlmclark » Sat Apr 04, 2020 4:09 pm - 2 Replies
- 61 Views
- Last post by Zizi64
Sun Apr 05, 2020 11:15 am
- Put TAB in a cell
-
- Re-calculating rows but moving formula...
by withnail » Sat Apr 04, 2020 12:51 pm
- 9 Replies
- 166 Views
- Last post by withnail
Sun Apr 05, 2020 11:13 am
- Re-calculating rows but moving formula...
-
- Program freezes when going to "save as"
by Fuzzy Money » Sat Apr 04, 2020 9:36 pm - 3 Replies
- 67 Views
- Last post by RoryOF
Sun Apr 05, 2020 10:00 am
- Program freezes when going to "save as"
-
- SUMPRODUCT
by Ssronica » Sun Apr 05, 2020 7:01 am
- 6 Replies
- 68 Views
- Last post by keme
Sun Apr 05, 2020 9:02 am
- SUMPRODUCT
-
- How to resize comment box automatically?
by Caesarius » Tue Mar 31, 2020 5:44 pm
- 14 Replies
- 327 Views
- Last post by Zizi64
Sun Apr 05, 2020 6:39 am
- How to resize comment box automatically?
-
- Separating the last numbers or word to separate cell
by Sideshow_Gary » Sun Apr 05, 2020 3:48 am - 2 Replies
- 46 Views
- Last post by RusselB
Sun Apr 05, 2020 6:08 am
- Separating the last numbers or word to separate cell
-
- RandBetween with Predetermined Total
by Coneskidcone » Sat Apr 04, 2020 1:03 am
- 4 Replies
- 131 Views
- Last post by keme
Sun Apr 05, 2020 12:58 am
- RandBetween with Predetermined Total
-
- Keyboard shortcut to drop down the filter list (AutoFilter)
by CTBarbarin » Sun Nov 19, 2017 6:50 am
- 3 Replies
- 2508 Views
- Last post by DavidHMcCracken
Sat Apr 04, 2020 2:48 am
- Keyboard shortcut to drop down the filter list (AutoFilter)
-
- How to remove duplicates.... with a twist
by thefonz22 » Fri Apr 03, 2020 4:32 pm
- 4 Replies
- 106 Views
- Last post by FJCC
Fri Apr 03, 2020 6:22 pm
- How to remove duplicates.... with a twist
-
- Convert Text GMT to formatted real GMT format
by axelrose » Fri Apr 03, 2020 3:45 am - 1 Replies
- 78 Views
- Last post by RusselB
Fri Apr 03, 2020 4:15 am
- Convert Text GMT to formatted real GMT format
-
- Conditional Format for Highest Lowest
by neil-uk » Wed Apr 01, 2020 1:21 pm - 2 Replies
- 93 Views
- Last post by Villeroy
Wed Apr 01, 2020 4:57 pm
- Conditional Format for Highest Lowest
-
- Stacked columns and stacked lines?
by openso » Wed Apr 01, 2020 11:34 am
- 2 Replies
- 90 Views
- Last post by openso
Wed Apr 01, 2020 4:35 pm
- Stacked columns and stacked lines?
-
- [Solved] Formula for working out 'the best'
by neil-uk » Tue Mar 31, 2020 11:04 am
- 2 Replies
- 130 Views
- Last post by neil-uk
Tue Mar 31, 2020 5:50 pm
- [Solved] Formula for working out 'the best'
-
- Confusion with capabilities of the Pie Chart feature
by NiMi » Tue Mar 31, 2020 2:55 pm
- 1 Replies
- 84 Views
- Last post by MrProgrammer
Tue Mar 31, 2020 4:20 pm
- Confusion with capabilities of the Pie Chart feature
-
- [SOLVED] Nested IF functions
by EdTeach1680 » Tue Mar 31, 2020 4:41 am
- 2 Replies
- 100 Views
- Last post by EdTeach1680
Tue Mar 31, 2020 7:17 am
- [SOLVED] Nested IF functions
-
- No Print Preview in Calc
by lcrombie » Mon Mar 30, 2020 5:49 pm - 4 Replies
- 118 Views
- Last post by RusselB
Tue Mar 31, 2020 1:31 am
- No Print Preview in Calc
-
- Spell checker hangs
by kattiesh » Mon Mar 30, 2020 12:04 pm
- 6 Replies
- 134 Views
- Last post by RusselB
Tue Mar 31, 2020 1:29 am
- Spell checker hangs
-
- [Solved] Same font & size but text prints in different sizes
by tomlesser » Thu Mar 26, 2020 10:40 pm - 1 Replies
- 199 Views
- Last post by tomlesser
Fri Mar 27, 2020 5:34 pm
- [Solved] Same font & size but text prints in different sizes
-
- [Solved] Simple timesheet
by Spaceboy64 » Mon Mar 23, 2020 12:41 am
- 7 Replies
- 319 Views
- Last post by Villeroy
Fri Mar 27, 2020 10:27 am
- [Solved] Simple timesheet
-
- Problem with .xlsx files not opening with AOO
by John_Ha » Thu Mar 26, 2020 7:33 pm
- 6 Replies
- 196 Views
- Last post by John_Ha
Fri Mar 27, 2020 1:32 am
- Problem with .xlsx files not opening with AOO
-
- Problem. Can't open a .xlsx file
by assimilated » Wed Mar 25, 2020 11:53 pm
- 11 Replies
- 258 Views
- Last post by John_Ha
Fri Mar 27, 2020 1:05 am
- Problem. Can't open a .xlsx file
-
- Strange warning/error when starting Calc from terminal
by Gingalone » Wed Mar 25, 2020 3:31 pm - 2 Replies
- 141 Views
- Last post by Gingalone
Thu Mar 26, 2020 10:57 pm
- Strange warning/error when starting Calc from terminal
-
- Convert/Make table of GMT Standard/Daylight Eastern times?
by axelrose » Thu Mar 26, 2020 8:04 pm - 1 Replies
- 117 Views
- Last post by RusselB
Thu Mar 26, 2020 10:05 pm
- Convert/Make table of GMT Standard/Daylight Eastern times?
-
- [Solved] Compatibility with MS Office Excel 16
by Shedhand » Sat Aug 05, 2017 12:42 pm - 4 Replies
- 758 Views
- Last post by Villeroy
Thu Mar 26, 2020 9:01 pm
- [Solved] Compatibility with MS Office Excel 16
-
- Filters are worse than useless
by hfvoidfjhl » Wed Oct 28, 2015 4:11 pm - 4 Replies
- 561 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:50 pm
- Filters are worse than useless
-
- Large spreadsheet does not open in OpenOffice
by ammorei » Fri Nov 13, 2015 6:12 pm
- 6 Replies
- 3402 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:50 pm
- Large spreadsheet does not open in OpenOffice
-
- Calc truncates xls file
by nigello » Thu Apr 13, 2017 11:42 am - 8 Replies
- 1777 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:48 pm
- Calc truncates xls file
-
- xlsx download
by caepperson3 » Fri Nov 30, 2018 2:08 am - 10 Replies
- 827 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:46 pm
- xlsx download
-
- [Solved] Stuck loading excel sheets
by streaming » Wed Feb 13, 2019 11:14 am - 10 Replies
- 642 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:45 pm
- [Solved] Stuck loading excel sheets
-
- [Solved] Unable to open Excel workbook
by hkbs » Tue Aug 13, 2019 8:17 pm - 2 Replies
- 258 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:44 pm
- [Solved] Unable to open Excel workbook
-
- [Solved] Problem Opening .xlsx File
by Frankwm123 » Fri Jul 22, 2011 2:24 am - 7 Replies
- 25254 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:43 pm
- [Solved] Problem Opening .xlsx File
-
- Cant open an Excel ???.sxls file in Calc
by harolddanglar » Thu Sep 19, 2019 7:33 pm - 4 Replies
- 346 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:42 pm
- Cant open an Excel ???.sxls file in Calc
-
- Importing Windows 10 excel spreadsheet
by artachoke13 » Wed Mar 04, 2020 2:27 am - 6 Replies
- 303 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:40 pm
- Importing Windows 10 excel spreadsheet
-
- [Solved] Find value of formula
by THEBookMan » Fri Mar 20, 2020 6:56 pm - 2 Replies
- 208 Views
- Last post by THEBookMan
Thu Mar 26, 2020 3:50 pm
- [Solved] Find value of formula
-
- From colon to comma
by Janina » Wed Mar 25, 2020 4:20 pm - 6 Replies
- 281 Views
- Last post by keme
Thu Mar 26, 2020 8:05 am
- From colon to comma
-
- [Solved] Append series of suffixes based on root
by cartoonjazz » Sun Mar 22, 2020 9:14 pm
- 7 Replies
- 273 Views
- Last post by cartoonjazz
Wed Mar 25, 2020 10:16 pm
- [Solved] Append series of suffixes based on root
-
- [Solved] Copy cell above macro to be refined
by Gingalone » Tue Mar 24, 2020 8:38 pm - 8 Replies
- 250 Views
- Last post by MrProgrammer
Wed Mar 25, 2020 5:03 pm
- [Solved] Copy cell above macro to be refined
-
- [Solved] Comparing Calc documents with different formats
by HalloCoffee » Tue Mar 24, 2020 2:42 pm
- 9 Replies
- 237 Views
- Last post by Villeroy
Wed Mar 25, 2020 10:52 am
- [Solved] Comparing Calc documents with different formats
-
- Multiple IF Statements
by crbenn01 » Tue Mar 24, 2020 8:15 pm
- 4 Replies
- 200 Views
- Last post by keme
Wed Mar 25, 2020 9:13 am
- Multiple IF Statements
-
- Error message
by jon80 » Sun Mar 22, 2020 9:56 am
- 9 Replies
- 327 Views
- Last post by Hagar Delest
Tue Mar 24, 2020 3:03 pm
- Error message
-
- Calc - Default cell size and font
by jerrytex » Mon Mar 23, 2020 10:21 pm - 2 Replies
- 127 Views
- Last post by Zizi64
Tue Mar 24, 2020 2:39 pm
- Calc - Default cell size and font
-
- [Solved] Filter Data By color
by PencilGal » Mon Mar 23, 2020 10:07 pm
- 4 Replies
- 184 Views
- Last post by Villeroy
Tue Mar 24, 2020 10:23 am
- [Solved] Filter Data By color
-
- Current cell always locked scrolling
by walls » Sun Mar 22, 2020 8:01 pm - 3 Replies
- 183 Views
- Last post by walls
Mon Mar 23, 2020 12:40 pm
- Current cell always locked scrolling
-
- .ods - If formula not working + date formats
by rrabbit » Sun Mar 22, 2020 7:49 pm
- 8 Replies
- 290 Views
- Last post by RusselB
Sun Mar 22, 2020 10:39 pm
- .ods - If formula not working + date formats
Who is online
Users browsing this forum: FJCC and 24 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
|