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: 32170
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 34020
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30938
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 145073 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
- 46302 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Stopping Calc from changing uppercase to lowercase
by TJOnline » Mon Oct 19, 2020 11:23 pm - 2 Replies
- 37 Views
- Last post by robleyd
Tue Oct 20, 2020 1:18 am
- Stopping Calc from changing uppercase to lowercase
-
- Linebreaks not working?
by fiona87 » Mon Oct 19, 2020 2:08 pm
- 7 Replies
- 111 Views
- Last post by MrProgrammer
Mon Oct 19, 2020 8:07 pm
- Linebreaks not working?
-
- Freezing top row
by kevinmcfeely » Mon Oct 19, 2020 6:11 pm - 1 Replies
- 33 Views
- Last post by RusselB
Mon Oct 19, 2020 6:16 pm
- Freezing top row
-
- Insert a number in a cell
by danno » Mon Oct 19, 2020 12:49 pm
- 3 Replies
- 65 Views
- Last post by danno
Mon Oct 19, 2020 3:40 pm
- Insert a number in a cell
-
- Need help with complex formula
by Esch » Mon Oct 19, 2020 3:32 am
- 4 Replies
- 99 Views
- Last post by Villeroy
Mon Oct 19, 2020 2:48 pm
- Need help with complex formula
-
- Print preview is blank
by danno » Mon Oct 19, 2020 12:47 am
- 6 Replies
- 90 Views
- Last post by danno
Mon Oct 19, 2020 12:44 pm
- Print preview is blank
-
- [Solved] Move multiple entire rows
by stacie » Sun Oct 18, 2020 12:25 am - 8 Replies
- 155 Views
- Last post by stacie
Sun Oct 18, 2020 9:20 pm
- [Solved] Move multiple entire rows
-
- [Solved] Equation doesn't work in one cell, works in others
by stacie » Sun Oct 18, 2020 5:36 pm - 2 Replies
- 63 Views
- Last post by stacie
Sun Oct 18, 2020 5:54 pm
- [Solved] Equation doesn't work in one cell, works in others
-
- [Solved] Recover hyperlink
by kenppy » Sat Oct 17, 2020 9:20 pm
- 1 Replies
- 67 Views
- Last post by Lupp
Sun Oct 18, 2020 12:15 am
- [Solved] Recover hyperlink
-
- Can't Graph this data
by jonclark123 » Sat Oct 17, 2020 6:12 pm
- 3 Replies
- 85 Views
- Last post by RoryOF
Sat Oct 17, 2020 7:24 pm
- Can't Graph this data
-
- Disable Ctrl+Mouse Wheel = Zoom In/Out
by White Phoenix » Fri Oct 16, 2020 2:12 pm - 4 Replies
- 130 Views
- Last post by White Phoenix
Sat Oct 17, 2020 4:19 pm
- Disable Ctrl+Mouse Wheel = Zoom In/Out
-
- Can't open password protected xlxs excel spreadsheets
by bjvirovatz » Fri Oct 16, 2020 11:34 pm - 1 Replies
- 82 Views
- Last post by Zizi64
Sat Oct 17, 2020 7:35 am
- Can't open password protected xlxs excel spreadsheets
-
- [Solved] Keyboard Cut/Paste in Calc
by grenik » Mon Oct 12, 2020 11:24 pm
- 9 Replies
- 277 Views
- Last post by grenik
Sat Oct 17, 2020 3:54 am
- [Solved] Keyboard Cut/Paste in Calc
-
- Looks like a comment but it isn't
by FJCC » Fri Oct 16, 2020 10:02 pm
- 4 Replies
- 80 Views
- Last post by MrProgrammer
Sat Oct 17, 2020 12:27 am
- Looks like a comment but it isn't
-
- How to fix this " Spelling Check " keep poped up
by ichinozori » Fri Oct 16, 2020 9:04 am - 1 Replies
- 64 Views
- Last post by Hagar Delest
Fri Oct 16, 2020 10:13 am
- How to fix this " Spelling Check " keep poped up
-
- How to copy formula in row to column in another spreadsheet?
by charlesjoseph » Thu Oct 15, 2020 4:33 am - 2 Replies
- 75 Views
- Last post by Zizi64
Thu Oct 15, 2020 6:54 am
- How to copy formula in row to column in another spreadsheet?
-
- Enabling macros — What setting should I use?
by mhdraperme » Thu Jul 24, 2014 2:01 am - 6 Replies
- 3421 Views
- Last post by robleyd
Thu Oct 15, 2020 12:21 am
- Enabling macros — What setting should I use?
-
- Any shortcut for importing MANY files in fixed-width format?
by steve-o » Tue Oct 13, 2020 11:47 pm - 6 Replies
- 165 Views
- Last post by Villeroy
Wed Oct 14, 2020 3:43 pm
- Any shortcut for importing MANY files in fixed-width format?
-
- Importing fixed width files into template
by Maddog » Mon Jun 09, 2008 5:37 pm - 5 Replies
- 1795 Views
- Last post by Villeroy
Wed Oct 14, 2020 10:17 am
- Importing fixed width files into template
-
- Find words in a list using multiple criteria
by Craig209Smith » Mon Oct 12, 2020 11:48 pm
- 6 Replies
- 226 Views
- Last post by MrProgrammer
Wed Oct 14, 2020 3:32 am
- Find words in a list using multiple criteria
-
- [Solved] Freeze rows & columns
by bernieb123 » Tue Oct 13, 2020 2:55 am
- 6 Replies
- 155 Views
- Last post by bernieb123
Tue Oct 13, 2020 4:25 am
- [Solved] Freeze rows & columns
-
- [Solved] Order in which calculations proceed
by monstercarp » Mon Oct 12, 2020 8:54 pm
- 3 Replies
- 130 Views
- Last post by John_Ha
Tue Oct 13, 2020 12:41 am
- [Solved] Order in which calculations proceed
-
- [Solved] Short cut for copy/paste special/formula?
by legalnan » Fri Oct 09, 2020 4:58 am - 2 Replies
- 154 Views
- Last post by legalnan
Mon Oct 12, 2020 6:26 am
- [Solved] Short cut for copy/paste special/formula?
-
- Calc: Combine Data from Two Sheets
by truematic » Sun Oct 11, 2020 6:18 am
- 8 Replies
- 203 Views
- Last post by truematic
Mon Oct 12, 2020 12:02 am
- Calc: Combine Data from Two Sheets
-
- [Solved] Highlighting all duplicate entries on a sheet
by Maeryn » Thu Oct 08, 2020 5:16 pm
- 10 Replies
- 313 Views
- Last post by Villeroy
Sun Oct 11, 2020 5:22 pm
- [Solved] Highlighting all duplicate entries on a sheet
-
- [Solved] Conditional IF query
by Mexicanpete » Sun Oct 11, 2020 9:28 am - 3 Replies
- 195 Views
- Last post by robleyd
Sun Oct 11, 2020 11:20 am
- [Solved] Conditional IF query
-
- Chart creation?
by jackrcook » Sat Oct 10, 2020 10:28 pm
- 1 Replies
- 132 Views
- Last post by FJCC
Sat Oct 10, 2020 11:46 pm
- Chart creation?
-
- [Dropped] Cannot edit Calc spreadsheet
by lcrombie » Fri Oct 09, 2020 8:16 pm - 6 Replies
- 210 Views
- Last post by Bill
Sat Oct 10, 2020 8:54 pm
- [Dropped] Cannot edit Calc spreadsheet
-
- Recovery FORGETS password protection
by peanutaxis » Sat Oct 10, 2020 3:53 am - 1 Replies
- 112 Views
- Last post by Villeroy
Sat Oct 10, 2020 5:17 am
- Recovery FORGETS password protection
-
- [Solved] Basic OpenOffice spreadsheet set up
by Gary Lee » Fri Oct 09, 2020 5:19 pm - 1 Replies
- 143 Views
- Last post by RoryOF
Fri Oct 09, 2020 6:04 pm
- [Solved] Basic OpenOffice spreadsheet set up
-
- [Solved] Calc: Referencing cells to worksheets
by dh63 » Fri Oct 09, 2020 12:58 am
- 2 Replies
- 150 Views
- Last post by dh63
Fri Oct 09, 2020 1:20 pm
- [Solved] Calc: Referencing cells to worksheets
-
- [Solved] Converting a string into a cell number
by clfaye » Thu Oct 08, 2020 9:17 pm - 2 Replies
- 115 Views
- Last post by clfaye
Thu Oct 08, 2020 9:41 pm
- [Solved] Converting a string into a cell number
-
- [Dropped] Fatal Error
by kzog711 » Thu Oct 08, 2020 6:05 pm - 1 Replies
- 120 Views
- Last post by RusselB
Thu Oct 08, 2020 8:35 pm
- [Dropped] Fatal Error
-
- [Solved] COUNTIF with LEFT
by Calc Searcher [88] » Mon Sep 28, 2020 3:56 pm - 4 Replies
- 469 Views
- Last post by MrProgrammer
Thu Oct 08, 2020 6:28 pm
- [Solved] COUNTIF with LEFT
-
- Formula not working #VALUE!
by Hardrockbaer » Thu Oct 08, 2020 9:55 am - 12 Replies
- 261 Views
- Last post by Villeroy
Thu Oct 08, 2020 6:18 pm
- Formula not working #VALUE!
-
- Difference between date/time combos greater than 24 hour
by Calc Searcher [88] » Thu Oct 08, 2020 2:34 pm - 1 Replies
- 120 Views
- Last post by FJCC
Thu Oct 08, 2020 3:28 pm
- Difference between date/time combos greater than 24 hour
-
- [Closed] Program to check rear suspension of racing car
by JamRacing » Tue Oct 06, 2020 11:12 pm
- 12 Replies
- 265 Views
- Last post by Hagar Delest
Wed Oct 07, 2020 10:15 pm
- [Closed] Program to check rear suspension of racing car
-
- "Find Text" Unexpected Error Causing Repeated Crashes 4.1.7
by Brother Rabbit » Wed Sep 23, 2020 10:09 pm - 2 Replies
- 280 Views
- Last post by Brother Rabbit
Wed Oct 07, 2020 7:29 pm
- "Find Text" Unexpected Error Causing Repeated Crashes 4.1.7
-
- [Solved] Suppress convert fractions, superscript ordinals?
by swampwiz » Wed Oct 07, 2020 6:50 pm - 2 Replies
- 100 Views
- Last post by RusselB
Wed Oct 07, 2020 7:16 pm
- [Solved] Suppress convert fractions, superscript ordinals?
-
- Import Calc cells in pdf forms
by karkhi78 » Wed Oct 07, 2020 12:47 pm
- 2 Replies
- 108 Views
- Last post by Mountaineer
Wed Oct 07, 2020 5:55 pm
- Import Calc cells in pdf forms
-
- [Solved] Copy/Pasting from Safari issue
by Xhuxhmaxhuxh » Sat Oct 03, 2020 5:01 pm
- 1 Replies
- 361 Views
- Last post by MrProgrammer
Wed Oct 07, 2020 5:51 pm
- [Solved] Copy/Pasting from Safari issue
-
- [Solved] Delete apostrophe before numbers in all cells?
by Kingrazor » Fri Mar 16, 2012 4:38 am - 29 Replies
- 123329 Views
- Last post by Ari Abrams
Wed Oct 07, 2020 10:53 am
- [Solved] Delete apostrophe before numbers in all cells?
-
- [Solved] Create bank statement in Calc
by bernieb123 » Mon Oct 05, 2020 10:23 pm - 10 Replies
- 348 Views
- Last post by robleyd
Wed Oct 07, 2020 9:55 am
- [Solved] Create bank statement in Calc
-
- [SOLVED] Wrong results using cells with formulas
by Rawhidepd » Mon Oct 05, 2020 9:15 pm - 2 Replies
- 284 Views
- Last post by Rawhidepd
Wed Oct 07, 2020 12:04 am
- [SOLVED] Wrong results using cells with formulas
-
- Copy/paste without changing one cell reference
by bardkin » Tue Oct 06, 2020 3:25 pm - 1 Replies
- 176 Views
- Last post by RusselB
Tue Oct 06, 2020 6:43 pm
- Copy/paste without changing one cell reference
-
- [Solved] Help with chart basics
by Mexicanpete » Sun Oct 04, 2020 11:03 am
- 6 Replies
- 491 Views
- Last post by robleyd
Tue Oct 06, 2020 11:02 am
- [Solved] Help with chart basics
-
- [Solved] Max/Min based on cell values in other column
by A.Fish » Sat Oct 03, 2020 5:14 pm
- 5 Replies
- 502 Views
- Last post by A.Fish
Mon Oct 05, 2020 10:03 pm
- [Solved] Max/Min based on cell values in other column
-
- [Solved] Error 512 (Formula overflow) for huge formula
by baggers » Thu Oct 01, 2020 7:33 pm
- 20 Replies
- 936 Views
- Last post by Villeroy
Mon Oct 05, 2020 6:58 pm
- [Solved] Error 512 (Formula overflow) for huge formula
-
- Equivalent to MS Excel textjoin
by Deltoren » Sun Oct 04, 2020 7:21 pm - 8 Replies
- 483 Views
- Last post by Zizi64
Mon Oct 05, 2020 8:58 am
- Equivalent to MS Excel textjoin
Who is online
Users browsing this forum: No registered users and 18 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
|