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: 29624
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 31304
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 27986
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 45076 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
- 39417 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Count data, using multiple criteria
by pac626 » Tue Jan 21, 2020 11:49 pm
- 7 Replies
- 202 Views
- Last post by pac626
Sat Jan 25, 2020 4:17 am
- Count data, using multiple criteria
-
- display cell content of selectable column - array or not
by morphingstar » Sat Jan 25, 2020 12:01 am - 1 Replies
- 37 Views
- Last post by Villeroy
Sat Jan 25, 2020 12:47 am
- display cell content of selectable column - array or not
-
- entering info in cell
by transistor » Fri Jan 24, 2020 10:34 pm - 1 Replies
- 41 Views
- Last post by RusselB
Fri Jan 24, 2020 11:34 pm
- entering info in cell
-
- Paste numbers with leading zeros in OpenOffice Calc 4.x
by RC Silva » Thu Jan 23, 2020 12:45 am - 8 Replies
- 148 Views
- Last post by Villeroy
Fri Jan 24, 2020 10:10 pm
- Paste numbers with leading zeros in OpenOffice Calc 4.x
-
- Archieved file can not be edited and saved
by toucango » Fri Jan 24, 2020 6:36 pm
- 3 Replies
- 58 Views
- Last post by Bill
Fri Jan 24, 2020 8:08 pm
- Archieved file can not be edited and saved
-
- I need to extract data in calc format
by zivunho » Fri Jan 24, 2020 5:52 pm
- 1 Replies
- 47 Views
- Last post by MrProgrammer
Fri Jan 24, 2020 6:58 pm
- I need to extract data in calc format
-
- Insert automatic list of sequential integers
by david7365 » Thu Jan 23, 2020 6:36 pm - 6 Replies
- 129 Views
- Last post by Villeroy
Fri Jan 24, 2020 5:50 pm
- Insert automatic list of sequential integers
-
- Upgrading To Latest Version Loses All Files Formatting
by Pugilist_Puppy » Mon Dec 09, 2019 9:24 pm
- 28 Replies
- 817 Views
- Last post by Pugilist_Puppy
Fri Jan 24, 2020 11:12 am
- Upgrading To Latest Version Loses All Files Formatting
-
- Delete all blank cells and shift up
by cul » Thu Jan 23, 2020 10:16 am - 2 Replies
- 100 Views
- Last post by Lupp
Fri Jan 24, 2020 1:03 am
- Delete all blank cells and shift up
-
- [Solved] Need a function
by AlexandraNyx » Thu Jan 23, 2020 6:43 pm
- 4 Replies
- 131 Views
- Last post by AlexandraNyx
Thu Jan 23, 2020 11:04 pm
- [Solved] Need a function
-
- Need Help with 2 variable formula
by guitardave » Thu Jan 23, 2020 5:58 pm
- 0 Replies
- 63 Views
- Last post by guitardave
Thu Jan 23, 2020 5:58 pm
- Need Help with 2 variable formula
-
- [Solved] Font color on spreadsheet entries
by hdwolfe » Wed Jan 22, 2020 8:03 pm - 5 Replies
- 112 Views
- Last post by Zizi64
Thu Jan 23, 2020 8:07 am
- [Solved] Font color on spreadsheet entries
-
- How to set up default search options?
by xuzo » Wed Jan 22, 2020 10:51 am
- 1 Replies
- 78 Views
- Last post by MrProgrammer
Wed Jan 22, 2020 8:27 pm
- How to set up default search options?
-
- [Solved] Calculate difference between SUMs
by awstech » Wed Jan 22, 2020 1:15 pm - 3 Replies
- 84 Views
- Last post by RusselB
Wed Jan 22, 2020 5:05 pm
- [Solved] Calculate difference between SUMs
-
- Match cell content from another sheet & delete automatically
by Dr.Calculus » Mon Jan 20, 2020 1:54 pm - 3 Replies
- 110 Views
- Last post by Villeroy
Wed Jan 22, 2020 12:51 pm
- Match cell content from another sheet & delete automatically
-
- [Solved] Indirect link to a file
by Fitch » Tue Jan 21, 2020 7:58 pm - 2 Replies
- 80 Views
- Last post by Fitch
Tue Jan 21, 2020 10:22 pm
- [Solved] Indirect link to a file
-
- Conditional formatting and image popup
by gruja » Mon Jan 20, 2020 10:33 am
- 6 Replies
- 147 Views
- Last post by Lupp
Tue Jan 21, 2020 12:34 am
- Conditional formatting and image popup
-
- How to import a txt file
by promytius » Sun Jan 19, 2020 6:29 pm
- 3 Replies
- 95 Views
- Last post by robleyd
Tue Jan 21, 2020 12:15 am
- How to import a txt file
-
- [Solved] X Axis Value
by Teiber » Mon Jan 20, 2020 7:21 pm
- 2 Replies
- 86 Views
- Last post by Teiber
Mon Jan 20, 2020 8:32 pm
- [Solved] X Axis Value
-
- [Solved] IF function with two date tests
by Canada » Mon Jan 20, 2020 3:14 pm - 3 Replies
- 93 Views
- Last post by RusselB
Mon Jan 20, 2020 6:10 pm
- [Solved] IF function with two date tests
-
- [Solved] Macro Security
by grahamn » Sun Jan 19, 2020 5:26 am - 4 Replies
- 134 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
- 121 Views
- Last post by jrkrideau
Sun Jan 19, 2020 11:57 pm
- #VALUE! result when adding 7 days to a date
-
- Lost the recent version of my csv file
by shaunbaird » Sun Jan 19, 2020 3:09 pm
- 3 Replies
- 99 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
- 86 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
- 143 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
- 177 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
- 130 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
- 103 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
- 2997 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
- 111 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
- 158 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
- 198 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
- 154 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
- 116 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
- 163 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
- 291 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
- 578 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
- 4169 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
- 123 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
- 307 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
- 176 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
- 157 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
- 241 Views
- Last post by Villeroy
Sat Jan 11, 2020 6:59 pm
- [Solved] Returning a number when a result is within a spec
-
- Automatic background change in perpetual calendar
by Ron Hargrove » Fri Jan 10, 2020 2:56 pm - 1 Replies
- 154 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
- 191 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
- 234 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
- 220 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
- 2315 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
- 187 Views
- Last post by RusselB
Thu Jan 09, 2020 2:33 am
- Can't seem to find the correct way to use Solver
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
|