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: 29140
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30772
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 27417
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 29742 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
- 38441 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Pasting Values
by jerrytex » Sat Dec 14, 2019 4:11 am
- 5 Replies
- 86 Views
- Last post by RusselB
Sat Dec 14, 2019 6:42 pm
- Pasting Values
-
- Printing a single tab spreadsheet, repeated via duplex
by CraigG58 » Wed Dec 11, 2019 10:32 pm - 11 Replies
- 198 Views
- Last post by CraigG58
Sat Dec 14, 2019 6:38 pm
- Printing a single tab spreadsheet, repeated via duplex
-
- Graphics Filter Error and then some
by mwilson » Sat Dec 14, 2019 7:55 am
- 3 Replies
- 69 Views
- Last post by Lupp
Sat Dec 14, 2019 3:07 pm
- Graphics Filter Error and then some
-
- [Solved] Remove % format in single cells
by crabmann » Sat Dec 14, 2019 12:05 am - 5 Replies
- 94 Views
- Last post by crabmann
Sat Dec 14, 2019 9:54 am
- [Solved] Remove % format in single cells
-
- Calc crashing...
by withnail » Fri Dec 13, 2019 2:52 pm - 5 Replies
- 110 Views
- Last post by FJCC
Sat Dec 14, 2019 8:22 am
- Calc crashing...
-
- [Solved] Pull data from local XML file with FILTERXML
by Wolfhart » Sat Jun 23, 2018 8:55 pm
- 28 Replies
- 3292 Views
- Last post by jscatharina
Fri Dec 13, 2019 9:44 pm
- [Solved] Pull data from local XML file with FILTERXML
-
- [Solved] Randomize Email Addresses
by emilstyle » Fri Dec 13, 2019 5:31 pm - 5 Replies
- 111 Views
- Last post by emilstyle
Fri Dec 13, 2019 9:02 pm
- [Solved] Randomize Email Addresses
-
- Rounded price markup
by igabc » Fri Dec 13, 2019 8:13 pm - 1 Replies
- 61 Views
- Last post by FJCC
Fri Dec 13, 2019 8:32 pm
- Rounded price markup
-
- Singular Value Decomposition of a matrix
by Bald Eagle » Tue Dec 10, 2019 4:18 am
- 7 Replies
- 202 Views
- Last post by Bald Eagle
Fri Dec 13, 2019 8:27 pm
- Singular Value Decomposition of a matrix
-
- Open office Calc help for damaged file
by Thilan » Thu Dec 12, 2019 12:35 pm
- 4 Replies
- 137 Views
- Last post by Thilan
Fri Dec 13, 2019 4:37 am
- Open office Calc help for damaged file
-
- [Solved] Active cell selection after pressing Enter
by _richard100 » Thu Dec 12, 2019 10:17 pm - 4 Replies
- 87 Views
- Last post by _richard100
Fri Dec 13, 2019 2:23 am
- [Solved] Active cell selection after pressing Enter
-
- Timesheet issues
by DANIO2004 » Tue Dec 10, 2019 7:57 pm
- 3 Replies
- 153 Views
- Last post by Jeff
Wed Dec 11, 2019 5:21 pm
- Timesheet issues
-
- Page N of ## resetting
by BettyLeo1 » Tue Dec 10, 2019 10:52 pm - 4 Replies
- 113 Views
- Last post by BettyLeo1
Wed Dec 11, 2019 3:34 pm
- Page N of ## resetting
-
- [Solved] Resize text to fit cell
by Bald Eagle » Tue Dec 10, 2019 4:12 am
- 8 Replies
- 157 Views
- Last post by Bald Eagle
Wed Dec 11, 2019 1:57 pm
- [Solved] Resize text to fit cell
-
- Calc Tabs too small to read
by LEGOManiac » Wed Dec 11, 2019 2:46 am
- 4 Replies
- 99 Views
- Last post by Villeroy
Wed Dec 11, 2019 12:30 pm
- Calc Tabs too small to read
-
- Upgrading To Latest Version Loses All Files Formatting
by Pugilist_Puppy » Mon Dec 09, 2019 9:24 pm - 9 Replies
- 179 Views
- Last post by RoryOF
Tue Dec 10, 2019 10:10 am
- Upgrading To Latest Version Loses All Files Formatting
-
- Retaining Dates when I have a status change.
by Bob Lougheed » Mon Dec 09, 2019 3:03 pm
- 3 Replies
- 131 Views
- Last post by Zizi64
Tue Dec 10, 2019 8:21 am
- Retaining Dates when I have a status change.
-
- Importing spreadsheet pages from scanner
by docrokker7 » Thu Dec 05, 2019 7:07 pm
- 5 Replies
- 198 Views
- Last post by RoryOF
Mon Dec 09, 2019 6:39 pm
- Importing spreadsheet pages from scanner
-
- Formula Editing Problem
by lesbentley » Mon Dec 09, 2019 3:42 pm
- 3 Replies
- 110 Views
- Last post by Zizi64
Mon Dec 09, 2019 5:46 pm
- Formula Editing Problem
-
- [Solved] Adding A Comma Between Numbers
by JoelDennysDM » Sun Dec 08, 2019 10:47 pm
- 4 Replies
- 124 Views
- Last post by JoelDennysDM
Mon Dec 09, 2019 5:42 pm
- [Solved] Adding A Comma Between Numbers
-
- Can't open file, tells me File Selection
by LadySerenity14 » Sun Dec 08, 2019 9:19 pm
- 4 Replies
- 128 Views
- Last post by RoryOF
Mon Dec 09, 2019 2:39 pm
- Can't open file, tells me File Selection
-
- No display after Window -> Freeze
by matt4x4 » Sun Dec 08, 2019 8:52 pm - 2 Replies
- 75 Views
- Last post by RoryOF
Sun Dec 08, 2019 11:20 pm
- No display after Window -> Freeze
-
- [Solved] How to sum a sort an autofiltered column?
by vivekvp » Sat Dec 07, 2019 2:54 am
- 3 Replies
- 145 Views
- Last post by gerard24
Sun Dec 08, 2019 10:32 pm
- [Solved] How to sum a sort an autofiltered column?
-
- Sorting and Totaling
by CaptWho » Sun Dec 08, 2019 9:08 am
- 2 Replies
- 127 Views
- Last post by lader
Sun Dec 08, 2019 9:07 pm
- Sorting and Totaling
-
- [Solved] Opened spreadsheet, got strange dialog box
by Corelli » Sun Dec 08, 2019 4:29 pm
- 2 Replies
- 105 Views
- Last post by Corelli
Sun Dec 08, 2019 6:04 pm
- [Solved] Opened spreadsheet, got strange dialog box
-
- Calculate payment over/shortage
by RusselB » Fri Dec 06, 2019 6:09 am
- 2 Replies
- 150 Views
- Last post by RusselB
Sun Dec 08, 2019 3:19 am
- Calculate payment over/shortage
-
- [Solved] Concatenate??
by topdog69 » Sun Dec 08, 2019 1:47 am - 1 Replies
- 119 Views
- Last post by FJCC
Sun Dec 08, 2019 2:38 am
- [Solved] Concatenate??
-
- Formula how to say "cannot be equal to"
by Neko purr2 » Sat Nov 16, 2019 8:31 am
- 11 Replies
- 457 Views
- Last post by Neko purr2
Sat Dec 07, 2019 9:49 pm
- Formula how to say "cannot be equal to"
-
- [Solved] Delete apostrophe before numbers in all cells?
by Kingrazor » Fri Mar 16, 2012 4:38 am - 28 Replies
- 115915 Views
- Last post by Villeroy
Sat Dec 07, 2019 9:11 pm
- [Solved] Delete apostrophe before numbers in all cells?
-
- Sorting within cells
by Dadge » Thu Dec 05, 2019 5:30 am - 7 Replies
- 255 Views
- Last post by FJCC
Sat Dec 07, 2019 8:24 pm
- Sorting within cells
-
- Need to copy value not formula
by aliazero » Fri Aug 02, 2013 3:46 pm - 8 Replies
- 2817 Views
- Last post by Zizi64
Sat Dec 07, 2019 8:15 am
- Need to copy value not formula
-
- [Solved] Calc will not sum a column
by vivekvp » Fri Dec 06, 2019 5:54 pm - 10 Replies
- 217 Views
- Last post by vivekvp
Sat Dec 07, 2019 2:51 am
- [Solved] Calc will not sum a column
-
- [Solved] SUMIFS between 2 dates and matching a name
by laul07 » Fri Dec 06, 2019 9:16 pm
- 3 Replies
- 136 Views
- Last post by MrProgrammer
Fri Dec 06, 2019 10:04 pm
- [Solved] SUMIFS between 2 dates and matching a name
-
- [Solved] 4 unique, but random numbers
by baro » Thu Dec 05, 2019 1:21 pm
- 5 Replies
- 166 Views
- Last post by MrProgrammer
Fri Dec 06, 2019 9:38 pm
- [Solved] 4 unique, but random numbers
-
- [Solved] Total expenditure (Amount) for each of the category
by Mark Bulgaria » Thu Dec 05, 2019 3:14 pm
- 4 Replies
- 182 Views
- Last post by Mark Bulgaria
Fri Dec 06, 2019 10:37 am
- [Solved] Total expenditure (Amount) for each of the category
-
- Autofilter not staying
by pcleitem » Thu Dec 05, 2019 8:16 pm - 1 Replies
- 116 Views
- Last post by Zizi64
Thu Dec 05, 2019 9:10 pm
- Autofilter not staying
-
- Automaticly Highlight duplicate values in a column row
by MiRaDoR » Mon Nov 09, 2015 3:21 pm
- 5 Replies
- 16277 Views
- Last post by mircea273
Thu Dec 05, 2019 7:04 pm
- Automaticly Highlight duplicate values in a column row
-
- [Solved] Find and replace applied only to filtered cells
by ptbento » Tue Dec 03, 2019 5:33 pm - 5 Replies
- 191 Views
- Last post by ptbento
Thu Dec 05, 2019 12:15 pm
- [Solved] Find and replace applied only to filtered cells
-
- [Solved] New hyperlinks no longer in color
by Origdogfish » Thu Dec 05, 2019 3:24 am - 1 Replies
- 102 Views
- Last post by Origdogfish
Thu Dec 05, 2019 4:36 am
- [Solved] New hyperlinks no longer in color
-
- Unable to Print
by zj93i6 » Thu Dec 05, 2019 12:11 am - 2 Replies
- 110 Views
- Last post by zj93i6
Thu Dec 05, 2019 1:57 am
- Unable to Print
-
- Second sheet to be update based on first sheet.
by sainudeen » Wed Dec 04, 2019 11:16 am
- 1 Replies
- 135 Views
- Last post by MrProgrammer
Wed Dec 04, 2019 7:40 pm
- Second sheet to be update based on first sheet.
-
- [Solved] Refer to a variable named expression
by rikus » Wed Dec 04, 2019 6:44 pm
- 1 Replies
- 105 Views
- Last post by MrProgrammer
Wed Dec 04, 2019 7:28 pm
- [Solved] Refer to a variable named expression
-
- Moving sheets w/o losing formatting
by musictatter » Mon Dec 02, 2019 6:56 pm
- 8 Replies
- 236 Views
- Last post by RusselB
Tue Dec 03, 2019 4:56 am
- Moving sheets w/o losing formatting
-
- [Solved] Renaming a sheet
by bbc0 » Tue Dec 03, 2019 3:08 am - 2 Replies
- 171 Views
- Last post by bbc0
Tue Dec 03, 2019 3:43 am
- [Solved] Renaming a sheet
-
- ColorScale formatting based on cells not being formatted
by LukeH7789 » Fri Nov 29, 2019 3:46 pm
- 6 Replies
- 253 Views
- Last post by F3K Total
Mon Dec 02, 2019 6:22 pm
- ColorScale formatting based on cells not being formatted
-
- [Solved] Chart problem time vs date
by nelsonset » Mon Dec 02, 2019 5:21 am
- 5 Replies
- 186 Views
- Last post by RusselB
Mon Dec 02, 2019 6:53 am
- [Solved] Chart problem time vs date
-
- Best way to link to Excel data
1, 2 by catbill » Wed Sep 04, 2019 6:05 am
- 39 Replies
- 1559 Views
- Last post by RoryOF
Sun Dec 01, 2019 10:46 pm
- Best way to link to Excel data
-
- [Solved] Pivot Table Redundancy
by AlexandraNyx » Wed Nov 13, 2019 6:18 pm
- 15 Replies
- 548 Views
- Last post by AlexandraNyx
Sun Dec 01, 2019 7:53 pm
- [Solved] Pivot Table Redundancy
-
- Setting the default font size for all sheets in a file
by TheMotorcycleBoy » Sun Dec 01, 2019 10:43 am - 2 Replies
- 147 Views
- Last post by TheMotorcycleBoy
Sun Dec 01, 2019 3:20 pm
- Setting the default font size for all sheets in a file
Who is online
Users browsing this forum: Google [Bot] and 24 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
|