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: 27958
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 29446
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26041
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 79479 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Show Comment On Screen, But Don't Print
by Longspeak » Thu May 23, 2019 2:52 am - 3 Replies
- 455 Views
- Last post by RoryOF
Thu May 23, 2019 11:08 pm
- [Solved] Show Comment On Screen, But Don't Print
-
- [Solved] Set Cell Color based on RGB values in a cell
by Myndex » Fri May 17, 2019 10:41 am
- 22 Replies
- 941 Views
- Last post by Myndex
Thu May 23, 2019 4:55 am
- [Solved] Set Cell Color based on RGB values in a cell
-
- Copying cells implicitly turns them into bitmaps!
by FrustratedUser » Thu May 16, 2019 11:42 pm - 2 Replies
- 352 Views
- Last post by keme
Tue May 21, 2019 3:23 pm
- Copying cells implicitly turns them into bitmaps!
-
- [SOLVED] NOW() Function - too many decimal places
by RayBir » Mon May 20, 2019 12:27 pm
- 8 Replies
- 586 Views
- Last post by RayBir
Tue May 21, 2019 10:09 am
- [SOLVED] NOW() Function - too many decimal places
-
- How to Edit Spreadsheet
by Sanglen51 » Mon May 20, 2019 11:49 pm - 4 Replies
- 345 Views
- Last post by RoryOF
Tue May 21, 2019 9:24 am
- How to Edit Spreadsheet
-
- [Solved) Several attributes in same cell
by RayBir » Tue May 21, 2019 5:39 am - 4 Replies
- 344 Views
- Last post by RayBir
Tue May 21, 2019 7:38 am
- [Solved) Several attributes in same cell
-
- [Solved] Constants in formulas
by nolac » Sat May 18, 2019 6:51 pm - 3 Replies
- 364 Views
- Last post by nolac
Tue May 21, 2019 1:01 am
- [Solved] Constants in formulas
-
- Highlight entire row if two columns have certain values
by dm983 » Mon May 20, 2019 6:54 pm - 1 Replies
- 267 Views
- Last post by Villeroy
Mon May 20, 2019 10:27 pm
- Highlight entire row if two columns have certain values
-
- [Solved] Extract a number from a text string
by silverb » Fri Mar 11, 2011 2:51 pm
- 26 Replies
- 16071 Views
- Last post by ChrisD
Sat May 18, 2019 11:26 pm
- [Solved] Extract a number from a text string
-
- [Solved] Delete apostrophe before numbers in all cells?
by Kingrazor » Fri Mar 16, 2012 4:38 am - 25 Replies
- 111172 Views
- Last post by Villeroy
Sat May 18, 2019 9:18 pm
- [Solved] Delete apostrophe before numbers in all cells?
-
- Combining columns text and numbers
by coyotes_uk » Fri May 17, 2019 11:57 pm - 7 Replies
- 378 Views
- Last post by MrProgrammer
Sat May 18, 2019 3:40 pm
- Combining columns text and numbers
-
- [Solved] Default Fonts
by jonesp57 » Fri May 17, 2019 2:41 pm - 3 Replies
- 279 Views
- Last post by jonesp57
Fri May 17, 2019 7:23 pm
- [Solved] Default Fonts
-
- [Solved] Keep data reference when inserting rows
by bennynoise » Thu May 16, 2019 2:42 pm
- 3 Replies
- 269 Views
- Last post by bennynoise
Fri May 17, 2019 9:25 am
- [Solved] Keep data reference when inserting rows
-
- [Solved] How can turn URLs into hyperlinks in Calc?
by erichepperle » Fri Feb 15, 2019 11:49 pm
- 4 Replies
- 421 Views
- Last post by THEBookMan
Thu May 16, 2019 5:55 pm
- [Solved] How can turn URLs into hyperlinks in Calc?
-
- Calc numbers (rounding)
by elliot13458 » Thu May 16, 2019 12:24 am
- 3 Replies
- 249 Views
- Last post by RusselB
Thu May 16, 2019 3:01 am
- Calc numbers (rounding)
-
- Multiple Data to Consolidate
by justine77 » Wed May 15, 2019 9:42 pm
- 2 Replies
- 250 Views
- Last post by MrProgrammer
Thu May 16, 2019 1:41 am
- Multiple Data to Consolidate
-
- [Solved] Can't convert text to numbers Tried text to columns
by Craig777 » Wed May 15, 2019 11:14 pm - 2 Replies
- 215 Views
- Last post by Craig777
Thu May 16, 2019 12:24 am
- [Solved] Can't convert text to numbers Tried text to columns
-
- Referencing a table and returning the result
by pherriot » Wed May 15, 2019 11:40 am
- 1 Replies
- 225 Views
- Last post by FJCC
Wed May 15, 2019 2:45 pm
- Referencing a table and returning the result
-
- [Solved] Exclude Blanks from copying
by tehmontyj » Tue May 14, 2019 9:55 am
- 2 Replies
- 661 Views
- Last post by tehmontyj
Tue May 14, 2019 4:47 pm
- [Solved] Exclude Blanks from copying
-
- [Solved] Summing a segment of row data
by Vexed » Tue May 14, 2019 1:19 pm
- 2 Replies
- 245 Views
- Last post by Vexed
Tue May 14, 2019 3:38 pm
- [Solved] Summing a segment of row data
-
- Remove single empty column on 2nd page
by videobruce » Sun May 12, 2019 7:32 pm
- 19 Replies
- 512 Views
- Last post by videobruce
Mon May 13, 2019 9:23 pm
- Remove single empty column on 2nd page
-
- [Solved] Stop rounding up in age within a formula
by Skompy » Fri May 03, 2019 4:11 pm - 24 Replies
- 695 Views
- Last post by Skompy
Mon May 13, 2019 2:29 pm
- [Solved] Stop rounding up in age within a formula
-
- [Solved] CONCATENATE to build ext reference using cell range
by pherriot » Fri May 10, 2019 1:39 pm
- 5 Replies
- 316 Views
- Last post by pherriot
Mon May 13, 2019 11:51 am
- [Solved] CONCATENATE to build ext reference using cell range
-
- OpenOffice 4.1.1 has stopped working
by amurray » Sun May 12, 2019 7:25 pm - 5 Replies
- 268 Views
- Last post by RusselB
Mon May 13, 2019 12:02 am
- OpenOffice 4.1.1 has stopped working
-
- [Solved] Text comprising number results from other cells
by ZekeMan » Fri May 10, 2019 11:23 am - 3 Replies
- 246 Views
- Last post by ZekeMan
Sun May 12, 2019 5:00 pm
- [Solved] Text comprising number results from other cells
-
- [Solved] Error 506
by ejmasjr » Sun May 12, 2019 5:02 am
- 9 Replies
- 537 Views
- Last post by MrProgrammer
Sun May 12, 2019 4:08 pm
- [Solved] Error 506
-
- Prints Data not selected in spreadsheet.
by silverbar » Sat May 11, 2019 10:03 pm - 1 Replies
- 228 Views
- Last post by UnklDonald418
Sun May 12, 2019 4:04 am
- Prints Data not selected in spreadsheet.
-
- [Solved] Check for specific text within text in a cell
by cid » Sun May 12, 2019 12:39 am - 2 Replies
- 265 Views
- Last post by cid
Sun May 12, 2019 2:22 am
- [Solved] Check for specific text within text in a cell
-
- [Solved] SUM specific cells based on values in other columns
by cid » Sat May 11, 2019 12:57 pm - 2 Replies
- 241 Views
- Last post by cid
Sun May 12, 2019 12:24 am
- [Solved] SUM specific cells based on values in other columns
-
- [Solved] condition if decimal .5
by jimbokea » Sat May 11, 2019 12:17 am - 6 Replies
- 272 Views
- Last post by jimbokea
Sun May 12, 2019 12:17 am
- [Solved] condition if decimal .5
-
- [Solved] HYPERLINK background or cell fill color
by me231 » Fri May 10, 2019 1:35 pm - 2 Replies
- 225 Views
- Last post by me231
Fri May 10, 2019 7:34 pm
- [Solved] HYPERLINK background or cell fill color
-
- [Solved] COUNTIF within an IF
by keithbakerlv » Fri May 10, 2019 4:04 pm - 2 Replies
- 243 Views
- Last post by keithbakerlv
Fri May 10, 2019 7:09 pm
- [Solved] COUNTIF within an IF
-
- [Solved] Does not format correctly when opening file
by justinnnn » Fri May 10, 2019 4:18 pm - 2 Replies
- 246 Views
- Last post by justinnnn
Fri May 10, 2019 4:54 pm
- [Solved] Does not format correctly when opening file
-
- How to create a dropdown menu to fill a row
by jackcubano » Thu May 09, 2019 9:04 pm
- 3 Replies
- 276 Views
- Last post by jackcubano
Fri May 10, 2019 4:44 pm
- How to create a dropdown menu to fill a row
-
- [Solved] Generate words with odds(chance) without repeating
by Tugasmo » Tue May 07, 2019 12:52 pm
- 2 Replies
- 257 Views
- Last post by Tugasmo
Fri May 10, 2019 11:39 am
- [Solved] Generate words with odds(chance) without repeating
-
- [Solved] Help needed in changing cell values
by Arshad » Thu May 09, 2019 7:58 am
- 5 Replies
- 295 Views
- Last post by robleyd
Fri May 10, 2019 8:11 am
- [Solved] Help needed in changing cell values
-
- [Solved] Modifying a style
by jimbokea » Thu May 09, 2019 3:26 am - 5 Replies
- 240 Views
- Last post by Zizi64
Fri May 10, 2019 6:40 am
- [Solved] Modifying a style
-
- [Solved] System Bug?
by joryan1 » Tue May 07, 2019 10:40 pm - 2 Replies
- 237 Views
- Last post by joryan1
Thu May 09, 2019 9:19 pm
- [Solved] System Bug?
-
- replace values accordingly by a function.
by pathum kalhan » Thu May 09, 2019 9:09 am - 2 Replies
- 155 Views
- Last post by MrProgrammer
Thu May 09, 2019 6:37 pm
- replace values accordingly by a function.
-
- [Solved] Search & replace quandary
by Skompy » Sat May 04, 2019 9:10 pm
- 12 Replies
- 336 Views
- Last post by Skompy
Thu May 09, 2019 2:08 pm
- [Solved] Search & replace quandary
-
- [Solved] SUM IF multiple selections
by pherriot » Wed May 08, 2019 2:36 pm
- 3 Replies
- 266 Views
- Last post by pherriot
Thu May 09, 2019 8:40 am
- [Solved] SUM IF multiple selections
-
- Previous file reload
by Dim67 » Wed May 08, 2019 7:15 pm - 3 Replies
- 187 Views
- Last post by Villeroy
Wed May 08, 2019 9:29 pm
- Previous file reload
-
- Formula help for invoice to statement
by erikashae808 » Fri May 03, 2019 8:17 pm
- 16 Replies
- 639 Views
- Last post by keme
Wed May 08, 2019 3:42 pm
- Formula help for invoice to statement
-
- Excel 2016 xls encrypted file not supported in OpenOffice
by Poonam » Tue May 07, 2019 9:05 am - 4 Replies
- 230 Views
- Last post by Poonam
Wed May 08, 2019 9:44 am
- Excel 2016 xls encrypted file not supported in OpenOffice
-
- Round to the closest nickel
by RusselB » Wed May 08, 2019 7:38 am - 1 Replies
- 129 Views
- Last post by Villeroy
Wed May 08, 2019 7:50 am
- Round to the closest nickel
-
- [Solved] Formula Help
by dcpron » Wed May 08, 2019 5:08 am - 2 Replies
- 129 Views
- Last post by dcpron
Wed May 08, 2019 5:28 am
- [Solved] Formula Help
-
- [Solved] OpenOffice Mail Merge
by Odd.acious » Tue May 07, 2019 12:03 am - 3 Replies
- 199 Views
- Last post by RoryOF
Tue May 07, 2019 8:23 pm
- [Solved] OpenOffice Mail Merge
-
- Blank spreadsheet (!)
by mammaanna » Tue May 07, 2019 5:37 am - 2 Replies
- 148 Views
- Last post by RoryOF
Tue May 07, 2019 9:57 am
- Blank spreadsheet (!)
-
- Sum not working, dates instead of sum totals
by craigo11 » Tue May 07, 2019 7:17 am - 1 Replies
- 136 Views
- Last post by Zizi64
Tue May 07, 2019 7:36 am
- Sum not working, dates instead of sum totals
-
- 'Versions' under 'file' button
by coppens1 » Mon May 06, 2019 6:09 pm - 3 Replies
- 159 Views
- Last post by Prometheus76
Mon May 06, 2019 10:02 pm
- 'Versions' under 'file' button
Who is online
Users browsing this forum: Google [Bot] and 20 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
|