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: 31875
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33716
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30613
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 135661 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
- 45394 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- File needs to be recovered...again and again
by eleanorb » Sat Sep 26, 2020 6:39 pm - 6 Replies
- 97 Views
- Last post by RoryOF
Sun Sep 27, 2020 3:58 pm
- File needs to be recovered...again and again
-
- Search matching TEXT fields for "]" w/ regular experssion on
by Calc Searcher [88] » Thu Sep 24, 2020 6:29 pm - 2 Replies
- 86 Views
- Last post by Calc Searcher [88]
Sun Sep 27, 2020 2:38 pm
- Search matching TEXT fields for "]" w/ regular experssion on
-
- [Solved] Storing absolute cell reference as variable
by calculateur » Sun Sep 27, 2020 11:27 am - 6 Replies
- 61 Views
- Last post by Villeroy
Sun Sep 27, 2020 2:23 pm
- [Solved] Storing absolute cell reference as variable
-
- Title row with links
by hast66 » Fri Sep 25, 2020 9:31 pm
- 2 Replies
- 105 Views
- Last post by F3K Total
Sat Sep 26, 2020 9:28 am
- Title row with links
-
- Wrong DATE on XLXS email attachment is opened
by MegaWatts » Thu Sep 24, 2020 7:34 pm - 2 Replies
- 100 Views
- Last post by MrProgrammer
Fri Sep 25, 2020 6:33 pm
- Wrong DATE on XLXS email attachment is opened
-
- [Solved] Fill feature behaviour
by gm40 » Thu Sep 24, 2020 3:14 pm - 4 Replies
- 126 Views
- Last post by gm40
Fri Sep 25, 2020 10:52 am
- [Solved] Fill feature behaviour
-
- [Issue] Calc Changes First Char Case When Adding # to a Word
by crusader » Thu Sep 24, 2020 1:17 am - 6 Replies
- 157 Views
- Last post by robleyd
Fri Sep 25, 2020 12:54 am
- [Issue] Calc Changes First Char Case When Adding # to a Word
-
- [Solved] OpenOffice locks up
by MegaWatts » Thu Sep 24, 2020 5:01 pm - 9 Replies
- 131 Views
- Last post by MegaWatts
Thu Sep 24, 2020 10:57 pm
- [Solved] OpenOffice locks up
-
- [Solved] Using the fill handle; Freeze cell references
by calculateur » Thu Sep 24, 2020 6:36 pm - 2 Replies
- 80 Views
- Last post by calculateur
Thu Sep 24, 2020 9:38 pm
- [Solved] Using the fill handle; Freeze cell references
-
- [Solved] Caps won't hold
by Munchkin53 » Thu Sep 24, 2020 9:11 pm - 1 Replies
- 53 Views
- Last post by RusselB
Thu Sep 24, 2020 9:20 pm
- [Solved] Caps won't hold
-
- My first Extension not working
by cve60069 » Tue Sep 22, 2020 2:18 pm - 9 Replies
- 206 Views
- Last post by keme
Thu Sep 24, 2020 9:47 am
- My first Extension not working
-
- Formula =SumH13:H27 and 1C pop up
by KevinDFarms » Thu Sep 24, 2020 3:41 am
- 2 Replies
- 78 Views
- Last post by MrProgrammer
Thu Sep 24, 2020 6:24 am
- Formula =SumH13:H27 and 1C pop up
-
- "Find Text" Unexpected Error Causing Repeated Crashes 4.1.7
by Brother Rabbit » Wed Sep 23, 2020 10:09 pm - 1 Replies
- 64 Views
- Last post by RusselB
Thu Sep 24, 2020 12:23 am
- "Find Text" Unexpected Error Causing Repeated Crashes 4.1.7
-
- Row freeze lost
by charlesjoseph » Wed Sep 23, 2020 3:09 am - 1 Replies
- 47 Views
- Last post by FJCC
Wed Sep 23, 2020 4:46 am
- Row freeze lost
-
- File size larger than DIN A3?
by antsco » Tue Sep 22, 2020 7:57 pm - 5 Replies
- 106 Views
- Last post by RoryOF
Tue Sep 22, 2020 10:50 pm
- File size larger than DIN A3?
-
- [Solved] Text to columns help
by RusselB » Mon Sep 21, 2020 5:55 pm
- 5 Replies
- 154 Views
- Last post by RusselB
Tue Sep 22, 2020 8:47 pm
- [Solved] Text to columns help
-
- [Solved]Conditional Format w/Multiple Conditions & IF/AND/OR
by DAVID.DIMORA.SR » Mon Sep 21, 2020 5:36 pm
- 7 Replies
- 178 Views
- Last post by DAVID.DIMORA.SR
Tue Sep 22, 2020 8:13 pm
- [Solved]Conditional Format w/Multiple Conditions & IF/AND/OR
-
- Import copied text table to Calc with useful choices
by morphingstar » Fri Sep 18, 2020 3:58 am
- 8 Replies
- 230 Views
- Last post by Bill
Tue Sep 22, 2020 8:06 pm
- Import copied text table to Calc with useful choices
-
- [Solved] OpenOffice Calc hangs during auto save
by Nick Hope » Sat Nov 10, 2018 3:55 pm
- 11 Replies
- 820 Views
- Last post by minikin11
Tue Sep 22, 2020 7:33 pm
- [Solved] OpenOffice Calc hangs during auto save
-
- Create a graph showing number of times a number appears
by ThatRedMelon » Tue Sep 22, 2020 6:05 pm
- 3 Replies
- 84 Views
- Last post by Zizi64
Tue Sep 22, 2020 7:11 pm
- Create a graph showing number of times a number appears
-
- Remove phone numbers in spreadsheet 1 from spreadsheet 2
by BILL12321 » Sun Sep 20, 2020 11:51 pm
- 2 Replies
- 110 Views
- Last post by RusselB
Mon Sep 21, 2020 4:37 am
- Remove phone numbers in spreadsheet 1 from spreadsheet 2
-
- [SOLVED] results of Column B based on Column A of same row
by jbl1954 » Sun Sep 20, 2020 6:16 pm
- 6 Replies
- 133 Views
- Last post by jbl1954
Sun Sep 20, 2020 9:36 pm
- [SOLVED] results of Column B based on Column A of same row
-
- Input in sheet using a form
by ahidman » Sat Sep 19, 2020 12:33 pm - 2 Replies
- 143 Views
- Last post by Villeroy
Sat Sep 19, 2020 7:53 pm
- Input in sheet using a form
-
- [Solved] Lock fomulas on spreadsheet, but allow entrees
by GVS » Sat Sep 19, 2020 2:24 am
- 9 Replies
- 128 Views
- Last post by FJCC
Sat Sep 19, 2020 6:47 am
- [Solved] Lock fomulas on spreadsheet, but allow entrees
-
- [Solved] Line weight of one line of grid of spreadsheet
by White Fox » Fri Sep 18, 2020 6:39 pm - 2 Replies
- 108 Views
- Last post by White Fox
Sat Sep 19, 2020 4:14 am
- [Solved] Line weight of one line of grid of spreadsheet
-
- [Solved] IF/THEN/ELSE
by jbl1954 » Fri Sep 18, 2020 10:04 pm - 2 Replies
- 117 Views
- Last post by jbl1954
Fri Sep 18, 2020 11:27 pm
- [Solved] IF/THEN/ELSE
-
- [Solved] Function to give next digit in a sequence?
by MarkPawelek » Fri Sep 18, 2020 2:24 pm
- 1 Replies
- 104 Views
- Last post by FJCC
Fri Sep 18, 2020 3:48 pm
- [Solved] Function to give next digit in a sequence?
-
- Import text window (unable to open document)
by desdichato » Fri Sep 18, 2020 11:23 am
- 1 Replies
- 93 Views
- Last post by RoryOF
Fri Sep 18, 2020 11:56 am
- Import text window (unable to open document)
-
- Calc misbehaving editing a table Excel users also work on
by calcnub » Mon Aug 05, 2019 1:24 pm - 7 Replies
- 397 Views
- Last post by jakejf1
Fri Sep 18, 2020 4:05 am
- Calc misbehaving editing a table Excel users also work on
-
- Calculation
by richjarv » Thu Sep 17, 2020 8:15 pm - 1 Replies
- 110 Views
- Last post by RusselB
Thu Sep 17, 2020 10:47 pm
- Calculation
-
- [Solved] Move dotted lines which define print range
by John_Ha » Thu Sep 17, 2020 11:49 am
- 5 Replies
- 129 Views
- Last post by John_Ha
Thu Sep 17, 2020 6:31 pm
- [Solved] Move dotted lines which define print range
-
- [Solved] Chaining "if" functions
by i75Dave » Thu Sep 17, 2020 1:32 am - 4 Replies
- 125 Views
- Last post by i75Dave
Thu Sep 17, 2020 2:21 pm
- [Solved] Chaining "if" functions
-
- [Solved] IDAHC39M Code 39 Barcode Font
by looney2340 » Sat Sep 05, 2020 7:07 am - 4 Replies
- 202 Views
- Last post by looney2340
Thu Sep 17, 2020 6:24 am
- [Solved] IDAHC39M Code 39 Barcode Font
-
- [Solved] Nested IF() producing error 511
by hippyer » Wed Sep 16, 2020 8:11 pm - 2 Replies
- 114 Views
- Last post by hippyer
Wed Sep 16, 2020 9:32 pm
- [Solved] Nested IF() producing error 511
-
- [Solved] Retrieve value from last used cell in a column
by ljdriver » Thu Sep 10, 2020 7:46 pm
- 7 Replies
- 344 Views
- Last post by ljdriver
Tue Sep 15, 2020 5:55 pm
- [Solved] Retrieve value from last used cell in a column
-
- [Solved] calc insists on changing end letter to lower case.
by corystes » Tue Sep 15, 2020 10:18 am - 2 Replies
- 110 Views
- Last post by corystes
Tue Sep 15, 2020 12:22 pm
- [Solved] calc insists on changing end letter to lower case.
-
- [Solved] How to "Sort" cells with conditional formatting
by LloydIOW » Mon Sep 14, 2020 9:26 pm
- 3 Replies
- 142 Views
- Last post by robleyd
Tue Sep 15, 2020 12:23 am
- [Solved] How to "Sort" cells with conditional formatting
-
- [Solved] Tabulate formula result as precedent cell varies
by thebladeroden » Mon Sep 14, 2020 3:45 am
- 8 Replies
- 206 Views
- Last post by MrProgrammer
Mon Sep 14, 2020 5:48 pm
- [Solved] Tabulate formula result as precedent cell varies
-
- [Solved] How to use text string as external workbk reference
by MontyJ » Sat Sep 12, 2020 6:04 am
- 17 Replies
- 269 Views
- Last post by Villeroy
Sun Sep 13, 2020 12:02 pm
- [Solved] How to use text string as external workbk reference
-
- [Solved] Lists Within Cells (Thanks, David)
by Padeen » Sat Sep 12, 2020 9:01 pm - 5 Replies
- 166 Views
- Last post by robleyd
Sun Sep 13, 2020 2:09 am
- [Solved] Lists Within Cells (Thanks, David)
-
- [Solved] Create a 'label' mail merge
by katintn » Sat Sep 12, 2020 5:53 pm - 2 Replies
- 94 Views
- Last post by katintn
Sun Sep 13, 2020 12:41 am
- [Solved] Create a 'label' mail merge
-
- [Solved] jump to another cell
by hast66 » Fri Sep 11, 2020 11:11 pm - 2 Replies
- 151 Views
- Last post by hast66
Sat Sep 12, 2020 11:11 pm
- [Solved] jump to another cell
-
- [Solved] Keeps changing value to a date format
by tom182 » Thu Sep 10, 2020 9:02 pm - 3 Replies
- 208 Views
- Last post by Villeroy
Sat Sep 12, 2020 4:40 pm
- [Solved] Keeps changing value to a date format
-
- Find & Replace searching formulas instead of values?
by Ssronica » Sat Sep 12, 2020 3:13 pm - 2 Replies
- 132 Views
- Last post by FJCC
Sat Sep 12, 2020 4:20 pm
- Find & Replace searching formulas instead of values?
-
- [Solved] Editable contents, but lock cell formatting?
by jxxtan » Fri Sep 11, 2020 12:23 am - 4 Replies
- 159 Views
- Last post by jxxtan
Fri Sep 11, 2020 3:31 pm
- [Solved] Editable contents, but lock cell formatting?
-
- Formatting page dialog with dual screens
by Plugger602 » Fri Sep 11, 2020 1:54 am - 4 Replies
- 167 Views
- Last post by RoryOF
Fri Sep 11, 2020 10:10 am
- Formatting page dialog with dual screens
-
- Quickbooks export to excel
by Trout » Sat May 08, 2010 5:39 pm - 5 Replies
- 3547 Views
- Last post by Villeroy
Thu Sep 10, 2020 3:16 pm
- Quickbooks export to excel
-
- [Solved] Date format problem
by desdichato » Wed Sep 09, 2020 10:27 am
- 3 Replies
- 177 Views
- Last post by robleyd
Thu Sep 10, 2020 12:54 am
- [Solved] Date format problem
-
- [Solved] Using IF to calculate criteria has string or number
by retsamboon » Wed Sep 09, 2020 5:56 am - 4 Replies
- 170 Views
- Last post by Zizi64
Wed Sep 09, 2020 4:09 pm
- [Solved] Using IF to calculate criteria has string or number
Who is online
Users browsing this forum: No registered users and 21 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
|