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: 31885
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33728
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30624
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 136032 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Change Legend
by ehj69a5 » Sun Feb 02, 2020 11:39 pm
- 15 Replies
- 897 Views
- Last post by ehj69a5
Mon Feb 03, 2020 11:55 pm
- [Solved] Change Legend
-
- [Solved] Change cells to hyperlinks
by trogne » Sat Feb 01, 2020 4:42 pm
- 17 Replies
- 941 Views
- Last post by Zizi64
Mon Feb 03, 2020 11:19 pm
- [Solved] Change cells to hyperlinks
-
- [Solved] Transposing Columns to Rows?
by Dink Martini » Tue Jan 28, 2020 10:06 pm
- 4 Replies
- 463 Views
- Last post by Dink Martini
Mon Feb 03, 2020 8:04 pm
- [Solved] Transposing Columns to Rows?
-
- [Solved] Copying a formula with CONCATENATE
by rjmnook@gmail.com » Mon Feb 03, 2020 4:59 pm - 2 Replies
- 217 Views
- Last post by rjmnook@gmail.com
Mon Feb 03, 2020 5:08 pm
- [Solved] Copying a formula with CONCATENATE
-
- [Solved] Sharing a spreadsheet
by judgesinel » Sun Feb 02, 2020 12:46 pm
- 5 Replies
- 506 Views
- Last post by judgesinel
Mon Feb 03, 2020 4:03 pm
- [Solved] Sharing a spreadsheet
-
- [Solved] Average every n-th column based on condition
by Andyfc » Sun Feb 02, 2020 1:48 pm
- 4 Replies
- 349 Views
- Last post by Lupp
Mon Feb 03, 2020 3:40 pm
- [Solved] Average every n-th column based on condition
-
- [Solved] Align text vertically
by robp » Thu Jan 30, 2020 12:53 pm
- 8 Replies
- 634 Views
- Last post by robp
Mon Feb 03, 2020 3:21 pm
- [Solved] Align text vertically
-
- Archived file can not be edited and saved
by toucango » Fri Jan 24, 2020 6:36 pm
- 27 Replies
- 1329 Views
- Last post by Zizi64
Mon Feb 03, 2020 7:49 am
- Archived file can not be edited and saved
-
- [Solved] Is it possible to have a cell be a date picker?
by hypGnosis » Sun Feb 02, 2020 4:28 am
- 4 Replies
- 714 Views
- Last post by Zizi64
Sun Feb 02, 2020 1:27 pm
- [Solved] Is it possible to have a cell be a date picker?
-
- [Solved] Protect Cell Formatting
by JamesSmith32 » Sun Feb 02, 2020 4:50 am - 2 Replies
- 233 Views
- Last post by JamesSmith32
Sun Feb 02, 2020 11:11 am
- [Solved] Protect Cell Formatting
-
- [Solved] Plot two graphs against each other
by Athiril » Fri Jan 31, 2020 11:44 am
- 2 Replies
- 290 Views
- Last post by FJCC
Fri Jan 31, 2020 4:24 pm
- [Solved] Plot two graphs against each other
-
- [Solved] Leap year problems with sum and averages
by gmccollam » Fri Jan 31, 2020 2:55 am
- 4 Replies
- 338 Views
- Last post by gmccollam
Fri Jan 31, 2020 4:35 am
- [Solved] Leap year problems with sum and averages
-
- Help with the formula
by duh123 » Thu Jan 30, 2020 10:40 am - 3 Replies
- 337 Views
- Last post by Zizi64
Thu Jan 30, 2020 4:16 pm
- Help with the formula
-
- Making a multiple tables on a single sheet extension?
by hugoromor » Wed Jan 29, 2020 1:25 am - 4 Replies
- 376 Views
- Last post by Villeroy
Wed Jan 29, 2020 4:18 pm
- Making a multiple tables on a single sheet extension?
-
- Pivot table as formula - possible - how
by Albireo » Mon Jan 27, 2020 12:17 pm - 7 Replies
- 578 Views
- Last post by Villeroy
Wed Jan 29, 2020 12:40 pm
- Pivot table as formula - possible - how
-
- [Solved] Display cell content of selectable column
by morphingstar » Sat Jan 25, 2020 12:01 am - 2 Replies
- 304 Views
- Last post by morphingstar
Wed Jan 29, 2020 7:13 am
- [Solved] Display cell content of selectable column
-
- [Solved] Count Fridays in current month
by killerpip4 » Tue Jan 28, 2020 5:53 pm - 1 Replies
- 254 Views
- Last post by MrProgrammer
Tue Jan 28, 2020 6:31 pm
- [Solved] Count Fridays in current month
-
- [Solved] Sort four columns, match same data?
by MaCro » Tue Jan 07, 2020 4:14 pm
- 2 Replies
- 429 Views
- Last post by MaCro
Tue Jan 28, 2020 4:31 pm
- [Solved] Sort four columns, match same data?
-
- [Solved] #VALUE! result when adding 7 days to a date
by tricia.young » Fri Jan 17, 2020 5:24 pm - 3 Replies
- 349 Views
- Last post by tricia.young
Tue Jan 28, 2020 3:22 pm
- [Solved] #VALUE! result when adding 7 days to a date
-
- [Solved] Entering info in cell
by transistor » Fri Jan 24, 2020 10:34 pm - 3 Replies
- 348 Views
- Last post by RusselB
Mon Jan 27, 2020 9:37 pm
- [Solved] Entering info in cell
-
- [Solved] AutoFilter Header Disapears
by jdhamilton » Sun Jan 26, 2020 9:47 pm
- 2 Replies
- 288 Views
- Last post by jdhamilton
Mon Jan 27, 2020 12:05 am
- [Solved] AutoFilter Header Disapears
-
- [Solved] Paste numbers with leading zeros in OpenOffice 4.x
by RC Silva » Thu Jan 23, 2020 12:45 am - 15 Replies
- 1063 Views
- Last post by Villeroy
Sun Jan 26, 2020 8:50 pm
- [Solved] Paste numbers with leading zeros in OpenOffice 4.x
-
- Difference Between AOO Spreadsheet and Google Sheets
by ironboxer » Sun Jan 26, 2020 3:53 pm - 2 Replies
- 288 Views
- Last post by Villeroy
Sun Jan 26, 2020 5:32 pm
- Difference Between AOO Spreadsheet and Google Sheets
-
- Multiplying cells conditionally
by kampi » Sun Jan 26, 2020 1:38 am
- 3 Replies
- 322 Views
- Last post by Lupp
Sun Jan 26, 2020 1:18 pm
- Multiplying cells conditionally
-
- [Solved] Count data, using multiple criteria
by pac626 » Tue Jan 21, 2020 11:49 pm
- 7 Replies
- 664 Views
- Last post by pac626
Sat Jan 25, 2020 4:17 am
- [Solved] Count data, using multiple criteria
-
- I need to extract data in calc format
by zivunho » Fri Jan 24, 2020 5:52 pm
- 1 Replies
- 238 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
- 520 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
- 1747 Views
- Last post by Pugilist_Puppy
Fri Jan 24, 2020 11:12 am
- Upgrading To Latest Version Loses All Files Formatting
-
- [Solved] Delete all blank cells and shift up
by cul » Thu Jan 23, 2020 10:16 am - 2 Replies
- 342 Views
- Last post by Lupp
Fri Jan 24, 2020 1:03 am
- [Solved] Delete all blank cells and shift up
-
- [Solved] Need function to change X1 X1 X1 to X1 X2 X3
by AlexandraNyx » Thu Jan 23, 2020 6:43 pm
- 4 Replies
- 328 Views
- Last post by AlexandraNyx
Thu Jan 23, 2020 11:04 pm
- [Solved] Need function to change X1 X1 X1 to X1 X2 X3
-
- [Solved] Font color on spreadsheet entries
by hdwolfe » Wed Jan 22, 2020 8:03 pm - 5 Replies
- 317 Views
- Last post by Zizi64
Thu Jan 23, 2020 8:07 am
- [Solved] Font color on spreadsheet entries
-
- [Solved] How to set up default search options?
by xuzo » Wed Jan 22, 2020 10:51 am
- 1 Replies
- 213 Views
- Last post by MrProgrammer
Wed Jan 22, 2020 8:27 pm
- [Solved] How to set up default search options?
-
- [Solved] Calculate difference between SUMs
by awstech » Wed Jan 22, 2020 1:15 pm - 3 Replies
- 254 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
- 299 Views
- Last post by Villeroy
Wed Jan 22, 2020 12:51 pm
- Match cell content from another sheet & delete automatically
-
- Conditional formatting and image popup
by gruja » Mon Jan 20, 2020 10:33 am
- 6 Replies
- 370 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
- 278 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
- 206 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
- 229 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
- 307 Views
- Last post by Lupp
Mon Jan 20, 2020 12:29 am
- [Solved] Macro Security
-
- Lost the recent version of my csv file
by shaunbaird » Sun Jan 19, 2020 3:09 pm
- 3 Replies
- 257 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
- 214 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
- 332 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
- 388 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
- 274 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
- 194 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
- 3321 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
- 251 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
- 315 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
- 467 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
- 290 Views
- Last post by forist
Wed Jan 15, 2020 2:06 am
- [Solved] Adding to Spreadsheet Problems
Who is online
Users browsing this forum: No registered users and 28 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
|