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: 27981
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 29476
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26069
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 80528 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 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
- 35976 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Multiple if then in single cell
by turtle0221 » Mon Aug 26, 2019 10:02 am - 1 Replies
- 17 Views
- Last post by RoryOF
Mon Aug 26, 2019 10:08 am
- Multiple if then in single cell
-
- Compare two sheets with differences on third sheet
by rosekamp » Mon Aug 26, 2019 9:33 am - 0 Replies
- 13 Views
- Last post by rosekamp
Mon Aug 26, 2019 9:33 am
- Compare two sheets with differences on third sheet
-
- Save a file as picture
by erichuff » Sun Aug 25, 2019 6:19 pm - 4 Replies
- 82 Views
- Last post by Zizi64
Mon Aug 26, 2019 6:29 am
- Save a file as picture
-
- Chart disappears when trying to edit it.
by asmith68 » Sun Aug 25, 2019 10:03 pm - 1 Replies
- 41 Views
- Last post by RusselB
Sun Aug 25, 2019 10:38 pm
- Chart disappears when trying to edit it.
-
- Display the criteria currently used by AutoFilter
by aboba » Wed Aug 21, 2019 11:03 pm - 1 Replies
- 77 Views
- Last post by MrProgrammer
Sun Aug 25, 2019 6:50 pm
- Display the criteria currently used by AutoFilter
-
- Keeping sort parameters
by tdwyer » Sun May 11, 2008 9:06 pm - 12 Replies
- 2153 Views
- Last post by rmilstead
Sat Aug 24, 2019 2:34 pm
- Keeping sort parameters
-
- Selecting and displaying results from a table
by mayfield » Thu Aug 22, 2019 11:22 am
- 3 Replies
- 129 Views
- Last post by mayfield
Sat Aug 24, 2019 4:20 am
- Selecting and displaying results from a table
-
- [Solved] Calc changes values to lowercase
by swiftmallard » Fri Aug 23, 2019 11:44 pm - 4 Replies
- 112 Views
- Last post by swiftmallard
Sat Aug 24, 2019 1:49 am
- [Solved] Calc changes values to lowercase
-
- Fantasy football - team results analysis
by unclebirt » Fri Aug 23, 2019 1:33 pm - 0 Replies
- 59 Views
- Last post by unclebirt
Fri Aug 23, 2019 1:33 pm
- Fantasy football - team results analysis
-
- [SOLVED] SEARCH - FIND - or - MATCH
by unclebirt » Fri Aug 23, 2019 11:20 am
- 2 Replies
- 72 Views
- Last post by unclebirt
Fri Aug 23, 2019 12:40 pm
- [SOLVED] SEARCH - FIND - or - MATCH
-
- How to complete a partial date?
by strongwiththisone » Wed Aug 21, 2019 6:30 pm
- 7 Replies
- 157 Views
- Last post by RoryOF
Thu Aug 22, 2019 9:30 pm
- How to complete a partial date?
-
- Auto copy content to clipboard when selected
by dummydecoy » Fri Feb 11, 2011 7:38 pm - 5 Replies
- 2145 Views
- Last post by Jääskis
Thu Aug 22, 2019 7:11 pm
- Auto copy content to clipboard when selected
-
- [Solved] Using SUMPRODUCT with multiple criteria in column
by yoyopoc » Thu Aug 22, 2019 4:36 pm - 3 Replies
- 85 Views
- Last post by yoyopoc
Thu Aug 22, 2019 6:01 pm
- [Solved] Using SUMPRODUCT with multiple criteria in column
-
- HELP WITH A FORMULA PLEASE,
by Kevg1980 » Thu Aug 22, 2019 3:41 pm - 1 Replies
- 64 Views
- Last post by FJCC
Thu Aug 22, 2019 5:19 pm
- HELP WITH A FORMULA PLEASE,
-
- [Solved] Adding a graphic or picture to a spreadsheet
by unclebirt » Thu Aug 22, 2019 2:33 pm - 1 Replies
- 64 Views
- Last post by Zizi64
Thu Aug 22, 2019 3:46 pm
- [Solved] Adding a graphic or picture to a spreadsheet
-
- Question about editing pipe delimited file with high ASCII
by matt621 » Wed Aug 21, 2019 12:15 am - 8 Replies
- 182 Views
- Last post by matt621
Thu Aug 22, 2019 12:19 pm
- Question about editing pipe delimited file with high ASCII
-
- Insert a new Row without moving the row with formula?
by Brevardo » Thu Aug 22, 2019 1:24 am - 3 Replies
- 82 Views
- Last post by RusselB
Thu Aug 22, 2019 3:57 am
- Insert a new Row without moving the row with formula?
-
- sorting alphanumeric with defined sorting list
by Michael111 » Tue Aug 20, 2019 2:37 pm - 6 Replies
- 157 Views
- Last post by robleyd
Thu Aug 22, 2019 12:18 am
- sorting alphanumeric with defined sorting list
-
- Calc opens in text form - GENERAL cell setting ignored
by morphingstar » Wed Aug 21, 2019 9:36 pm - 1 Replies
- 70 Views
- Last post by morphingstar
Wed Aug 21, 2019 10:05 pm
- Calc opens in text form - GENERAL cell setting ignored
-
- Convert every 5 rows into new Column Calc
by michaelbragg_7456 » Mon Aug 19, 2019 3:12 am
- 8 Replies
- 213 Views
- Last post by MrProgrammer
Wed Aug 21, 2019 5:59 pm
- Convert every 5 rows into new Column Calc
-
- Import Excel data table doesn't work
by lukas1994 » Tue Aug 13, 2019 11:58 am
- 5 Replies
- 197 Views
- Last post by lukas1994
Wed Aug 21, 2019 2:47 pm
- Import Excel data table doesn't work
-
- Setting Line Width As Default On All Sheets
by drewnmwyrt » Tue Jan 29, 2019 6:07 pm - 4 Replies
- 222 Views
- Last post by Zizi64
Tue Aug 20, 2019 3:40 pm
- Setting Line Width As Default On All Sheets
-
- Concatenate cells depending on contents
by AWoodShed » Mon Aug 19, 2019 2:57 am
- 6 Replies
- 175 Views
- Last post by Lupp
Mon Aug 19, 2019 11:33 pm
- Concatenate cells depending on contents
-
- [Solved] Calulating hours worked
by turtle0221 » Wed Aug 14, 2019 4:18 pm - 4 Replies
- 167 Views
- Last post by turtle0221
Mon Aug 19, 2019 1:18 pm
- [Solved] Calulating hours worked
-
- [Solved] IF function - possibly ?
by unclebirt » Mon Aug 19, 2019 8:35 am - 1 Replies
- 80 Views
- Last post by unclebirt
Mon Aug 19, 2019 10:10 am
- [Solved] IF function - possibly ?
-
- [Solved] stopping"FALSE" appearing
by jimbokea » Sun Aug 18, 2019 2:26 am - 5 Replies
- 146 Views
- Last post by jimbokea
Mon Aug 19, 2019 7:18 am
- [Solved] stopping"FALSE" appearing
-
- [Solved] Calculating numerical value of words
by orangeli » Thu Aug 15, 2019 9:28 pm - 8 Replies
- 294 Views
- Last post by karolus
Sun Aug 18, 2019 10:28 pm
- [Solved] Calculating numerical value of words
-
- Why export chart to pdf for high quality printing?
by catbill » Sat Aug 17, 2019 11:39 pm - 1 Replies
- 115 Views
- Last post by John_Ha
Sun Aug 18, 2019 10:57 am
- Why export chart to pdf for high quality printing?
-
- [Solved] Multiple IF function in one cell
by dojo97 » Sun Aug 18, 2019 5:22 am - 9 Replies
- 156 Views
- Last post by robleyd
Sun Aug 18, 2019 9:11 am
- [Solved] Multiple IF function in one cell
-
- How to summary all the important data from multiple file?
by atiqahtaj » Fri Aug 16, 2019 9:30 am - 2 Replies
- 130 Views
- Last post by Villeroy
Fri Aug 16, 2019 3:51 pm
- How to summary all the important data from multiple file?
-
- (Solved)Staring List for Golf competition
by Scarsax2018 » Thu Aug 15, 2019 10:32 am
- 6 Replies
- 203 Views
- Last post by Scarsax2018
Fri Aug 16, 2019 6:21 am
- (Solved)Staring List for Golf competition
-
- [Solved] Sum Charges $9 If Vendor Name Appeared
by ROLC » Thu Aug 15, 2019 4:44 am
- 2 Replies
- 130 Views
- Last post by ROLC
Fri Aug 16, 2019 4:06 am
- [Solved] Sum Charges $9 If Vendor Name Appeared
-
- [Solved] How to MIN or MAX number of values backwards?
by opog » Thu Aug 15, 2019 7:46 am
- 2 Replies
- 101 Views
- Last post by opog
Fri Aug 16, 2019 3:42 am
- [Solved] How to MIN or MAX number of values backwards?
-
- [Solved] Sort by date only sorts by day
by Sungod3000 » Thu Aug 15, 2019 8:58 pm - 4 Replies
- 130 Views
- Last post by Lupp
Thu Aug 15, 2019 10:11 pm
- [Solved] Sort by date only sorts by day
-
- Print Preview
by rgustafs » Mon Aug 12, 2019 12:11 pm - 5 Replies
- 190 Views
- Last post by RoryOF
Thu Aug 15, 2019 7:33 pm
- Print Preview
-
- [Solved] Date format after 'cut'
by HoolyNI » Thu Aug 08, 2019 10:40 am - 3 Replies
- 167 Views
- Last post by Villeroy
Thu Aug 15, 2019 6:20 pm
- [Solved] Date format after 'cut'
-
- [Solved] How to average specific number of values backwards?
by opog » Wed Aug 14, 2019 3:26 am
- 6 Replies
- 229 Views
- Last post by opog
Thu Aug 15, 2019 3:23 am
- [Solved] How to average specific number of values backwards?
-
- Formula for setting a price based on a target margin
by phil001 » Wed Aug 14, 2019 4:54 pm
- 1 Replies
- 130 Views
- Last post by Lupp
Wed Aug 14, 2019 10:24 pm
- Formula for setting a price based on a target margin
-
- One of Calc file broken
by casper99994 » Thu Aug 08, 2019 10:41 am
- 13 Replies
- 296 Views
- Last post by John_Ha
Wed Aug 14, 2019 7:59 pm
- One of Calc file broken
-
- [Solved] Cell formula total is too big to fit into cell
by mileena » Wed Aug 14, 2019 3:18 am
- 7 Replies
- 208 Views
- Last post by mileena
Wed Aug 14, 2019 6:53 pm
- [Solved] Cell formula total is too big to fit into cell
-
- Data Validity list with names for choice
by morphingstar » Wed May 01, 2019 9:35 pm - 5 Replies
- 268 Views
- Last post by Villeroy
Wed Aug 14, 2019 3:57 pm
- Data Validity list with names for choice
-
- [Solved] Rounding a number to '9'
by Nath@homesmart » Wed Aug 14, 2019 11:06 am - 4 Replies
- 146 Views
- Last post by Nath@homesmart
Wed Aug 14, 2019 2:43 pm
- [Solved] Rounding a number to '9'
-
- Time*Money
by bkkMarty » Wed Apr 10, 2019 2:25 pm
- 5 Replies
- 246 Views
- Last post by MikeBellamy
Wed Aug 14, 2019 10:33 am
- Time*Money
-
- [Solved] Find non empty cells within a dynamic range
by ioakyriazis » Tue Aug 06, 2019 11:10 am - 3 Replies
- 159 Views
- Last post by ioakyriazis
Wed Aug 14, 2019 9:45 am
- [Solved] Find non empty cells within a dynamic range
-
- [Solved] Unable to open Excel workbook
by hkbs » Tue Aug 13, 2019 8:17 pm - 1 Replies
- 116 Views
- Last post by hkbs
Tue Aug 13, 2019 8:38 pm
- [Solved] Unable to open Excel workbook
-
- [Solved] Conditional format cell
by AndrewRi » Fri Aug 09, 2019 11:06 pm - 5 Replies
- 219 Views
- Last post by AndrewRi
Tue Aug 13, 2019 7:56 pm
- [Solved] Conditional format cell
-
- [Solved] Conditional sum array syntax
by Aduxas » Wed Aug 07, 2019 9:48 pm
- 5 Replies
- 235 Views
- Last post by RusselB
Tue Aug 13, 2019 7:52 pm
- [Solved] Conditional sum array syntax
-
- [SOLVED] Error Format error in content.xml subdocument file
by ammatex » Fri Aug 09, 2019 6:43 pm - 19 Replies
- 427 Views
- Last post by MrProgrammer
Tue Aug 13, 2019 5:03 pm
- [SOLVED] Error Format error in content.xml subdocument file
Who is online
Users browsing this forum: Google [Bot] and 22 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
|