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: 28529
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30114
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26700
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 9155 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Templates: a dedicated repository in the OpenOffice web site
by Hagar Delest » Sun Feb 01, 2009 12:25 am - 6 Replies
- 36998 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Parsing Numeric Values
by KirkWard » Sat Oct 19, 2019 9:39 pm
- 7 Replies
- 88 Views
- Last post by KirkWard
Sun Oct 20, 2019 12:20 am
- Parsing Numeric Values
-
- Split and Freeze questions
by jon oneill » Sat Oct 19, 2019 11:27 am - 7 Replies
- 92 Views
- Last post by RusselB
Sat Oct 19, 2019 9:43 pm
- Split and Freeze questions
-
- Alphabetize
by herbyguitar » Sat Oct 19, 2019 5:53 pm - 2 Replies
- 48 Views
- Last post by herbyguitar
Sat Oct 19, 2019 9:01 pm
- Alphabetize
-
- Need Help With A Financial Formula
by KirkWard » Sat Oct 19, 2019 5:32 pm
- 1 Replies
- 37 Views
- Last post by KirkWard
Sat Oct 19, 2019 7:55 pm
- Need Help With A Financial Formula
-
- How to show Hyperlink?
by dawidek990 » Fri Oct 18, 2019 12:52 am
- 6 Replies
- 141 Views
- Last post by Lupp
Sat Oct 19, 2019 6:37 pm
- How to show Hyperlink?
-
- OpenOffice Calc Pie Chart
by ruheliebe » Mon Jun 02, 2014 8:18 pm - 6 Replies
- 717 Views
- Last post by Kevin-137
Sat Oct 19, 2019 4:17 pm
- OpenOffice Calc Pie Chart
-
- Multiple Nested 'OR' functions within a 'SUMIF'?
by Max1001 » Sat Oct 19, 2019 10:42 am
- 2 Replies
- 64 Views
- Last post by Zizi64
Sat Oct 19, 2019 11:26 am
- Multiple Nested 'OR' functions within a 'SUMIF'?
-
- [Solved] Display negative number without minus sign
by abrogard » Fri Oct 18, 2019 11:09 pm - 7 Replies
- 99 Views
- Last post by RusselB
Sat Oct 19, 2019 2:26 am
- [Solved] Display negative number without minus sign
-
- Combining multiple rows if certain criteria met
by teapotjames » Tue Oct 15, 2019 6:51 pm
- 1 Replies
- 154 Views
- Last post by MrProgrammer
Fri Oct 18, 2019 8:51 pm
- Combining multiple rows if certain criteria met
-
- Difficulty successfully concatenating my multiple columns
by kgrantsuttie » Thu Oct 17, 2019 9:21 pm - 1 Replies
- 56 Views
- Last post by RusselB
Fri Oct 18, 2019 3:33 am
- Difficulty successfully concatenating my multiple columns
-
- [Solved] cell comparison inside IF() test
by gramb0t » Thu Oct 17, 2019 8:47 pm - 3 Replies
- 92 Views
- Last post by gramb0t
Thu Oct 17, 2019 10:31 pm
- [Solved] cell comparison inside IF() test
-
- OpenOffice open empty file.
by dawidek990 » Sat Oct 12, 2019 7:34 pm
- 15 Replies
- 361 Views
- Last post by John_Ha
Thu Oct 17, 2019 6:22 pm
- OpenOffice open empty file.
-
- [Solved] Collect multiple sets of results from same formula
by Hellebore » Sun Oct 13, 2019 5:13 am
- 5 Replies
- 208 Views
- Last post by FJCC
Thu Oct 17, 2019 4:55 pm
- [Solved] Collect multiple sets of results from same formula
-
- [Solved] Page number and tabbing
by 56oldbrown » Wed Oct 16, 2019 1:40 am - 6 Replies
- 147 Views
- Last post by Zizi64
Thu Oct 17, 2019 6:34 am
- [Solved] Page number and tabbing
-
- Auto copy text in cells
by Paul Coombes » Wed Sep 25, 2019 7:17 pm - 5 Replies
- 227 Views
- Last post by Zizi64
Thu Oct 17, 2019 6:28 am
- Auto copy text in cells
-
- How to convert an Excel formula to Calc
by debbys » Wed Oct 16, 2019 4:53 pm
- 9 Replies
- 146 Views
- Last post by Villeroy
Wed Oct 16, 2019 8:46 pm
- How to convert an Excel formula to Calc
-
- Linking spreadsheets
by bbc0 » Wed Oct 16, 2019 12:50 am - 13 Replies
- 173 Views
- Last post by Villeroy
Wed Oct 16, 2019 8:26 pm
- Linking spreadsheets
-
- [Solved] Conditional Formating
by pauly88 » Wed Oct 16, 2019 12:22 pm
- 2 Replies
- 83 Views
- Last post by pauly88
Wed Oct 16, 2019 4:52 pm
- [Solved] Conditional Formating
-
- Dispersing deleted amount among remaining numbers
by Skeller204 » Tue Oct 15, 2019 7:21 pm - 1 Replies
- 87 Views
- Last post by FJCC
Tue Oct 15, 2019 8:30 pm
- Dispersing deleted amount among remaining numbers
-
- [Solved] Formulas Not Saving
by KirkWard » Tue Oct 15, 2019 3:57 pm
- 4 Replies
- 109 Views
- Last post by KirkWard
Tue Oct 15, 2019 7:01 pm
- [Solved] Formulas Not Saving
-
- [Solved] IF Syntax for Loan Spreadsheet
by WAS2019 » Sun Oct 13, 2019 12:28 am
- 6 Replies
- 190 Views
- Last post by WAS2019
Tue Oct 15, 2019 6:35 pm
- [Solved] IF Syntax for Loan Spreadsheet
-
- Need : Delete both duplicates column
by Steven99 » Tue Oct 15, 2019 11:16 am - 1 Replies
- 81 Views
- Last post by Villeroy
Tue Oct 15, 2019 12:25 pm
- Need : Delete both duplicates column
-
- Calc Pilot Logbook
by RadialBen » Sun Sep 15, 2019 1:43 am - 5 Replies
- 252 Views
- Last post by Villeroy
Tue Oct 15, 2019 12:05 pm
- Calc Pilot Logbook
-
- [Solved] Support for xlsm? -> No
by bstott » Mon Oct 14, 2019 8:27 pm - 7 Replies
- 145 Views
- Last post by Zizi64
Tue Oct 15, 2019 6:44 am
- [Solved] Support for xlsm? -> No
-
- Calculating portions of a whole across multiple columns
by KirkWard » Sun Oct 13, 2019 10:48 pm
- 11 Replies
- 193 Views
- Last post by RusselB
Mon Oct 14, 2019 4:28 pm
- Calculating portions of a whole across multiple columns
-
- [Solved] MOD giving Wonky Result?
by KirkWard » Sun Oct 13, 2019 9:38 pm
- 12 Replies
- 190 Views
- Last post by KirkWard
Mon Oct 14, 2019 12:07 am
- [Solved] MOD giving Wonky Result?
-
- [Solved] Stop one part of the formula from advancing
by Captain Crack » Sun Oct 13, 2019 6:12 am - 3 Replies
- 133 Views
- Last post by RusselB
Sun Oct 13, 2019 4:52 pm
- [Solved] Stop one part of the formula from advancing
-
- [Solved] Using formula results to perform other calculations
by Hellebore » Sat Oct 12, 2019 8:59 am
- 5 Replies
- 169 Views
- Last post by Hellebore
Sun Oct 13, 2019 5:03 am
- [Solved] Using formula results to perform other calculations
-
- Insert row when cell changes and add content to row
by bhy » Fri Oct 11, 2019 11:20 am
- 2 Replies
- 172 Views
- Last post by MrProgrammer
Sat Oct 12, 2019 9:24 pm
- Insert row when cell changes and add content to row
-
- [SOLVED]: Make cell echo last entry in a column range?
by kharrisma » Fri Oct 11, 2019 3:17 pm
- 7 Replies
- 234 Views
- Last post by lader
Sat Oct 12, 2019 7:41 pm
- [SOLVED]: Make cell echo last entry in a column range?
-
- [Solved] Scroll with a highlighted row
by manoman » Thu Oct 10, 2019 3:47 am - 5 Replies
- 214 Views
- Last post by manoman
Sat Oct 12, 2019 3:32 pm
- [Solved] Scroll with a highlighted row
-
- [Solved] Why is this IF formula only half working?
by Captain Crack » Fri Oct 11, 2019 10:25 am - 2 Replies
- 157 Views
- Last post by Captain Crack
Fri Oct 11, 2019 10:58 am
- [Solved] Why is this IF formula only half working?
-
- [Solved] Convert formula to value
by rogerknightOO » Sat Oct 23, 2010 4:30 pm
- 4 Replies
- 12782 Views
- Last post by Zizi64
Fri Oct 11, 2019 8:05 am
- [Solved] Convert formula to value
-
- [Solved] COUNTIF AND function issue
by Notrel » Fri Oct 11, 2019 1:39 am - 1 Replies
- 145 Views
- Last post by RusselB
Fri Oct 11, 2019 4:37 am
- [Solved] COUNTIF AND function issue
-
- Modify links in cell using a formula
by dawidek990 » Fri Oct 11, 2019 12:52 am - 2 Replies
- 126 Views
- Last post by RusselB
Fri Oct 11, 2019 1:25 am
- Modify links in cell using a formula
-
- Print numbers from first value of set
by ILikeCells » Thu Oct 10, 2019 9:26 pm
- 2 Replies
- 152 Views
- Last post by Zizi64
Thu Oct 10, 2019 11:37 pm
- Print numbers from first value of set
-
- Add Enter to Word
by dawidek990 » Thu Oct 10, 2019 2:22 am
- 9 Replies
- 279 Views
- Last post by Zizi64
Thu Oct 10, 2019 10:16 pm
- Add Enter to Word
-
- Merging 2 Formulas
by AndyPorter » Thu Oct 10, 2019 11:48 am - 2 Replies
- 157 Views
- Last post by FJCC
Thu Oct 10, 2019 4:22 pm
- Merging 2 Formulas
-
- Merge/Concatenate multiple columns with a separator characte
by AWoodShed » Thu Oct 10, 2019 4:43 am
- 6 Replies
- 195 Views
- Last post by Villeroy
Thu Oct 10, 2019 11:34 am
- Merge/Concatenate multiple columns with a separator characte
-
- Tab not advancing to next cell with autocomplete
by damientheo » Wed Oct 09, 2019 5:21 pm - 1 Replies
- 130 Views
- Last post by Villeroy
Wed Oct 09, 2019 7:02 pm
- Tab not advancing to next cell with autocomplete
-
- Help!Trying to open Calc spreadsheet as Writer text document
by donrlowe » Wed Oct 09, 2019 3:00 pm - 1 Replies
- 123 Views
- Last post by FJCC
Wed Oct 09, 2019 4:34 pm
- Help!Trying to open Calc spreadsheet as Writer text document
-
- [Solved] N/A error on vlookup
by papdronning » Tue Oct 08, 2019 11:39 am
- 8 Replies
- 272 Views
- Last post by keme
Wed Oct 09, 2019 2:25 pm
- [Solved] N/A error on vlookup
-
- Is this even possible as a formula?
by andr3as » Tue Oct 08, 2019 7:38 pm - 5 Replies
- 216 Views
- Last post by MrProgrammer
Tue Oct 08, 2019 9:15 pm
- Is this even possible as a formula?
-
- [Solved] Age column from birthdate column
by Chadwick Clubhouse » Tue Oct 01, 2019 11:33 pm - 11 Replies
- 335 Views
- Last post by MrProgrammer
Tue Oct 08, 2019 5:14 pm
- [Solved] Age column from birthdate column
-
- [Solved] Error discovered in sub-document content.xml
by marco6546 » Tue Oct 08, 2019 2:19 am
- 2 Replies
- 151 Views
- Last post by marco6546
Tue Oct 08, 2019 4:39 am
- [Solved] Error discovered in sub-document content.xml
-
- Repeating sub-headers
by pizzipie » Sun Sep 29, 2019 10:28 pm
- 9 Replies
- 348 Views
- Last post by pizzipie
Mon Oct 07, 2019 11:00 pm
- Repeating sub-headers
-
- Insert into multiple selection not possible
by meerakalra » Wed May 20, 2009 6:23 am - 6 Replies
- 8272 Views
- Last post by osxtra
Mon Oct 07, 2019 5:46 pm
- Insert into multiple selection not possible
-
- Calc crashing
by bigyin » Mon Oct 07, 2019 2:40 pm - 3 Replies
- 153 Views
- Last post by bigyin
Mon Oct 07, 2019 5:18 pm
- Calc crashing
-
- [Solved] Converting to a CSV file?
by KTSI01 » Sun Oct 06, 2019 10:39 pm - 2 Replies
- 183 Views
- Last post by Villeroy
Sun Oct 06, 2019 11:49 pm
- [Solved] Converting to a CSV file?
Who is online
Users browsing this forum: No registered users and 14 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
|