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: 31905
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33751
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30647
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 136746 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Combine rows based on a key field
by Tiggere » Mon Apr 27, 2020 10:06 pm - 3 Replies
- 381 Views
- Last post by Tiggere
Tue Jun 02, 2020 11:54 pm
- [Solved] Combine rows based on a key field
-
- [Solved] =CELL("FILENAME";A1) no autoupdate
by morphingstar » Tue Jun 02, 2020 5:50 pm - 3 Replies
- 231 Views
- Last post by Villeroy
Tue Jun 02, 2020 11:43 pm
- [Solved] =CELL("FILENAME";A1) no autoupdate
-
- [Solved] Open spreadsheet at last edit location
by sutty68 » Tue Jun 02, 2020 1:05 pm - 4 Replies
- 343 Views
- Last post by Villeroy
Tue Jun 02, 2020 5:14 pm
- [Solved] Open spreadsheet at last edit location
-
- New to using a Pivot Table
by cigicomu » Tue Jun 02, 2020 12:24 pm - 1 Replies
- 188 Views
- Last post by Villeroy
Tue Jun 02, 2020 1:19 pm
- New to using a Pivot Table
-
- [Solved] Two Lines in One Cell
by fitfatale » Sun May 31, 2020 4:54 pm - 8 Replies
- 449 Views
- Last post by Lupp
Mon Jun 01, 2020 10:52 pm
- [Solved] Two Lines in One Cell
-
- [Solved] What algorithm does Calc use to smooth XY charts?
by seansl » Sun May 31, 2020 11:40 pm - 3 Replies
- 252 Views
- Last post by Zizi64
Mon Jun 01, 2020 7:39 am
- [Solved] What algorithm does Calc use to smooth XY charts?
-
- Automate query
by dentopolis » Sun May 31, 2020 6:52 pm - 1 Replies
- 210 Views
- Last post by Villeroy
Sun May 31, 2020 7:32 pm
- Automate query
-
- [Solved] Duplicating cells
by TechnoChicken » Sat May 30, 2020 9:59 pm
- 5 Replies
- 278 Views
- Last post by TechnoChicken
Sun May 31, 2020 5:24 pm
- [Solved] Duplicating cells
-
- [Solved] Imported data not recognized as numeric
by Yuoga » Sat May 30, 2020 3:17 pm
- 14 Replies
- 564 Views
- Last post by Villeroy
Sun May 31, 2020 3:49 pm
- [Solved] Imported data not recognized as numeric
-
- Date format ...... 'DD.MM.YYYY
by BubikolRamios » Sat May 30, 2020 6:02 pm - 4 Replies
- 217 Views
- Last post by Villeroy
Sat May 30, 2020 7:32 pm
- Date format ...... 'DD.MM.YYYY
-
- [Solved] Insert fixed data in multiple cells
by nal » Sat May 30, 2020 1:52 pm
- 3 Replies
- 211 Views
- Last post by nal
Sat May 30, 2020 4:48 pm
- [Solved] Insert fixed data in multiple cells
-
- [Solved] Bulk edit contents of a column in OpenOffice Calc
by idahohcs@gmail.com » Sat May 30, 2020 4:16 pm - 1 Replies
- 167 Views
- Last post by MrProgrammer
Sat May 30, 2020 4:35 pm
- [Solved] Bulk edit contents of a column in OpenOffice Calc
-
- [Solved] Turning off scientific notation
by Just-Al » Fri May 29, 2020 5:45 pm - 1 Replies
- 245 Views
- Last post by FJCC
Fri May 29, 2020 6:45 pm
- [Solved] Turning off scientific notation
-
- Sheet Tab in Calc too small
by pvictory5 » Fri May 29, 2020 4:01 pm - 1 Replies
- 183 Views
- Last post by lader
Fri May 29, 2020 6:01 pm
- Sheet Tab in Calc too small
-
- [Solved] Find and display array row content with 2 criteria
by morphingstar » Thu May 28, 2020 5:47 am
- 2 Replies
- 249 Views
- Last post by morphingstar
Thu May 28, 2020 4:58 pm
- [Solved] Find and display array row content with 2 criteria
-
- [Solved] Using "RANDBETWEEN" and I want no dups listed.
by infoseeker » Thu May 28, 2020 8:43 am
- 3 Replies
- 246 Views
- Last post by infoseeker
Thu May 28, 2020 10:30 am
- [Solved] Using "RANDBETWEEN" and I want no dups listed.
-
- [Solved] How to write formula to extract parts of cell
by Louye » Thu May 28, 2020 1:54 am - 7 Replies
- 350 Views
- Last post by robleyd
Thu May 28, 2020 9:29 am
- [Solved] How to write formula to extract parts of cell
-
- [Solved] Validity choice results in error in Vlookup
by morphingstar » Wed May 20, 2020 10:20 pm
- 8 Replies
- 626 Views
- Last post by robleyd
Thu May 28, 2020 6:23 am
- [Solved] Validity choice results in error in Vlookup
-
- General input/output error
by jantom » Wed May 27, 2020 7:51 pm - 1 Replies
- 185 Views
- Last post by John_Ha
Wed May 27, 2020 9:09 pm
- General input/output error
-
- Change data range when not continuous
by ronanski » Mon May 25, 2020 2:04 pm
- 7 Replies
- 535 Views
- Last post by ronanski
Wed May 27, 2020 8:18 pm
- Change data range when not continuous
-
- Create SQL Insert Statement from Table
by lvlanson » Wed May 27, 2020 11:43 am - 2 Replies
- 218 Views
- Last post by Villeroy
Wed May 27, 2020 6:52 pm
- Create SQL Insert Statement from Table
-
- [Solved] Combine groups, separated by commas
by ABell247 » Tue May 19, 2020 5:05 pm
- 6 Replies
- 408 Views
- Last post by ABell247
Tue May 26, 2020 9:25 pm
- [Solved] Combine groups, separated by commas
-
- Conditional Formatting on Spreadsheet
by swsoldguy » Tue May 26, 2020 3:57 pm
- 5 Replies
- 300 Views
- Last post by Villeroy
Tue May 26, 2020 8:13 pm
- Conditional Formatting on Spreadsheet
-
- Can't use ranges with graphs
by Isak » Mon May 25, 2020 10:25 pm
- 4 Replies
- 328 Views
- Last post by Lupp
Tue May 26, 2020 11:31 am
- Can't use ranges with graphs
-
- [Solved] Disable scientific notation for long numbers
1, 2 by jazzparadigm » Tue Nov 08, 2011 4:52 pm
- 31 Replies
- 31473 Views
- Last post by Villeroy
Mon May 25, 2020 9:37 am
- [Solved] Disable scientific notation for long numbers
-
- [Solved] Identify sheet tab color
by ferdy » Sat May 23, 2020 3:41 pm
- 9 Replies
- 486 Views
- Last post by ferdy
Sun May 24, 2020 8:25 pm
- [Solved] Identify sheet tab color
-
- [Solved] Text to Columns Won't Work Properly
by shir » Sat May 23, 2020 7:25 pm - 1 Replies
- 235 Views
- Last post by MrProgrammer
Sat May 23, 2020 7:42 pm
- [Solved] Text to Columns Won't Work Properly
-
- [Solved] Correction in a cell
by tadd5181 » Fri May 22, 2020 7:11 pm
- 4 Replies
- 304 Views
- Last post by Zizi64
Sat May 23, 2020 7:31 pm
- [Solved] Correction in a cell
-
- Save selected character set for DBase import
by Max S. » Sat May 23, 2020 2:54 pm
- 2 Replies
- 210 Views
- Last post by Villeroy
Sat May 23, 2020 4:06 pm
- Save selected character set for DBase import
-
- [Solved] How Do I Find, Highlight, and Copy...
by ShinjiTakeyama » Fri May 22, 2020 6:40 pm
- 4 Replies
- 318 Views
- Last post by ShinjiTakeyama
Sat May 23, 2020 7:43 am
- [Solved] How Do I Find, Highlight, and Copy...
-
- [Solved] Calc max/lookup formula
by jbl1954 » Fri May 22, 2020 9:59 pm - 2 Replies
- 233 Views
- Last post by jbl1954
Fri May 22, 2020 10:38 pm
- [Solved] Calc max/lookup formula
-
- Basic help to add a row to OO Calc
by Atheling » Fri May 22, 2020 10:02 am
- 3 Replies
- 275 Views
- Last post by Atheling
Fri May 22, 2020 8:46 pm
- Basic help to add a row to OO Calc
-
- [Solved] 'Format Cells' window very slow to respond
by melestech » Thu May 21, 2020 11:53 pm - 3 Replies
- 296 Views
- Last post by melestech
Fri May 22, 2020 5:02 pm
- [Solved] 'Format Cells' window very slow to respond
-
- [Solved *] Sheets with graphs will not copy properly
by labsys » Thu May 21, 2020 4:20 pm - 14 Replies
- 674 Views
- Last post by labsys
Fri May 22, 2020 4:23 pm
- [Solved *] Sheets with graphs will not copy properly
-
- [Solved] Adding cells if not blanks
by Amn Ojee Uw » Fri May 22, 2020 12:47 pm - 3 Replies
- 199 Views
- Last post by Villeroy
Fri May 22, 2020 1:01 pm
- [Solved] Adding cells if not blanks
-
- SARS easyfile
by bobglen » Thu May 13, 2010 9:46 pm
- 6 Replies
- 7663 Views
- Last post by keme
Fri May 22, 2020 10:16 am
- SARS easyfile
-
- [SOLVED] How can I find next to last value in a column?
by needsoundhelp » Fri May 22, 2020 8:12 am - 4 Replies
- 260 Views
- Last post by needsoundhelp
Fri May 22, 2020 9:22 am
- [SOLVED] How can I find next to last value in a column?
-
- Breakeven formula
by keneso » Fri May 22, 2020 12:10 am - 1 Replies
- 222 Views
- Last post by RusselB
Fri May 22, 2020 2:26 am
- Breakeven formula
-
- [Solved] Counting recurring values and reset counter
by withnail » Wed May 20, 2020 6:56 pm
- 2 Replies
- 212 Views
- Last post by withnail
Wed May 20, 2020 7:59 pm
- [Solved] Counting recurring values and reset counter
-
- [Solved] Capitalize the first letter in a cell
by fred6633 » Sat Mar 07, 2009 12:14 pm - 5 Replies
- 2178 Views
- Last post by jbl1954
Wed May 20, 2020 6:26 pm
- [Solved] Capitalize the first letter in a cell
-
- [Solved-Workaround] Page break on every line
by labsys » Sun May 17, 2020 1:33 am
- 22 Replies
- 1120 Views
- Last post by labsys
Wed May 20, 2020 6:10 pm
- [Solved-Workaround] Page break on every line
-
- LibreOffice: dashed line
by OpenOfficeFreakiusYo » Wed May 20, 2020 12:12 pm
- 2 Replies
- 199 Views
- Last post by Villeroy
Wed May 20, 2020 2:09 pm
- LibreOffice: dashed line
-
- [Solved] How to use Dates in IF statements?
by BTFT66 » Tue May 19, 2020 9:01 am
- 13 Replies
- 571 Views
- Last post by BTFT66
Wed May 20, 2020 6:57 am
- [Solved] How to use Dates in IF statements?
-
- Sheet reference using text from cell
by cpmac » Tue May 19, 2020 4:28 pm
- 1 Replies
- 174 Views
- Last post by JohnSUN-Pensioner
Tue May 19, 2020 5:21 pm
- Sheet reference using text from cell
-
- [Solved] Start counting the rows from row 2 instead of row1
by AlwaysOnTop » Mon May 18, 2020 8:25 pm - 3 Replies
- 270 Views
- Last post by RusselB
Tue May 19, 2020 3:26 am
- [Solved] Start counting the rows from row 2 instead of row1
-
- Date changes
by Oak » Mon May 18, 2020 3:02 pm - 3 Replies
- 242 Views
- Last post by Villeroy
Mon May 18, 2020 8:15 pm
- Date changes
-
- [Solved] Save as Text CSV- Default export parameters
by MrMarius » Fri May 15, 2020 10:15 pm - 7 Replies
- 414 Views
- Last post by Villeroy
Sat May 16, 2020 1:13 pm
- [Solved] Save as Text CSV- Default export parameters
-
- How to change font color if ...
by Kari52 » Fri May 15, 2020 4:16 pm
- 10 Replies
- 479 Views
- Last post by John_Ha
Sat May 16, 2020 12:42 pm
- How to change font color if ...
-
- [Solved] Average dropping lowest N items
by jyoung » Fri May 15, 2020 9:03 pm
- 3 Replies
- 272 Views
- Last post by jyoung
Sat May 16, 2020 3:07 am
- [Solved] Average dropping lowest N items
-
- [Solved] Move column
by manoman » Tue Sep 17, 2019 6:46 pm
- 12 Replies
- 1437 Views
- Last post by roddy
Fri May 15, 2020 7:11 am
- [Solved] Move column
Who is online
Users browsing this forum: No registered users and 17 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
|