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: 30913
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 32721
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 29556
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 103771 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Search in a Dynamic Range
by arghmeinaugen » Sun Apr 05, 2020 11:23 am
- 8 Replies
- 298 Views
- Last post by Lupp
Mon Apr 06, 2020 1:55 pm
- [Solved] Search in a Dynamic Range
-
- [Solved] Re-calculating rows but moving formula...
by withnail » Sat Apr 04, 2020 12:51 pm
- 22 Replies
- 596 Views
- Last post by withnail
Mon Apr 06, 2020 10:16 am
- [Solved] Re-calculating rows but moving formula...
-
- [Solved] Count X or Y in col B with any value in col C
by Ssronica » Sun Apr 05, 2020 7:01 am
- 7 Replies
- 293 Views
- Last post by Ssronica
Mon Apr 06, 2020 12:40 am
- [Solved] Count X or Y in col B with any value in col C
-
- Importing png files to the spreadsheet
by templii » Sun Apr 05, 2020 12:32 pm - 3 Replies
- 183 Views
- Last post by John_Ha
Sun Apr 05, 2020 4:01 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
- 286 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
- 175 Views
- Last post by Zizi64
Sun Apr 05, 2020 11:15 am
- Put TAB in a cell
-
- RandBetween with Predetermined Total
by Coneskidcone » Sat Apr 04, 2020 1:03 am
- 4 Replies
- 248 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
- 2764 Views
- Last post by DavidHMcCracken
Sat Apr 04, 2020 2:48 am
- Keyboard shortcut to drop down the filter list (AutoFilter)
-
- [Solved] How to remove duplicates.... with a twist
by thefonz22 » Fri Apr 03, 2020 4:32 pm
- 4 Replies
- 220 Views
- Last post by FJCC
Fri Apr 03, 2020 6:22 pm
- [Solved] 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
- 172 Views
- Last post by RusselB
Fri Apr 03, 2020 4:15 am
- Convert Text GMT to formatted real GMT format
-
- [Solved] Stacked columns and stacked lines?
by openso » Wed Apr 01, 2020 11:34 am
- 2 Replies
- 168 Views
- Last post by openso
Wed Apr 01, 2020 4:35 pm
- [Solved] Stacked columns and stacked lines?
-
- [Solved] Formula for working out 'the best'
by neil-uk » Tue Mar 31, 2020 11:04 am
- 2 Replies
- 221 Views
- Last post by neil-uk
Tue Mar 31, 2020 5:50 pm
- [Solved] Formula for working out 'the best'
-
- [Solved] Capabilities of the Pie Chart feature
by NiMi » Tue Mar 31, 2020 2:55 pm
- 1 Replies
- 148 Views
- Last post by MrProgrammer
Tue Mar 31, 2020 4:20 pm
- [Solved] Capabilities of the Pie Chart feature
-
- [SOLVED] Nested IF functions
by EdTeach1680 » Tue Mar 31, 2020 4:41 am
- 2 Replies
- 177 Views
- Last post by EdTeach1680
Tue Mar 31, 2020 7:17 am
- [SOLVED] Nested IF functions
-
- [Solved] No Print Preview in Calc
by lcrombie » Mon Mar 30, 2020 5:49 pm - 4 Replies
- 214 Views
- Last post by RusselB
Tue Mar 31, 2020 1:31 am
- [Solved] No Print Preview in Calc
-
- Spell checker hangs
by kattiesh » Mon Mar 30, 2020 12:04 pm
- 6 Replies
- 232 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
- 289 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
- 458 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
- 407 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
- 488 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
- 226 Views
- Last post by Gingalone
Thu Mar 26, 2020 10:57 pm
- Strange warning/error when starting Calc from terminal
-
- [Solved] Convert GMT Standard/Daylight Eastern times?
by axelrose » Thu Mar 26, 2020 8:04 pm - 1 Replies
- 172 Views
- Last post by RusselB
Thu Mar 26, 2020 10:05 pm
- [Solved] Convert GMT Standard/Daylight Eastern times?
-
- [Solved] Compatibility with MS Office Excel 16
by Shedhand » Sat Aug 05, 2017 12:42 pm - 4 Replies
- 840 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
- 637 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
- 3522 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:50 pm
- Large spreadsheet does not open in OpenOffice
-
- xlsx download
by caepperson3 » Fri Nov 30, 2018 2:08 am - 10 Replies
- 967 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
- 831 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
- 330 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
- 25661 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
- 498 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
- 395 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
- 270 Views
- Last post by THEBookMan
Thu Mar 26, 2020 3:50 pm
- [Solved] Find value of formula
-
- [Solved] From colon to comma
by Janina » Wed Mar 25, 2020 4:20 pm - 6 Replies
- 380 Views
- Last post by keme
Thu Mar 26, 2020 8:05 am
- [Solved] From colon to comma
-
- [Solved] Append series of suffixes based on root
by cartoonjazz » Sun Mar 22, 2020 9:14 pm
- 7 Replies
- 392 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
- 359 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
- 333 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
- 279 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
- 597 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
- 193 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
- 299 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
- 226 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
- 390 Views
- Last post by RusselB
Sun Mar 22, 2020 10:39 pm
- .ods - If formula not working + date formats
-
- [Solved] Parsing Text
by kjnMo » Sun Mar 22, 2020 5:34 pm - 1 Replies
- 175 Views
- Last post by MrProgrammer
Sun Mar 22, 2020 6:57 pm
- [Solved] Parsing Text
-
- [Solved] Formatting date calculation
by Ssronica » Fri Mar 20, 2020 5:50 pm
- 16 Replies
- 592 Views
- Last post by Ssronica
Sat Mar 21, 2020 6:53 pm
- [Solved] Formatting date calculation
-
- Err 509 OR in SEARCH
by morphingstar » Thu Mar 12, 2020 3:04 am
- 10 Replies
- 514 Views
- Last post by Lupp
Fri Mar 20, 2020 7:04 pm
- Err 509 OR in SEARCH
-
- No Freeze in Window menu
by Zachrey » Fri Mar 20, 2020 4:17 am - 1 Replies
- 189 Views
- Last post by Zizi64
Fri Mar 20, 2020 7:06 am
- No Freeze in Window menu
-
- [Solved] IF DSUM SUMIF?
by Leighrawlins » Fri Mar 20, 2020 2:59 am
- 2 Replies
- 182 Views
- Last post by MrProgrammer
Fri Mar 20, 2020 4:33 am
- [Solved] IF DSUM SUMIF?
-
- [Solved] Hide Standard toolbar
by blelmblad » Wed Mar 18, 2020 7:54 pm - 2 Replies
- 263 Views
- Last post by MrProgrammer
Thu Mar 19, 2020 11:32 pm
- [Solved] Hide Standard toolbar
-
- [Solved] Histogram w/ standard deviation, significance mark
by Orithien » Mon Feb 03, 2020 11:16 am - 3 Replies
- 395 Views
- Last post by Orithien
Thu Mar 19, 2020 3:50 pm
- [Solved] Histogram w/ standard deviation, significance mark
Who is online
Users browsing this forum: No registered users and 6 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
|