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: 28118
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 29642
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26242
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 85792 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] ODS Can't be written
by THEBookMan » Mon Jun 11, 2018 5:35 pm - 6 Replies
- 579 Views
- Last post by John_Ha
Tue Mar 26, 2019 1:36 pm
- [Solved] ODS Can't be written
-
- Protect spreadsheets from piracy
by krabban » Mon Mar 25, 2019 1:51 pm - 3 Replies
- 180 Views
- Last post by krabban
Tue Mar 26, 2019 9:40 am
- Protect spreadsheets from piracy
-
- Isolate entry on a drop down
by wildwildcoast » Tue Mar 26, 2019 6:24 am - 0 Replies
- 109 Views
- Last post by wildwildcoast
Tue Mar 26, 2019 6:24 am
- Isolate entry on a drop down
-
- [Solved] Average a column but ignore cells with zero
by manntis » Tue Mar 26, 2019 1:14 am - 3 Replies
- 142 Views
- Last post by robleyd
Tue Mar 26, 2019 3:33 am
- [Solved] Average a column but ignore cells with zero
-
- [Solved] Cell border frustrations
by manntis » Mon Mar 25, 2019 9:04 pm
- 7 Replies
- 179 Views
- Last post by manntis
Tue Mar 26, 2019 1:07 am
- [Solved] Cell border frustrations
-
- Format Error in Sub-Document content.xml
by Faraway » Mon Mar 25, 2019 2:50 am
- 6 Replies
- 207 Views
- Last post by Faraway
Mon Mar 25, 2019 10:55 pm
- Format Error in Sub-Document content.xml
-
- [Solved] Help with formula in spreadsheet
by krabban » Fri Mar 22, 2019 4:08 pm
- 12 Replies
- 466 Views
- Last post by krabban
Mon Mar 25, 2019 3:03 pm
- [Solved] Help with formula in spreadsheet
-
- [Solved] How to Total a Column
by Sheri_Lynn » Thu Jul 07, 2011 5:24 pm
- 10 Replies
- 50476 Views
- Last post by Villeroy
Mon Mar 25, 2019 2:00 am
- [Solved] How to Total a Column
-
- How to move a spreadsheet down
by confused0809 » Sat Mar 23, 2019 11:04 pm - 2 Replies
- 198 Views
- Last post by MrProgrammer
Sun Mar 24, 2019 3:51 pm
- How to move a spreadsheet down
-
- Duplicates
by lcwilcox » Sat Mar 23, 2019 10:07 pm - 1 Replies
- 149 Views
- Last post by Villeroy
Sun Mar 24, 2019 1:46 pm
- Duplicates
-
- [Solved] Decline predictive text in Calc
by conbobulator » Sat Mar 23, 2019 7:47 pm - 3 Replies
- 150 Views
- Last post by conbobulator
Sat Mar 23, 2019 10:10 pm
- [Solved] Decline predictive text in Calc
-
- [Solved] Cannot Print correct information from Spreadsheet
by confused0809 » Sat Mar 23, 2019 7:52 pm - 1 Replies
- 182 Views
- Last post by MrProgrammer
Sat Mar 23, 2019 10:07 pm
- [Solved] Cannot Print correct information from Spreadsheet
-
- [Solved] Formula Help
by lcwilcox » Sat Mar 23, 2019 3:49 am
- 4 Replies
- 178 Views
- Last post by lcwilcox
Sat Mar 23, 2019 4:26 pm
- [Solved] Formula Help
-
- Font size does not survive pdf
by skeeve » Sun Feb 10, 2019 11:45 pm
- 6 Replies
- 386 Views
- Last post by skeeve
Fri Mar 22, 2019 8:01 pm
- Font size does not survive pdf
-
- Insert Images from Path
by doryz » Tue Mar 19, 2019 11:23 am
- 11 Replies
- 903 Views
- Last post by Lupp
Fri Mar 22, 2019 5:39 pm
- Insert Images from Path
-
- [Solved] Userdefined num format for number of days and hours
by JulianR » Thu Mar 21, 2019 5:09 pm
- 2 Replies
- 277 Views
- Last post by JulianR
Fri Mar 22, 2019 9:01 am
- [Solved] Userdefined num format for number of days and hours
-
- [Solved] OpenDocument Spreadsheet
by Gary Lee » Tue Mar 19, 2019 4:10 pm - 3 Replies
- 527 Views
- Last post by Gary Lee
Fri Mar 22, 2019 3:56 am
- [Solved] OpenDocument Spreadsheet
-
- Ods file corruption? Textimport
by Hitchakbar » Thu Mar 21, 2019 7:17 pm - 2 Replies
- 228 Views
- Last post by John_Ha
Thu Mar 21, 2019 9:35 pm
- Ods file corruption? Textimport
-
- [Solved] 3 Lists with Results in 4th List?
by Moon Lit Nights » Thu Mar 21, 2019 3:34 pm
- 4 Replies
- 198 Views
- Last post by Moon Lit Nights
Thu Mar 21, 2019 8:43 pm
- [Solved] 3 Lists with Results in 4th List?
-
- Formula error
by Dhanaraj » Wed Mar 20, 2019 7:52 am - 2 Replies
- 364 Views
- Last post by RusselB
Wed Mar 20, 2019 1:40 pm
- Formula error
-
- How to calculate workday
by faried » Fri Mar 08, 2019 5:41 am
- 5 Replies
- 616 Views
- Last post by faried
Wed Mar 20, 2019 7:39 am
- How to calculate workday
-
- [Solved] Autonumbering based off criteria in 3 other columns
by nasch » Fri Mar 15, 2019 8:24 pm - 7 Replies
- 591 Views
- Last post by nasch
Tue Mar 19, 2019 11:04 pm
- [Solved] Autonumbering based off criteria in 3 other columns
-
- Show Bitcoin price "at the time"
by snowman123 » Sat Dec 16, 2017 10:26 pm
- 10 Replies
- 3056 Views
- Last post by John_Ha
Mon Mar 18, 2019 6:30 pm
- Show Bitcoin price "at the time"
-
- Compare two columns and post matches to third
by wilmath » Sun Mar 17, 2019 3:15 am
- 11 Replies
- 706 Views
- Last post by Villeroy
Mon Mar 18, 2019 3:58 pm
- Compare two columns and post matches to third
-
- [Solved] Amount to appear in a column when I type a word in
by DubDar » Sun Mar 17, 2019 8:50 pm - 2 Replies
- 369 Views
- Last post by DubDar
Mon Mar 18, 2019 1:42 am
- [Solved] Amount to appear in a column when I type a word in
-
- [Solved] Import api
by dennisov » Fri Mar 02, 2018 10:47 am
- 5 Replies
- 803 Views
- Last post by dougabc123
Sun Mar 17, 2019 6:35 am
- [Solved] Import api
-
- [Solved] Cells show formula instead of result
by mattandgizmo » Wed Apr 14, 2010 3:10 pm - 7 Replies
- 15565 Views
- Last post by Villeroy
Sat Mar 16, 2019 8:36 pm
- [Solved] Cells show formula instead of result
-
- [Solved] Need single quote to stay in cell
by calcykeef » Fri Mar 15, 2019 12:52 pm - 3 Replies
- 377 Views
- Last post by calcykeef
Fri Mar 15, 2019 1:39 pm
- [Solved] Need single quote to stay in cell
-
- Maintaining references to a cell when its contents are moved
by KnowThyself » Thu Mar 14, 2019 11:44 pm - 1 Replies
- 375 Views
- Last post by MrProgrammer
Fri Mar 15, 2019 12:40 am
- Maintaining references to a cell when its contents are moved
-
- [Solved] Hyperling not following target cell
by george9999 » Thu Mar 14, 2019 3:55 pm - 2 Replies
- 370 Views
- Last post by george9999
Thu Mar 14, 2019 4:48 pm
- [Solved] Hyperling not following target cell
-
- Additional Link cells not working
by ralphd » Wed Mar 13, 2019 12:04 pm
- 3 Replies
- 361 Views
- Last post by Villeroy
Wed Mar 13, 2019 9:13 pm
- Additional Link cells not working
-
- Error Finding
by rcrmonte3 » Tue Mar 12, 2019 6:21 pm - 2 Replies
- 291 Views
- Last post by RusselB
Tue Mar 12, 2019 10:24 pm
- Error Finding
-
- Fatal error Vector<T> too long
by Halley70 » Tue Dec 31, 2013 12:09 am
- 15 Replies
- 10354 Views
- Last post by drakebrimstone
Tue Mar 12, 2019 7:03 pm
- Fatal error Vector<T> too long
-
- [Solved] Lookup if Date falls between 2 Dates
by nasch » Tue Mar 12, 2019 2:57 pm - 2 Replies
- 270 Views
- Last post by nasch
Tue Mar 12, 2019 4:17 pm
- [Solved] Lookup if Date falls between 2 Dates
-
- [Solved] Trying to Insert Row: "Filled cells cannot be
by JohnTN » Tue Mar 12, 2019 4:24 am - 5 Replies
- 276 Views
- Last post by JohnTN
Tue Mar 12, 2019 4:16 pm
- [Solved] Trying to Insert Row: "Filled cells cannot be
-
- [Solved] Find and copy an entire row.
by r0bs » Mon Jan 28, 2013 8:05 pm
- 5 Replies
- 1531 Views
- Last post by hksbindra
Tue Mar 12, 2019 2:20 pm
- [Solved] Find and copy an entire row.
-
- [Solved] Tooltip colours impossible to read
by kingfisher » Tue Mar 05, 2019 11:37 pm - 3 Replies
- 247 Views
- Last post by kingfisher
Tue Mar 12, 2019 11:09 am
- [Solved] Tooltip colours impossible to read
-
- Giving text a numeric value
by c00lbooks » Mon Mar 11, 2019 8:09 pm - 1 Replies
- 200 Views
- Last post by MrProgrammer
Mon Mar 11, 2019 8:38 pm
- Giving text a numeric value
-
- Cell range based on number of filled cells?
by Quizer » Sun Mar 10, 2019 11:58 pm
- 7 Replies
- 333 Views
- Last post by RusselB
Mon Mar 11, 2019 3:10 pm
- Cell range based on number of filled cells?
-
- Moving multiple rows in Calc
by kingwillard » Thu Mar 07, 2019 9:29 am - 11 Replies
- 469 Views
- Last post by robleyd
Mon Mar 11, 2019 12:52 am
- Moving multiple rows in Calc
-
- [Solved] Average of the column not including largest value
by blueboss » Sun Mar 10, 2019 11:25 pm
- 4 Replies
- 236 Views
- Last post by blueboss
Mon Mar 11, 2019 12:25 am
- [Solved] Average of the column not including largest value
-
- Locating merged cells
by DDiehl » Mon Sep 11, 2017 9:14 pm - 6 Replies
- 1357 Views
- Last post by plankieee
Sun Mar 10, 2019 2:02 pm
- Locating merged cells
-
- [Solved] Form control data not being saved
by paulh » Sat Mar 09, 2019 9:10 pm - 4 Replies
- 234 Views
- Last post by paulh
Sun Mar 10, 2019 1:24 pm
- [Solved] Form control data not being saved
-
- [Solved] OpenOffice Calc breaks formula on sheet copy
by Loki'sCat » Sat Mar 09, 2019 9:37 pm - 2 Replies
- 212 Views
- Last post by Loki'sCat
Sat Mar 09, 2019 11:40 pm
- [Solved] OpenOffice Calc breaks formula on sheet copy
-
- [Solved] Cell A = cell B sorted and now no longer =B
by blueboss » Thu Mar 07, 2019 5:10 pm
- 4 Replies
- 334 Views
- Last post by blueboss
Sat Mar 09, 2019 11:14 pm
- [Solved] Cell A = cell B sorted and now no longer =B
-
- [Solved] Cannot open ODS files to OpenOffice Calc
by Jerry42 » Fri Mar 08, 2019 10:34 pm - 2 Replies
- 234 Views
- Last post by Jerry42
Fri Mar 08, 2019 11:12 pm
- [Solved] Cannot open ODS files to OpenOffice Calc
-
- xslt Filter of gpx file gives empty output
by jotess » Mon Mar 04, 2019 12:52 am - 2 Replies
- 256 Views
- Last post by hol.sten
Thu Mar 07, 2019 8:58 pm
- xslt Filter of gpx file gives empty output
-
- Vector<T> too long / bad allocation error
by SMH » Tue Mar 05, 2019 11:47 pm
- 17 Replies
- 761 Views
- Last post by John_Ha
Thu Mar 07, 2019 2:06 pm
- Vector<T> too long / bad allocation error
-
- [Solved] Need help with Functions or a Formula, not sure
by MountainMan » Wed Mar 06, 2019 6:38 am
- 8 Replies
- 396 Views
- Last post by MountainMan
Thu Mar 07, 2019 6:26 am
- [Solved] Need help with Functions or a Formula, not sure
-
- Exporting data from Calc to Base
by HollyK » Wed Mar 06, 2019 5:28 am - 11 Replies
- 412 Views
- Last post by Villeroy
Thu Mar 07, 2019 12:35 am
- Exporting data from Calc to Base
Who is online
Users browsing this forum: Google [Bot] 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
|