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: 31260
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33085
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 29942
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 117539 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Live table extraction
by JLeite » Thu Apr 16, 2020 2:32 am - 1 Replies
- 187 Views
- Last post by robleyd
Thu Apr 16, 2020 2:54 am
- Live table extraction
-
- [Solved] Portrait/Landscape layouts in Calc
by xyzsail » Wed Apr 15, 2020 9:28 pm - 4 Replies
- 228 Views
- Last post by xyzsail
Thu Apr 16, 2020 12:43 am
- [Solved] Portrait/Landscape layouts in Calc
-
- [Issue] External workbook reference (Err:504)
by navimils » Tue Apr 14, 2020 12:35 pm
- 4 Replies
- 278 Views
- Last post by Villeroy
Tue Apr 14, 2020 5:55 pm
- [Issue] External workbook reference (Err:504)
-
- [Solved] Effective printing
by MDK » Mon Apr 13, 2020 3:47 am - 5 Replies
- 298 Views
- Last post by MDK
Mon Apr 13, 2020 4:47 pm
- [Solved] Effective printing
-
- Wanting to find the last non-empty cell in a column
by roddy » Sun Apr 12, 2020 12:09 pm
- 8 Replies
- 555 Views
- Last post by roddy
Mon Apr 13, 2020 12:24 am
- Wanting to find the last non-empty cell in a column
-
- Insert specific number of rows or columns in Calc
by roddy » Sun Apr 12, 2020 2:24 am - 3 Replies
- 237 Views
- Last post by Villeroy
Sun Apr 12, 2020 7:04 pm
- Insert specific number of rows or columns in Calc
-
- Importing stock data from yahoo finance
by uvies1 » Sun Apr 12, 2020 6:46 am - 0 Replies
- 169 Views
- Last post by uvies1
Sun Apr 12, 2020 6:46 am
- Importing stock data from yahoo finance
-
- [Solved] Program freezes when going to "save as"
by Fuzzy Money » Sat Apr 04, 2020 9:36 pm - 6 Replies
- 352 Views
- Last post by Fuzzy Money
Sun Apr 12, 2020 3:28 am
- [Solved] Program freezes when going to "save as"
-
- Corrupt Calc File
by BobInPensacola » Thu Apr 09, 2020 5:39 pm - 2 Replies
- 296 Views
- Last post by John_Ha
Sat Apr 11, 2020 6:06 pm
- Corrupt Calc File
-
- Calc page breaks
by Farmerpete » Sat Apr 11, 2020 2:27 am - 2 Replies
- 222 Views
- Last post by Farmerpete
Sat Apr 11, 2020 3:40 am
- Calc page breaks
-
- recurrance w/im MACRO
by THEBookMan » Fri Apr 10, 2020 6:49 pm
- 2 Replies
- 193 Views
- Last post by Zizi64
Fri Apr 10, 2020 7:25 pm
- recurrance w/im MACRO
-
- [Solved] Converting files from MS Excel to Calc ODS
by BrianAlt » Sat Apr 04, 2020 6:55 am
- 13 Replies
- 591 Views
- Last post by Zizi64
Thu Apr 09, 2020 1:55 pm
- [Solved] Converting files from MS Excel to Calc ODS
-
- [Solved] Count ratio of various column
by Idrees » Thu Apr 09, 2020 8:14 am
- 3 Replies
- 210 Views
- Last post by Idrees
Thu Apr 09, 2020 11:05 am
- [Solved] Count ratio of various column
-
- [Solved] Repeat Rows & Columns on same page
by mryflyguy » Mon Apr 06, 2020 6:12 pm
- 3 Replies
- 251 Views
- Last post by mryflyguy
Wed Apr 08, 2020 8:46 pm
- [Solved] Repeat Rows & Columns on same page
-
- Click one cell and the value goes to a nominated cell
by Shane-001 » Tue Apr 07, 2020 1:28 pm
- 12 Replies
- 464 Views
- Last post by Villeroy
Wed Apr 08, 2020 6:14 pm
- Click one cell and the value goes to a nominated cell
-
- How to resize comment box automatically?
by Caesarius » Tue Mar 31, 2020 5:44 pm
- 19 Replies
- 806 Views
- Last post by Lupp
Wed Apr 08, 2020 12:15 am
- How to resize comment box automatically?
-
- [Solved] Separating last numbers or word to separate cell
by Sideshow_Gary » Sun Apr 05, 2020 3:48 am - 4 Replies
- 311 Views
- Last post by Sideshow_Gary
Tue Apr 07, 2020 6:08 am
- [Solved] Separating last numbers or word to separate cell
-
- Being able to activate an mp4 file direct from Calc
by mipak » Sat Apr 04, 2020 7:36 pm - 5 Replies
- 296 Views
- Last post by Villeroy
Mon Apr 06, 2020 8:47 pm
- Being able to activate an mp4 file direct from Calc
-
- OpenOffice VS Google Sheets, any benefits?
by xuzo » Sun Apr 14, 2019 4:55 am - 4 Replies
- 772 Views
- Last post by ainventor
Mon Apr 06, 2020 6:13 pm
- OpenOffice VS Google Sheets, any benefits?
-
- [Solved] Search in a Dynamic Range
by arghmeinaugen » Sun Apr 05, 2020 11:23 am
- 8 Replies
- 341 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
- 695 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
- 365 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
- 207 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
- 330 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
- 199 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
- 279 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
- 2806 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
- 246 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
- 195 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
- 190 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
- 250 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
- 170 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
- 199 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
- 249 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
- 266 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
- 315 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
- 501 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
- 520 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
- 573 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
- 254 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
- 193 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
- 873 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
- 667 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
- 3566 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
- 1023 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
- 888 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
- 356 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
- 25966 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
- 615 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
- 463 Views
- Last post by John_Ha
Thu Mar 26, 2020 7:40 pm
- Importing Windows 10 excel spreadsheet
Who is online
Users browsing this forum: No registered users and 12 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
|