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: 29565
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 31239
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 27917
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 43451 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
- 39326 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Calc function
by Canada » Mon Jan 20, 2020 3:14 pm - 1 Replies
- 13 Views
- Last post by FJCC
Mon Jan 20, 2020 4:08 pm
- Calc function
-
- Match cell content from another sheet & delete automatically
by Dr.Calculus » Mon Jan 20, 2020 1:54 pm - 1 Replies
- 17 Views
- Last post by Lupp
Mon Jan 20, 2020 2:25 pm
- Match cell content from another sheet & delete automatically
-
- Conditional formatting and image popup
by gruja » Mon Jan 20, 2020 10:33 am - 3 Replies
- 27 Views
- Last post by Villeroy
Mon Jan 20, 2020 2:23 pm
- Conditional formatting and image popup
-
- [Solved] Macro Security
by grahamn » Sun Jan 19, 2020 5:26 am - 4 Replies
- 91 Views
- Last post by Lupp
Mon Jan 20, 2020 12:29 am
- [Solved] Macro Security
-
- #VALUE! result when adding 7 days to a date
by tricia.young » Fri Jan 17, 2020 5:24 pm - 2 Replies
- 82 Views
- Last post by jrkrideau
Sun Jan 19, 2020 11:57 pm
- #VALUE! result when adding 7 days to a date
-
- How to import a txt file
by promytius » Sun Jan 19, 2020 6:29 pm - 1 Replies
- 25 Views
- Last post by John_Ha
Sun Jan 19, 2020 6:36 pm
- How to import a txt file
-
- Lost the recent version of my csv file
by shaunbaird » Sun Jan 19, 2020 3:09 pm
- 3 Replies
- 58 Views
- Last post by John_Ha
Sun Jan 19, 2020 6:22 pm
- Lost the recent version of my csv file
-
- Multilingual spellcheck
by greibush » Sun Jan 19, 2020 10:23 am - 2 Replies
- 53 Views
- Last post by Zizi64
Sun Jan 19, 2020 12:04 pm
- Multilingual spellcheck
-
- Sheet starts at Row 135? also protection
by eleanorb » Sat Jan 18, 2020 6:52 pm - 5 Replies
- 99 Views
- Last post by RusselB
Sun Jan 19, 2020 3:14 am
- Sheet starts at Row 135? also protection
-
- Possible with automatic page numbers in a cell
by Albireo » Thu Jan 16, 2020 1:38 am - 6 Replies
- 144 Views
- Last post by MrProgrammer
Sat Jan 18, 2020 1:06 am
- Possible with automatic page numbers in a cell
-
- [Solved] Undesired change to character case after entry
by jbl1954 » Fri Jan 17, 2020 5:58 pm - 4 Replies
- 94 Views
- Last post by jbl1954
Fri Jan 17, 2020 10:24 pm
- [Solved] Undesired change to character case after entry
-
- [Solved] How to turn off Page Break Preview in Spreadsheet?
by macxx1 » Fri Jan 17, 2020 1:34 am - 2 Replies
- 70 Views
- Last post by macxx1
Fri Jan 17, 2020 1:58 am
- [Solved] How to turn off Page Break Preview in Spreadsheet?
-
- Remove shadow behind email address in cell
by psaval » Wed Aug 29, 2012 3:46 pm - 3 Replies
- 2962 Views
- Last post by M_ichel
Thu Jan 16, 2020 9:07 pm
- Remove shadow behind email address in cell
-
- [Solved] need help with IF conditions
by pluumy » Thu Jan 16, 2020 3:32 pm - 2 Replies
- 79 Views
- Last post by pluumy
Thu Jan 16, 2020 5:06 pm
- [Solved] need help with IF conditions
-
- [Solved] Combining data in columns
by banjobiotic » Tue Jan 14, 2020 9:55 pm - 3 Replies
- 125 Views
- Last post by banjobiotic
Thu Jan 16, 2020 2:49 am
- [Solved] Combining data in columns
-
- Cell content from specific values - default value
by Albireo » Tue Jan 14, 2020 2:45 am
- 5 Replies
- 163 Views
- Last post by Villeroy
Wed Jan 15, 2020 3:10 pm
- Cell content from specific values - default value
-
- [Solved] Adding to Spreadsheet Problems
by forist » Tue Jan 14, 2020 7:25 pm - 2 Replies
- 118 Views
- Last post by forist
Wed Jan 15, 2020 2:06 am
- [Solved] Adding to Spreadsheet Problems
-
- Transfer date format from one file to others files at once
by Bokiiiiii » Tue Jan 14, 2020 10:58 pm - 2 Replies
- 98 Views
- Last post by Bokiiiiii
Tue Jan 14, 2020 11:18 pm
- Transfer date format from one file to others files at once
-
- [Solved] Lookup for multiple values
by bdf1215 » Tue Jan 14, 2020 8:07 pm
- 4 Replies
- 139 Views
- Last post by bdf1215
Tue Jan 14, 2020 10:16 pm
- [Solved] Lookup for multiple values
-
- [Solved] OpenOffice copying info onto multiple pages
by bdf1215 » Tue Dec 31, 2019 3:03 am
- 3 Replies
- 270 Views
- Last post by bdf1215
Tue Jan 14, 2020 6:47 pm
- [Solved] OpenOffice copying info onto multiple pages
-
- [Solved] Cashout Formula
by spellcheck_just_why » Mon Dec 16, 2019 6:48 pm
- 8 Replies
- 548 Views
- Last post by spellcheck_just_why
Tue Jan 14, 2020 1:00 am
- [Solved] Cashout Formula
-
- [Solved] More than 3 conditional formats
by dante99 » Wed Nov 21, 2012 11:00 am
- 12 Replies
- 4124 Views
- Last post by bikehounds
Mon Jan 13, 2020 8:54 pm
- [Solved] More than 3 conditional formats
-
- Display current months; summarize earlier years
by psdel » Sun Jan 12, 2020 11:53 pm - 1 Replies
- 107 Views
- Last post by Villeroy
Mon Jan 13, 2020 8:29 pm
- Display current months; summarize earlier years
-
- [Solved] Referenced cell moves less than formula copied
by RMcL » Tue Jan 07, 2020 10:30 pm
- 9 Replies
- 285 Views
- Last post by RMcL
Mon Jan 13, 2020 8:08 pm
- [Solved] Referenced cell moves less than formula copied
-
- [Solved] How do I use multiple formulas in the same cell?
by YellerFurd » Mon Jan 13, 2020 1:34 am - 2 Replies
- 157 Views
- Last post by YellerFurd
Mon Jan 13, 2020 6:01 am
- [Solved] How do I use multiple formulas in the same cell?
-
- [Solved] Built up cell reference doesn't fill on drag
by EAIAnalog » Sun Jan 12, 2020 10:56 pm - 1 Replies
- 142 Views
- Last post by MrProgrammer
Mon Jan 13, 2020 4:25 am
- [Solved] Built up cell reference doesn't fill on drag
-
- [Solved] Returning a number when a result is within a spec
by jkruse05 » Sat Jan 11, 2020 7:49 am - 4 Replies
- 224 Views
- Last post by Villeroy
Sat Jan 11, 2020 6:59 pm
- [Solved] Returning a number when a result is within a spec
-
- Upgrading To Latest Version Loses All Files Formatting
by Pugilist_Puppy » Mon Dec 09, 2019 9:24 pm
- 27 Replies
- 738 Views
- Last post by Villeroy
Sat Jan 11, 2020 2:27 pm
- Upgrading To Latest Version Loses All Files Formatting
-
- Automatic background change in perpetual calendar
by Ron Hargrove » Fri Jan 10, 2020 2:56 pm - 1 Replies
- 141 Views
- Last post by RusselB
Fri Jan 10, 2020 4:50 pm
- Automatic background change in perpetual calendar
-
- [Solved] How can I retain the SUM and delete the addends?
by Jude1931 » Fri Jan 10, 2020 4:12 am - 1 Replies
- 178 Views
- Last post by FJCC
Fri Jan 10, 2020 4:34 am
- [Solved] How can I retain the SUM and delete the addends?
-
- Find several cells with same text but can't isolate them
by jhoward1950 » Thu Jan 09, 2020 10:10 am
- 5 Replies
- 208 Views
- Last post by DiGro
Thu Jan 09, 2020 10:23 pm
- Find several cells with same text but can't isolate them
-
- [Solved] Multiple lines in cell
by MyBrady » Thu Jan 09, 2020 1:20 pm
- 5 Replies
- 202 Views
- Last post by MyBrady
Thu Jan 09, 2020 5:50 pm
- [Solved] Multiple lines in cell
-
- [Solved] Set Cell Color based on RGB values in a cell
by Myndex » Fri May 17, 2019 10:41 am
- 23 Replies
- 2269 Views
- Last post by DiGro
Thu Jan 09, 2020 2:59 pm
- [Solved] Set Cell Color based on RGB values in a cell
-
- Can't seem to find the correct way to use Solver
by Owler » Wed Jan 08, 2020 10:01 pm
- 2 Replies
- 173 Views
- Last post by RusselB
Thu Jan 09, 2020 2:33 am
- Can't seem to find the correct way to use Solver
-
- [Solved] SS not providing subtotals
by Obrey-R » Wed Jan 08, 2020 10:10 pm
- 6 Replies
- 193 Views
- Last post by RusselB
Thu Jan 09, 2020 2:11 am
- [Solved] SS not providing subtotals
-
- [Solved] (fairly) Replace https address with images in link?
by Nemesis » Wed Jan 08, 2020 6:10 pm - 3 Replies
- 152 Views
- Last post by Villeroy
Wed Jan 08, 2020 10:37 pm
- [Solved] (fairly) Replace https address with images in link?
-
- [Solved] Formulas for returning desired date
by jstack » Wed Jan 08, 2020 12:56 pm - 4 Replies
- 199 Views
- Last post by John_Ha
Wed Jan 08, 2020 5:11 pm
- [Solved] Formulas for returning desired date
-
- Request for comments: Favorite Recorded Calc Macros
by MrProgrammer » Mon Dec 16, 2019 4:55 am - 7 Replies
- 448 Views
- Last post by MrProgrammer
Wed Jan 08, 2020 2:15 am
- Request for comments: Favorite Recorded Calc Macros
-
- [Solved] Sort four columns, match same data?
by MaCro » Tue Jan 07, 2020 4:14 pm
- 1 Replies
- 147 Views
- Last post by Villeroy
Tue Jan 07, 2020 7:06 pm
- [Solved] Sort four columns, match same data?
-
- [Solved] Find same line of numbers
by Soricelus » Mon Jan 06, 2020 8:26 pm
- 3 Replies
- 181 Views
- Last post by Villeroy
Mon Jan 06, 2020 10:28 pm
- [Solved] Find same line of numbers
-
- [Solved] Running total column
by jeffnc » Mon Jul 21, 2014 6:05 pm
- 14 Replies
- 6524 Views
- Last post by eeoulo
Mon Jan 06, 2020 9:46 pm
- [Solved] Running total column
-
- Prevent =NOW() value from changing
by rfunstin » Mon Jan 06, 2020 2:21 am
- 5 Replies
- 213 Views
- Last post by Villeroy
Mon Jan 06, 2020 9:23 pm
- Prevent =NOW() value from changing
-
- [Solved] Negative Value of a number reads as lower than zero
by Mr.Nobody » Sat Jan 04, 2020 6:22 pm - 5 Replies
- 231 Views
- Last post by RusselB
Mon Jan 06, 2020 6:30 pm
- [Solved] Negative Value of a number reads as lower than zero
-
- [Solved] Conditional formatting digit count
by jhonpaul72 » Mon May 27, 2019 6:15 pm
- 14 Replies
- 611 Views
- Last post by jhonpaul72
Mon Jan 06, 2020 6:04 pm
- [Solved] Conditional formatting digit count
-
- [Solved] Merge two datasets based on consecutive UIs
by Veekerz28 » Sun Jan 05, 2020 4:15 pm
- 8 Replies
- 236 Views
- Last post by Veekerz28
Mon Jan 06, 2020 4:20 am
- [Solved] Merge two datasets based on consecutive UIs
-
- [Solved] Need help formatting XY Scatter chart X-axis
by ItzPaSta » Mon Jan 06, 2020 12:36 am
- 1 Replies
- 142 Views
- Last post by FJCC
Mon Jan 06, 2020 1:14 am
- [Solved] Need help formatting XY Scatter chart X-axis
-
- Mass formatting pasted content
by tamariszk » Sat Jan 04, 2020 2:57 pm - 4 Replies
- 194 Views
- Last post by Villeroy
Sun Jan 05, 2020 2:32 pm
- Mass formatting pasted content
-
- Enter a "1" into Cell A1 from a switch outside my computer?
by newbie99 » Sun Dec 29, 2019 7:19 pm
- 19 Replies
- 481 Views
- Last post by Villeroy
Sat Jan 04, 2020 2:10 am
- Enter a "1" into Cell A1 from a switch outside my computer?
-
- [Solved] Highlight duplicate text w/ conditional formatting
by marko2002 » Fri Jan 03, 2020 10:35 am - 2 Replies
- 165 Views
- Last post by marko2002
Fri Jan 03, 2020 7:58 pm
- [Solved] Highlight duplicate text w/ conditional formatting
Who is online
Users browsing this forum: MSN [Bot] and 16 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
|