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: 26575
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 27734
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 24324
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 28674 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
- 32037 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Once Again External Links Process is Broken for Me
by mokanman » Fri Feb 22, 2019 12:36 am - 0 Replies
- 26 Views
- Last post by mokanman
Fri Feb 22, 2019 12:36 am
- Once Again External Links Process is Broken for Me
-
- Multiple closely related questions related to saving docs
by ThomasH » Tue Feb 19, 2019 3:50 am
- 8 Replies
- 159 Views
- Last post by ThomasH
Fri Feb 22, 2019 12:11 am
- Multiple closely related questions related to saving docs
-
- "Locked by Unknown User" after upgrade to 4.1.6
by THEBookMan » Fri Nov 23, 2018 9:01 pm - 15 Replies
- 384 Views
- Last post by RoryOF
Thu Feb 21, 2019 10:17 pm
- "Locked by Unknown User" after upgrade to 4.1.6
-
- Locate In 1 Spreadsheet and Replace In Another
by adventurehouse » Wed Feb 20, 2019 3:55 pm
- 3 Replies
- 124 Views
- Last post by RusselB
Thu Feb 21, 2019 2:23 am
- Locate In 1 Spreadsheet and Replace In Another
-
- [Solved] How to find alternating numbers in a column
by withnail » Wed Feb 20, 2019 7:01 pm
- 6 Replies
- 111 Views
- Last post by withnail
Wed Feb 20, 2019 9:43 pm
- [Solved] How to find alternating numbers in a column
-
- Solved] Spreadsheet Formulae
by Leveraa » Fri Feb 15, 2019 4:42 pm - 6 Replies
- 211 Views
- Last post by John_Ha
Wed Feb 20, 2019 8:43 pm
- Solved] Spreadsheet Formulae
-
- Search for numbers depending the presence of another cell.
by Kryonox » Sun Feb 17, 2019 9:52 pm
- 2 Replies
- 128 Views
- Last post by Kryonox
Wed Feb 20, 2019 6:09 pm
- Search for numbers depending the presence of another cell.
-
- Set cell colour based on other cell colour
by Mpl82 » Mon Feb 18, 2019 12:28 pm - 12 Replies
- 178 Views
- Last post by hubert lambert
Wed Feb 20, 2019 10:40 am
- Set cell colour based on other cell colour
-
- [Solved] Sum if adjacent contains...
by illern » Tue Feb 19, 2019 5:15 pm
- 3 Replies
- 118 Views
- Last post by robleyd
Wed Feb 20, 2019 12:08 am
- [Solved] Sum if adjacent contains...
-
- Continuous save
by THEBookMan » Wed Feb 13, 2019 5:38 pm - 10 Replies
- 214 Views
- Last post by Hagar Delest
Tue Feb 19, 2019 9:30 am
- Continuous save
-
- Photo fitting to fill cell?
by mmi » Tue Feb 19, 2019 1:49 am - 1 Replies
- 60 Views
- Last post by Zizi64
Tue Feb 19, 2019 8:41 am
- Photo fitting to fill cell?
-
- Remove Duplicates
by ThomasH » Tue Feb 19, 2019 3:27 am - 2 Replies
- 88 Views
- Last post by ThomasH
Tue Feb 19, 2019 6:05 am
- Remove Duplicates
-
- [SOLVED] Help converting Excel formula to AOO formula
by Imtom.113 » Mon Feb 18, 2019 8:35 pm - 3 Replies
- 111 Views
- Last post by Villeroy
Mon Feb 18, 2019 10:55 pm
- [SOLVED] Help converting Excel formula to AOO formula
-
- [Solved] Add text from 2 columns
by rbc » Mon Feb 18, 2019 6:19 pm - 2 Replies
- 72 Views
- Last post by rbc
Mon Feb 18, 2019 8:27 pm
- [Solved] Add text from 2 columns
-
- How can I automatically turn urls into hyperlinks in Calc?
by erichepperle » Fri Feb 15, 2019 11:49 pm
- 3 Replies
- 119 Views
- Last post by MrProgrammer
Mon Feb 18, 2019 6:25 pm
- How can I automatically turn urls into hyperlinks in Calc?
-
- Can't save a copy of a password protected spreadsheet
by peppermintjan » Mon Feb 18, 2019 1:44 am - 3 Replies
- 119 Views
- Last post by Villeroy
Mon Feb 18, 2019 5:29 pm
- Can't save a copy of a password protected spreadsheet
-
- [Solved] Sorting Numbers after calculations
by Boothulu » Sun Feb 17, 2019 6:39 pm
- 5 Replies
- 155 Views
- Last post by Lupp
Mon Feb 18, 2019 2:11 pm
- [Solved] Sorting Numbers after calculations
-
- Split Cells
by kik94 » Mon Feb 18, 2019 9:08 am - 2 Replies
- 102 Views
- Last post by Lupp
Mon Feb 18, 2019 10:08 am
- Split Cells
-
- All my work gone even with autosave on?
by fatgreta » Sun Feb 17, 2019 11:52 pm - 2 Replies
- 105 Views
- Last post by fatgreta
Mon Feb 18, 2019 4:33 am
- All my work gone even with autosave on?
-
- [Solved] Adding blank rows between rows
by Lindy » Tue Jan 18, 2011 5:20 pm - 9 Replies
- 7175 Views
- Last post by acheide
Mon Feb 18, 2019 12:26 am
- [Solved] Adding blank rows between rows
-
- [Solved] Formula for dates
by Imtom.113 » Wed Feb 13, 2019 3:05 am - 4 Replies
- 199 Views
- Last post by robleyd
Sun Feb 17, 2019 2:50 am
- [Solved] Formula for dates
-
- [Solved] How to find longest recurring sequence in a column
by withnail » Fri Feb 15, 2019 11:38 pm
- 17 Replies
- 243 Views
- Last post by withnail
Sun Feb 17, 2019 1:18 am
- [Solved] How to find longest recurring sequence in a column
-
- [Solved] IF then statements - requirements changed
by lhentz » Fri Feb 15, 2019 8:39 pm
- 5 Replies
- 170 Views
- Last post by lhentz
Sat Feb 16, 2019 9:23 pm
- [Solved] IF then statements - requirements changed
-
- QuickBooks
by KAlmy » Thu Mar 17, 2011 11:24 pm - 11 Replies
- 6028 Views
- Last post by BRSCPA
Sat Feb 16, 2019 6:56 pm
- QuickBooks
-
- [Solved] Used AutoCorrect but text changed to lowercase
by ExK » Sat Feb 16, 2019 12:02 pm - 2 Replies
- 85 Views
- Last post by ExK
Sat Feb 16, 2019 5:22 pm
- [Solved] Used AutoCorrect but text changed to lowercase
-
- How to create indented decimal-numbered columns?
by erichepperle » Fri Feb 15, 2019 10:56 pm - 1 Replies
- 97 Views
- Last post by RusselB
Sat Feb 16, 2019 3:52 am
- How to create indented decimal-numbered columns?
-
- [Solved] Date differential
by rbc » Fri Feb 15, 2019 4:15 am - 12 Replies
- 194 Views
- Last post by Villeroy
Fri Feb 15, 2019 6:35 pm
- [Solved] Date differential
-
- ODS file asks for text import then opens blank
by Freyaness » Mon Dec 10, 2012 4:38 pm
- 26 Replies
- 10013 Views
- Last post by John_Ha
Fri Feb 15, 2019 12:50 pm
- ODS file asks for text import then opens blank
-
- [Solved] Is there a way to reference "the cell above this"
by CaveDweller » Sun Jul 15, 2018 8:23 am
- 7 Replies
- 520 Views
- Last post by robleyd
Fri Feb 15, 2019 12:10 pm
- [Solved] Is there a way to reference "the cell above this"
-
- [Solved] Convert 3-letter Month to Numeric Format
by crusader » Wed Feb 13, 2019 3:04 am
- 13 Replies
- 259 Views
- Last post by Villeroy
Fri Feb 15, 2019 1:33 am
- [Solved] Convert 3-letter Month to Numeric Format
-
- [Solved] Custom AVERAGE/MEAN function
by nicalex » Thu Feb 14, 2019 2:36 pm
- 7 Replies
- 168 Views
- Last post by nicalex
Thu Feb 14, 2019 9:36 pm
- [Solved] Custom AVERAGE/MEAN function
-
- [Solved] Convert time of a cell entry to a fix number
by Kryonox » Tue Feb 12, 2019 10:13 pm - 4 Replies
- 140 Views
- Last post by Kryonox
Thu Feb 14, 2019 3:50 pm
- [Solved] Convert time of a cell entry to a fix number
-
- Calc, Basic Macros and ISBLANK()
by l8gravely » Tue May 08, 2012 9:29 pm
- 16 Replies
- 9899 Views
- Last post by Zizi64
Thu Feb 14, 2019 10:42 am
- Calc, Basic Macros and ISBLANK()
-
- [Solved] Formula Help?
by Mugs444 » Wed Feb 13, 2019 4:57 pm
- 8 Replies
- 197 Views
- Last post by Mugs444
Thu Feb 14, 2019 5:52 am
- [Solved] Formula Help?
-
- Merge two Calc csv files using unique id
by dru_nasty » Tue Feb 12, 2019 4:58 am
- 4 Replies
- 179 Views
- Last post by MrProgrammer
Wed Feb 13, 2019 10:49 pm
- Merge two Calc csv files using unique id
-
- Remove dates from column
by awascholl » Wed Feb 13, 2019 6:53 pm
- 3 Replies
- 113 Views
- Last post by Lupp
Wed Feb 13, 2019 9:52 pm
- Remove dates from column
-
- [Solved] Stuck loading excel sheets
by streaming » Wed Feb 13, 2019 11:14 am - 9 Replies
- 164 Views
- Last post by streaming
Wed Feb 13, 2019 9:29 pm
- [Solved] Stuck loading excel sheets
-
- [Solved] If then statements (now showing error 509)
by lhentz » Tue Feb 12, 2019 7:32 pm - 5 Replies
- 156 Views
- Last post by John_Ha
Wed Feb 13, 2019 1:04 am
- [Solved] If then statements (now showing error 509)
-
- Font size does not survive pdf
by skeeve » Sun Feb 10, 2019 11:45 pm
- 5 Replies
- 187 Views
- Last post by Zizi64
Tue Feb 12, 2019 10:30 pm
- Font size does not survive pdf
-
- [Solved] Concatenate
by THEBookMan » Tue Feb 12, 2019 8:34 pm - 3 Replies
- 98 Views
- Last post by THEBookMan
Tue Feb 12, 2019 8:57 pm
- [Solved] Concatenate
-
- Is this possible to create new ods file in Macro? And write
by arrowman » Tue Feb 12, 2019 3:25 pm - 3 Replies
- 110 Views
- Last post by Zizi64
Tue Feb 12, 2019 4:51 pm
- Is this possible to create new ods file in Macro? And write
-
- [Solved] Variable case for text in a cell in Calc
by MCLow » Wed Feb 06, 2019 11:21 pm - 2 Replies
- 160 Views
- Last post by MCLow
Tue Feb 12, 2019 3:11 am
- [Solved] Variable case for text in a cell in Calc
-
- Return list of delimited text values based on criteria
by chrisboat » Mon Feb 11, 2019 10:07 pm
- 3 Replies
- 127 Views
- Last post by Lupp
Tue Feb 12, 2019 12:29 am
- Return list of delimited text values based on criteria
-
- [Solved] Adding text to the beginning of every cell?
by gcz » Mon Jan 25, 2010 8:19 am - 5 Replies
- 31174 Views
- Last post by wesdunn1977
Mon Feb 11, 2019 9:36 pm
- [Solved] Adding text to the beginning of every cell?
-
- [Solved] Text entry line
by lhentz » Mon Feb 11, 2019 7:33 pm - 2 Replies
- 88 Views
- Last post by lhentz
Mon Feb 11, 2019 7:53 pm
- [Solved] Text entry line
-
- Search and get row possition
by kik94 » Fri Feb 08, 2019 11:32 am
- 2 Replies
- 141 Views
- Last post by kik94
Mon Feb 11, 2019 1:25 pm
- Search and get row possition
-
- [Solved] Extract a number from a text string
by silverb » Fri Mar 11, 2011 2:51 pm
- 25 Replies
- 14654 Views
- Last post by me231
Mon Feb 11, 2019 4:49 am
- [Solved] Extract a number from a text string
-
- [Solved] Convert USA dates to European
by LGN » Sun Feb 10, 2019 6:52 pm
- 3 Replies
- 125 Views
- Last post by LGN
Sun Feb 10, 2019 8:20 pm
- [Solved] Convert USA dates to European
Who is online
Users browsing this forum: No registered users and 13 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
|