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: 28867
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30477
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 27097
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 20408 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Advanced Find/Replace needs
by mrdf » Tue May 28, 2019 6:27 pm - 7 Replies
- 282 Views
- Last post by robleyd
Wed May 29, 2019 10:54 am
- Advanced Find/Replace needs
-
- [Solved] How is this not right?
by keithbakerlv » Tue May 28, 2019 11:22 pm - 2 Replies
- 171 Views
- Last post by keithbakerlv
Wed May 29, 2019 2:50 am
- [Solved] How is this not right?
-
- [Solved] Calculating different budget categories
by nothreat33 » Tue May 28, 2019 8:06 pm - 5 Replies
- 222 Views
- Last post by nothreat33
Wed May 29, 2019 2:23 am
- [Solved] Calculating different budget categories
-
- [Solved] Checking payments
by RusselB » Tue May 28, 2019 11:10 pm
- 2 Replies
- 166 Views
- Last post by RusselB
Wed May 29, 2019 2:17 am
- [Solved] Checking payments
-
- [SOLVED] Create button to return random name
by OfficeNewbie » Sat May 25, 2019 7:46 am
- 7 Replies
- 701 Views
- Last post by OfficeNewbie
Tue May 28, 2019 4:04 pm
- [SOLVED] Create button to return random name
-
- [Solved] Conditional formatting digit count
by jhonpaul72 » Mon May 27, 2019 6:15 pm
- 9 Replies
- 417 Views
- Last post by jhonpaul72
Tue May 28, 2019 3:33 pm
- [Solved] Conditional formatting digit count
-
- [Solved] Find duplicate values in a column row
by bhcmtr » Thu May 16, 2019 2:41 pm
- 12 Replies
- 806 Views
- Last post by bhcmtr
Tue May 28, 2019 7:34 am
- [Solved] Find duplicate values in a column row
-
- [Solved] Remove .00 from whole numbers?
by MadCowCrazy » Mon May 27, 2019 8:18 pm - 2 Replies
- 228 Views
- Last post by MadCowCrazy
Mon May 27, 2019 9:09 pm
- [Solved] Remove .00 from whole numbers?
-
- [Solved] Create Bowls comp score sheet
by OXONBOD » Sun May 26, 2019 3:41 pm - 3 Replies
- 281 Views
- Last post by robleyd
Mon May 27, 2019 10:31 am
- [Solved] Create Bowls comp score sheet
-
- [Solved] Save a copy as
by jjon » Fri May 24, 2019 12:38 am - 3 Replies
- 614 Views
- Last post by Zizi64
Mon May 27, 2019 6:56 am
- [Solved] Save a copy as
-
- Mixing decimal numbers in Calc
by Benoitch » Sun May 26, 2019 5:07 pm - 4 Replies
- 244 Views
- Last post by Zizi64
Mon May 27, 2019 6:50 am
- Mixing decimal numbers in Calc
-
- [Solved] Enable re expressions for range instead of globally
by jjon » Sat May 11, 2019 11:26 pm
- 4 Replies
- 348 Views
- Last post by jjon
Mon May 27, 2019 4:40 am
- [Solved] Enable re expressions for range instead of globally
-
- [Solved] Frequency distribution - error #Value
by DocC » Sat May 25, 2019 9:10 am
- 3 Replies
- 344 Views
- Last post by DocC
Sat May 25, 2019 10:03 pm
- [Solved] Frequency distribution - error #Value
-
- [Solved] Inventory Spreadsheet with pictures
by Stargazer86 » Thu May 23, 2019 7:13 pm - 4 Replies
- 393 Views
- Last post by MrProgrammer
Sat May 25, 2019 5:35 pm
- [Solved] Inventory Spreadsheet with pictures
-
- [Solved] Conditional Formatting - Matching Columns in Bulk
by GameDayDog » Fri May 24, 2019 4:38 pm
- 2 Replies
- 323 Views
- Last post by GameDayDog
Sat May 25, 2019 4:53 pm
- [Solved] Conditional Formatting - Matching Columns in Bulk
-
- [Solved]My Spreadsheet Keeps rounding off my account number
by Mitupogo » Fri May 24, 2019 5:49 pm - 4 Replies
- 495 Views
- Last post by jrkrideau
Sat May 25, 2019 12:44 pm
- [Solved]My Spreadsheet Keeps rounding off my account number
-
- [Solved] SUM and INDEX/MATCH function issues
by Tomba » Fri May 24, 2019 4:52 pm
- 3 Replies
- 445 Views
- Last post by Tomba
Fri May 24, 2019 5:29 pm
- [Solved] SUM and INDEX/MATCH function issues
-
- Page Preview coming up blank
by ajlm » Fri May 24, 2019 4:59 pm - 1 Replies
- 275 Views
- Last post by ajlm
Fri May 24, 2019 5:01 pm
- Page Preview coming up blank
-
- [Solved] Show Comment On Screen, But Don't Print
by Longspeak » Thu May 23, 2019 2:52 am - 3 Replies
- 475 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
- 1548 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
- 398 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
- 614 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
- 392 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
- 362 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
- 391 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
- 292 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
- 16580 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
- 114859 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
- 470 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
- 307 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
- 302 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
- 451 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
- 278 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
- 277 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
- 238 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
- 238 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
- 675 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
- 263 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
- 556 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
- 773 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
- 354 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
- 296 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
- 274 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
- 593 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
- 245 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
- 384 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
- 285 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
- 296 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
- 250 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
- 270 Views
- Last post by keithbakerlv
Fri May 10, 2019 7:09 pm
- [Solved] COUNTIF within an IF
Who is online
Users browsing this forum: No registered users and 19 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
|