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: 29047
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30675
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 27312
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 26547 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
- 38217 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- [Solved] Delete apostrophe before numbers in all cells?
by Kingrazor » Fri Mar 16, 2012 4:38 am - 26 Replies
- 115471 Views
- Last post by npandit
Fri Dec 06, 2019 6:58 am
- [Solved] Delete apostrophe before numbers in all cells?
-
- Calculate payment over/shortage
by RusselB » Fri Dec 06, 2019 6:09 am
- 0 Replies
- 17 Views
- Last post by RusselB
Fri Dec 06, 2019 6:09 am
- Calculate payment over/shortage
-
- 4 unique, but random numbers
by baro » Thu Dec 05, 2019 1:21 pm
- 1 Replies
- 28 Views
- Last post by MrProgrammer
Fri Dec 06, 2019 4:14 am
- 4 unique, but random numbers
-
- Total expenditure (Amount) for each of the category
by Mark Bulgaria » Thu Dec 05, 2019 3:14 pm
- 3 Replies
- 88 Views
- Last post by Villeroy
Fri Dec 06, 2019 2:11 am
- Total expenditure (Amount) for each of the category
-
- Autofilter not staying
by pcleitem » Thu Dec 05, 2019 8:16 pm - 1 Replies
- 52 Views
- Last post by Zizi64
Thu Dec 05, 2019 9:10 pm
- Autofilter not staying
-
- Importing spreadsheet pages
by docrokker7 » Thu Dec 05, 2019 7:07 pm - 0 Replies
- 41 Views
- Last post by docrokker7
Thu Dec 05, 2019 7:07 pm
- Importing spreadsheet pages
-
- Automaticly Highlight duplicate values in a column row
by MiRaDoR » Mon Nov 09, 2015 3:21 pm
- 5 Replies
- 16103 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
- 139 Views
- Last post by ptbento
Thu Dec 05, 2019 12:15 pm
- [Solved] Find and replace applied only to filtered cells
-
- Sorting within cells
by Dadge » Thu Dec 05, 2019 5:30 am - 3 Replies
- 90 Views
- Last post by RusselB
Thu Dec 05, 2019 7:14 am
- Sorting within cells
-
- [Solved] New hyperlinks no longer in color
by Origdogfish » Thu Dec 05, 2019 3:24 am - 1 Replies
- 57 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
- 63 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
- 90 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
- 57 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
- 184 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
- 118 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
- 218 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
- 143 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
- 1441 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
- 493 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
- 116 Views
- Last post by TheMotorcycleBoy
Sun Dec 01, 2019 3:20 pm
- Setting the default font size for all sheets in a file
-
- [Solved] Sum total of every 3rd row
by sharon29 » Sat Nov 30, 2019 6:24 pm - 6 Replies
- 194 Views
- Last post by sharon29
Sun Dec 01, 2019 1:49 pm
- [Solved] Sum total of every 3rd row
-
- [Solved] =Average problems when cells are empty
by judgesinel » Tue Nov 26, 2019 5:51 pm
- 10 Replies
- 308 Views
- Last post by judgesinel
Sun Dec 01, 2019 12:07 pm
- [Solved] =Average problems when cells are empty
-
- [Solved] Combine ODS workbooks and resolve external links
by KirkWard » Fri Nov 29, 2019 6:46 pm - 4 Replies
- 143 Views
- Last post by Villeroy
Sat Nov 30, 2019 3:18 pm
- [Solved] Combine ODS workbooks and resolve external links
-
- [SOLVED] Fahr-Centigrade, Different than Centigrade to Fahr
by RayBir » Sat Nov 30, 2019 11:27 am - 2 Replies
- 112 Views
- Last post by RayBir
Sat Nov 30, 2019 12:07 pm
- [SOLVED] Fahr-Centigrade, Different than Centigrade to Fahr
-
- Checking Accounting: Copy all "Gas" amounts to new column
by BJW86 » Sun Apr 19, 2015 7:59 pm - 6 Replies
- 722 Views
- Last post by pallavi
Fri Nov 29, 2019 3:29 pm
- Checking Accounting: Copy all "Gas" amounts to new column
-
- Adding rest breaks into trip
by RusselB » Tue Nov 26, 2019 2:23 am
- 2 Replies
- 138 Views
- Last post by RusselB
Fri Nov 29, 2019 1:08 am
- Adding rest breaks into trip
-
- Can't 'Check' Checkboxes in a Form?
by mehni » Thu Nov 28, 2019 2:49 pm - 2 Replies
- 126 Views
- Last post by UnklDonald418
Thu Nov 28, 2019 9:50 pm
- Can't 'Check' Checkboxes in a Form?
-
- Open a document without text import dialog
by nmertz » Thu Nov 28, 2019 7:17 pm - 1 Replies
- 87 Views
- Last post by Zizi64
Thu Nov 28, 2019 7:44 pm
- Open a document without text import dialog
-
- Generate 3 random numbers between 1 to 600 always the same
by enigmer » Wed Nov 27, 2019 8:12 pm
- 6 Replies
- 190 Views
- Last post by enigmer
Thu Nov 28, 2019 7:16 pm
- Generate 3 random numbers between 1 to 600 always the same
-
- [Solved] How do I reduce columns to say, every 5th row only
by marty-0750 » Thu Nov 14, 2019 7:52 am
- 12 Replies
- 394 Views
- Last post by jrkrideau
Thu Nov 28, 2019 3:47 pm
- [Solved] How do I reduce columns to say, every 5th row only
-
- Triangle Calculation
by MikeRSeal » Wed Nov 27, 2019 2:36 pm - 2 Replies
- 131 Views
- Last post by RoryOF
Wed Nov 27, 2019 10:46 pm
- Triangle Calculation
-
- [Solved] OpenOffice Calc vs Data Mode
by Sbusy67 » Tue Nov 26, 2019 11:19 pm - 2 Replies
- 124 Views
- Last post by Sbusy67
Wed Nov 27, 2019 1:24 am
- [Solved] OpenOffice Calc vs Data Mode
-
- [Solved] Numbers showing as percentages no matter what
by NickBusey » Tue Nov 26, 2019 7:13 pm - 3 Replies
- 122 Views
- Last post by Hagar Delest
Tue Nov 26, 2019 10:31 pm
- [Solved] Numbers showing as percentages no matter what
-
- Match and verify cell content
by Thracian » Mon Nov 25, 2019 8:53 pm
- 7 Replies
- 205 Views
- Last post by Thracian
Tue Nov 26, 2019 9:17 pm
- Match and verify cell content
-
- Conversion of formula from excel to open office
by Nicole11 » Mon Nov 04, 2019 11:50 pm
- 6 Replies
- 279 Views
- Last post by RusselB
Tue Nov 26, 2019 2:33 am
- Conversion of formula from excel to open office
-
- Bad allocation fatal error
by r l » Sun Jul 09, 2017 9:20 pm
- 14 Replies
- 5492 Views
- Last post by 1-to-go
Mon Nov 25, 2019 9:57 pm
- Bad allocation fatal error
-
- [Solved] Convert multi-string value to a single-string one
by maxon » Sun Nov 24, 2019 6:13 pm - 3 Replies
- 172 Views
- Last post by maxon
Mon Nov 25, 2019 8:34 pm
- [Solved] Convert multi-string value to a single-string one
-
- Conditional formatting with INDIRECT() function
by PeterNovotny » Mon Nov 25, 2019 12:55 pm
- 1 Replies
- 120 Views
- Last post by MrProgrammer
Mon Nov 25, 2019 6:03 pm
- Conditional formatting with INDIRECT() function
-
- [Solved] Formulas working in one document and no the other?
by neil-uk » Sun Nov 24, 2019 11:52 pm
- 7 Replies
- 228 Views
- Last post by neil-uk
Mon Nov 25, 2019 4:13 pm
- [Solved] Formulas working in one document and no the other?
-
- [Solved] Filling Other Cells With A Formula
by freedhardwoods » Mon Nov 25, 2019 12:34 pm - 2 Replies
- 115 Views
- Last post by freedhardwoods
Mon Nov 25, 2019 3:08 pm
- [Solved] Filling Other Cells With A Formula
-
- Sorting Named Cells
by Chef Silverman » Sun Nov 24, 2019 5:31 am - 2 Replies
- 147 Views
- Last post by MrProgrammer
Sun Nov 24, 2019 7:33 am
- Sorting Named Cells
-
- [Solved] Open Dialogue Window, Can I Re-Order File Types
by Mookie87 » Thu Nov 10, 2016 5:55 pm
- 9 Replies
- 1487 Views
- Last post by RusselB
Sun Nov 24, 2019 6:07 am
- [Solved] Open Dialogue Window, Can I Re-Order File Types
-
- [Solved] Convert LO .csv file to SQlite3.csv file
by pizzipie » Sun Nov 24, 2019 2:14 am - 0 Replies
- 103 Views
- Last post by pizzipie
Sun Nov 24, 2019 2:14 am
- [Solved] Convert LO .csv file to SQlite3.csv file
-
- [Solved] Function to get a series of cells with an offset
by mxdog » Sat Nov 23, 2019 9:45 pm - 3 Replies
- 137 Views
- Last post by mxdog
Sat Nov 23, 2019 11:52 pm
- [Solved] Function to get a series of cells with an offset
-
- [Solved] Pulling Detail from Second Sheet
by KeithOO » Fri Nov 22, 2019 6:59 pm - 2 Replies
- 145 Views
- Last post by KeithOO
Fri Nov 22, 2019 7:55 pm
- [Solved] Pulling Detail from Second Sheet
-
- [Solved] Calc cell phone numbers
by wallroad » Thu Mar 06, 2014 10:34 pm
- 16 Replies
- 6394 Views
- Last post by jrkrideau
Thu Nov 21, 2019 9:08 pm
- [Solved] Calc cell phone numbers
-
- Multiple IF statements
by AliGee » Thu Nov 21, 2019 2:06 pm - 3 Replies
- 159 Views
- Last post by MrProgrammer
Thu Nov 21, 2019 6:14 pm
- Multiple IF statements
-
- Programatically export to remote database
by keneso » Thu Nov 21, 2019 1:44 pm - 5 Replies
- 157 Views
- Last post by keneso
Thu Nov 21, 2019 5:17 pm
- Programatically export to remote database
-
- [Solved] Keyboard shortcut for autosum
by Ripcord » Wed Nov 20, 2019 5:55 pm
- 4 Replies
- 159 Views
- Last post by Ripcord
Thu Nov 21, 2019 4:55 pm
- [Solved] Keyboard shortcut for autosum
Who is online
Users browsing this forum: Zizi64 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
|