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: 34525
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 36499
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 33465
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 7416 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 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
- 49464 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Formula to find most recent date in list based on critera
by MBT » Thu Feb 25, 2021 8:42 pm
- 12 Replies
- 110 Views
- Last post by MBT
Fri Feb 26, 2021 12:44 am
- Formula to find most recent date in list based on critera
-
- Lock scaling percentage but Still shift page breaks?
by Meow » Thu Feb 25, 2021 10:41 pm - 0 Replies
- 21 Views
- Last post by Meow
Thu Feb 25, 2021 10:41 pm
- Lock scaling percentage but Still shift page breaks?
-
- How do I add .wav extension to a column
by hec » Thu Feb 25, 2021 9:05 pm - 2 Replies
- 31 Views
- Last post by FJCC
Thu Feb 25, 2021 9:17 pm
- How do I add .wav extension to a column
-
- Format error discovered in the file in sub-document
by koko233 » Thu Feb 25, 2021 6:16 pm
- 2 Replies
- 32 Views
- Last post by Hagar Delest
Thu Feb 25, 2021 8:14 pm
- Format error discovered in the file in sub-document
-
- [Solved] VLOOKUP for text does not match
by openstavros » Thu Feb 25, 2021 4:40 pm
- 4 Replies
- 70 Views
- Last post by MrProgrammer
Thu Feb 25, 2021 5:43 pm
- [Solved] VLOOKUP for text does not match
-
- [Solved] Select all images and change anchor
by Paolo Oselladore » Wed Feb 24, 2021 5:30 pm - 3 Replies
- 116 Views
- Last post by Paolo Oselladore
Thu Feb 25, 2021 1:55 pm
- [Solved] Select all images and change anchor
-
- Pull stock price from Internet
by MoeinIA » Thu Feb 25, 2021 8:01 am - 2 Replies
- 59 Views
- Last post by Zizi64
Thu Feb 25, 2021 8:22 am
- Pull stock price from Internet
-
- [Solved] How to display data from 2 conditions
by Jonsa » Wed Feb 24, 2021 3:54 am
- 2 Replies
- 110 Views
- Last post by Jonsa
Thu Feb 25, 2021 3:25 am
- [Solved] How to display data from 2 conditions
-
- [Solved] Suddenly I cannot open my Calc file
by Fjallraven1 » Mon Jul 06, 2020 3:48 pm
- 4 Replies
- 575 Views
- Last post by Fjallraven1
Wed Feb 24, 2021 11:55 pm
- [Solved] Suddenly I cannot open my Calc file
-
- Using Advanced Filters to remove duplicates
by AWoodShed » Wed Feb 24, 2021 12:05 am
- 6 Replies
- 146 Views
- Last post by Villeroy
Wed Feb 24, 2021 7:47 pm
- Using Advanced Filters to remove duplicates
-
- Filter selection dialog when opening XLSX
by Emilio » Wed Feb 24, 2021 11:20 am
- 10 Replies
- 119 Views
- Last post by RoryOF
Wed Feb 24, 2021 4:46 pm
- Filter selection dialog when opening XLSX
-
- [Solved] Change email hyperlink to text
by Wellgo » Sat Jan 27, 2018 6:38 pm - 3 Replies
- 518 Views
- Last post by windowshater
Wed Feb 24, 2021 2:10 pm
- [Solved] Change email hyperlink to text
-
- [Solved] VLOOKUP function shown instead of formula result
by JohnCox » Tue Feb 23, 2021 11:39 am
- 5 Replies
- 108 Views
- Last post by JohnCox
Tue Feb 23, 2021 2:49 pm
- [Solved] VLOOKUP function shown instead of formula result
-
- [Solved] Find and remove all links
by fred987 » Mon Feb 22, 2021 1:33 pm - 3 Replies
- 114 Views
- Last post by fred987
Mon Feb 22, 2021 8:31 pm
- [Solved] Find and remove all links
-
- [Solved] CSV Import formats the data incorrectly
by Ultra » Wed Jan 30, 2019 1:42 pm - 5 Replies
- 452 Views
- Last post by ApacheOO
Mon Feb 22, 2021 8:08 pm
- [Solved] CSV Import formats the data incorrectly
-
- DDE issue: Some links are "broken" after open
by CapCrockett » Mon Feb 22, 2021 5:15 pm - 0 Replies
- 69 Views
- Last post by CapCrockett
Mon Feb 22, 2021 5:15 pm
- DDE issue: Some links are "broken" after open
-
- [Solved] SUMPRODUCT between sheets returning wrong results
by mwade » Mon Feb 15, 2021 12:07 am - 3 Replies
- 234 Views
- Last post by mwade
Sun Feb 21, 2021 3:47 pm
- [Solved] SUMPRODUCT between sheets returning wrong results
-
- Keep background color settings
by cindyowe » Sun Feb 21, 2021 4:18 am - 1 Replies
- 88 Views
- Last post by Hagar Delest
Sun Feb 21, 2021 12:07 pm
- Keep background color settings
-
- [Solved] Show grid lines for new spreadsheets
by Burns » Sat Feb 20, 2021 7:20 pm - 2 Replies
- 106 Views
- Last post by Burns
Sat Feb 20, 2021 11:16 pm
- [Solved] Show grid lines for new spreadsheets
-
- Color picker not showing current color
by OoCalcUser99 » Fri Feb 12, 2021 8:58 am - 9 Replies
- 262 Views
- Last post by RoryOF
Sat Feb 20, 2021 8:05 pm
- Color picker not showing current color
-
- Data labels for line in stacked column and line graph
by ax89 » Fri Feb 19, 2021 6:14 pm
- 4 Replies
- 164 Views
- Last post by ax89
Sat Feb 20, 2021 4:37 pm
- Data labels for line in stacked column and line graph
-
- [Solved] Hide gridlines?
by tonyman » Sat Jun 23, 2012 12:37 am
- 21 Replies
- 46266 Views
- Last post by windowshater
Sat Feb 20, 2021 11:25 am
- [Solved] Hide gridlines?
-
- [Solved] Ignore empty cells for an average
by swampguy » Fri Feb 19, 2021 5:43 pm
- 12 Replies
- 192 Views
- Last post by swampguy
Fri Feb 19, 2021 9:44 pm
- [Solved] Ignore empty cells for an average
-
- [Solved] Copy-paste only produces value, not formula
by Mike44a » Mon Feb 15, 2021 5:09 pm - 2 Replies
- 199 Views
- Last post by Mike44a
Fri Feb 19, 2021 12:33 am
- [Solved] Copy-paste only produces value, not formula
-
- Transfer Lastpass data to Bitwarden via CSV
by barryb1717 » Thu Feb 18, 2021 5:23 pm
- 5 Replies
- 163 Views
- Last post by Villeroy
Thu Feb 18, 2021 7:21 pm
- Transfer Lastpass data to Bitwarden via CSV
-
- [Solved] Import 20-digit ICCID numbers from CSV
by dmey » Thu Feb 11, 2021 9:48 pm
- 15 Replies
- 434 Views
- Last post by John_Ha
Thu Feb 18, 2021 7:01 pm
- [Solved] Import 20-digit ICCID numbers from CSV
-
- [Solved] Background cell color does not appear from xlsx
by cebolifero » Tue Feb 16, 2021 10:15 pm - 2 Replies
- 176 Views
- Last post by MrProgrammer
Thu Feb 18, 2021 5:53 am
- [Solved] Background cell color does not appear from xlsx
-
- Non repeating random numbers
by alienrobotghost » Wed Feb 17, 2021 12:08 am - 8 Replies
- 263 Views
- Last post by robleyd
Thu Feb 18, 2021 1:42 am
- Non repeating random numbers
-
- [Solved] Font size keeps changing to 10
by waynec444 » Tue Feb 16, 2021 12:32 am - 15 Replies
- 359 Views
- Last post by Hagar Delest
Wed Feb 17, 2021 11:43 pm
- [Solved] Font size keeps changing to 10
-
- [Solved] The password is incorrect ...
by vstuart » Mon Feb 15, 2021 7:38 am - 3 Replies
- 229 Views
- Last post by vstuart
Tue Feb 16, 2021 11:26 pm
- [Solved] The password is incorrect ...
-
- [Solved] Find cell address of next value in a range/ table
by mxdog » Fri Feb 12, 2021 12:55 am
- 4 Replies
- 222 Views
- Last post by MrProgrammer
Tue Feb 16, 2021 8:48 pm
- [Solved] Find cell address of next value in a range/ table
-
- Saving file as backup
by The Doc » Sun Feb 14, 2021 1:16 pm - 3 Replies
- 149 Views
- Last post by RoryOF
Sun Feb 14, 2021 2:30 pm
- Saving file as backup
-
- [Solved] Protect sheet and keep coloured columns
by coolgit » Sat Feb 13, 2021 2:19 pm
- 11 Replies
- 219 Views
- Last post by coolgit
Sat Feb 13, 2021 8:22 pm
- [Solved] Protect sheet and keep coloured columns
-
- What size font (for calc) comes with OO
by waynec444 » Sat Feb 13, 2021 4:27 am - 3 Replies
- 161 Views
- Last post by Zizi64
Sat Feb 13, 2021 8:12 am
- What size font (for calc) comes with OO
-
- Stop paste overriding formula
by coolgit » Fri Feb 12, 2021 3:09 am - 11 Replies
- 242 Views
- Last post by coolgit
Fri Feb 12, 2021 8:36 pm
- Stop paste overriding formula
-
- [Solved] WYSIWYG doesn't apply when I try to print
by dharper » Thu Feb 11, 2021 10:04 pm - 4 Replies
- 151 Views
- Last post by mxdog
Fri Feb 12, 2021 6:01 am
- [Solved] WYSIWYG doesn't apply when I try to print
-
- [Solved] Grouped lines became hidden lines on their own?
by Frankiesmileshow » Tue Feb 09, 2021 4:30 am - 6 Replies
- 235 Views
- Last post by robleyd
Fri Feb 12, 2021 3:26 am
- [Solved] Grouped lines became hidden lines on their own?
-
- [Solved] Get the total for each row/category
by grandpajimmy » Thu Feb 11, 2021 4:33 am - 1 Replies
- 145 Views
- Last post by FJCC
Thu Feb 11, 2021 5:07 am
- [Solved] Get the total for each row/category
-
- [Solved] Edit pipe delimited file with high ASCII
by matt621 » Wed Aug 21, 2019 12:15 am - 11 Replies
- 805 Views
- Last post by matt621
Thu Feb 11, 2021 4:14 am
- [Solved] Edit pipe delimited file with high ASCII
-
- [Solved] Create page with 24 boxes, 4x6
by danno » Wed Feb 10, 2021 9:38 pm - 3 Replies
- 160 Views
- Last post by danno
Wed Feb 10, 2021 11:52 pm
- [Solved] Create page with 24 boxes, 4x6
-
- [Solved] Conditional formatting of time
by trg3015 » Sat Feb 06, 2021 12:56 am
- 3 Replies
- 218 Views
- Last post by MrProgrammer
Wed Feb 10, 2021 6:41 pm
- [Solved] Conditional formatting of time
-
- [Solved] Spreadsheet loses format saving in XLS file type
by Rich4444 » Mon Feb 08, 2021 8:03 pm
- 4 Replies
- 221 Views
- Last post by John_Ha
Wed Feb 10, 2021 3:56 pm
- [Solved] Spreadsheet loses format saving in XLS file type
-
- [SOLVED] Copy text but NOT the function
by David12846 » Tue Feb 09, 2021 10:21 pm - 3 Replies
- 204 Views
- Last post by JohnSUN-Pensioner
Wed Feb 10, 2021 3:33 pm
- [SOLVED] Copy text but NOT the function
-
- [Solved] Unable to ungroup
by tobim2021 » Mon Feb 01, 2021 12:11 am - 2 Replies
- 226 Views
- Last post by tobim2021
Tue Feb 09, 2021 8:58 pm
- [Solved] Unable to ungroup
-
- [Solved] IF OR condition
by coolgit » Sun Feb 07, 2021 12:52 pm
- 19 Replies
- 483 Views
- Last post by coolgit
Tue Feb 09, 2021 3:23 pm
- [Solved] IF OR condition
-
- Anchored form control moving when rows collapse/expand
by zampster » Tue Feb 09, 2021 2:58 pm - 0 Replies
- 112 Views
- Last post by zampster
Tue Feb 09, 2021 2:58 pm
- Anchored form control moving when rows collapse/expand
-
- [Solved] Remove bold from all entries & prevent Ctrl-B
by waynec444 » Sun Feb 07, 2021 5:28 am - 5 Replies
- 233 Views
- Last post by robleyd
Tue Feb 09, 2021 11:36 am
- [Solved] Remove bold from all entries & prevent Ctrl-B
-
- [Issue] Copy Cell Background Color to Another Cell
by Abalama » Mon May 16, 2011 10:11 pm
- 15 Replies
- 30636 Views
- Last post by Hagar Delest
Tue Feb 09, 2021 8:42 am
- [Issue] Copy Cell Background Color to Another Cell
-
- [Solved] Help creating a "tax" column
by drako123 » Tue Feb 09, 2021 3:04 am
- 2 Replies
- 184 Views
- Last post by MrProgrammer
Tue Feb 09, 2021 5:06 am
- [Solved] Help creating a "tax" column
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
|