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: 34796
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 36795
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 33743
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 11455 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Get the SUM of the same cell in multiple sheets
by iso_man » Tue Dec 08, 2020 5:18 pm - 2 Replies
- 255 Views
- Last post by iso_man
Wed Dec 09, 2020 12:25 pm
- [Solved] Get the SUM of the same cell in multiple sheets
-
- Subtract duplicate subset list from a master list
by dga1965 » Wed Dec 09, 2020 1:46 am - 1 Replies
- 142 Views
- Last post by Villeroy
Wed Dec 09, 2020 2:50 am
- Subtract duplicate subset list from a master list
-
- Locale and language settings confuse DD/MM date input
by AylaAsperger » Sat Dec 05, 2020 8:22 pm - 18 Replies
- 500 Views
- Last post by robleyd
Wed Dec 09, 2020 12:06 am
- Locale and language settings confuse DD/MM date input
-
- [SOLVED] Show nothing if source for formula is empty
by ChrisMacCo » Tue Dec 08, 2020 12:34 am - 8 Replies
- 279 Views
- Last post by RusselB
Tue Dec 08, 2020 6:25 am
- [SOLVED] Show nothing if source for formula is empty
-
- [Solved] Preserve leading zero in postal code
by Emilio » Mon Dec 07, 2020 6:16 pm
- 2 Replies
- 208 Views
- Last post by MrProgrammer
Mon Dec 07, 2020 6:34 pm
- [Solved] Preserve leading zero in postal code
-
- [Solved] Hyperlink in formula with CONCATENATE()
by Bambamn » Mon Dec 07, 2020 12:56 am - 2 Replies
- 173 Views
- Last post by Bambamn
Mon Dec 07, 2020 1:08 am
- [Solved] Hyperlink in formula with CONCATENATE()
-
- [Solved] Conditional formatting based on another cell value
by manosdet » Sun Dec 06, 2020 8:11 pm
- 2 Replies
- 218 Views
- Last post by manosdet
Sun Dec 06, 2020 9:47 pm
- [Solved] Conditional formatting based on another cell value
-
- Current cell always locked scrolling
by walls » Sun Mar 22, 2020 8:01 pm - 4 Replies
- 520 Views
- Last post by Phillip
Sun Dec 06, 2020 7:52 pm
- Current cell always locked scrolling
-
- [Solved] Misbehaving data validity
by morphingstar » Wed Dec 02, 2020 12:56 am
- 5 Replies
- 304 Views
- Last post by Zizi64
Sun Dec 06, 2020 9:47 am
- [Solved] Misbehaving data validity
-
- Have running total in a cell every time I type ino another
by bob998@comcast.net » Sat Dec 05, 2020 10:16 pm - 2 Replies
- 168 Views
- Last post by robleyd
Sun Dec 06, 2020 12:15 am
- Have running total in a cell every time I type ino another
-
- [Solved] Delete apostrophe before numbers in all cells?
1, 2by Kingrazor » Fri Mar 16, 2012 4:38 am - 32 Replies
- 127901 Views
- Last post by wmbernard@gmx.us
Sat Dec 05, 2020 11:27 pm
- [Solved] Delete apostrophe before numbers in all cells?
-
- [Solved] Delete a row in spreadsheet
by bernieb123 » Fri Dec 04, 2020 8:59 pm - 1 Replies
- 192 Views
- Last post by RoryOF
Fri Dec 04, 2020 9:03 pm
- [Solved] Delete a row in spreadsheet
-
- [Solved] Keep selection in cell after pressing Enter
by CSquared » Thu Dec 03, 2020 7:52 pm
- 2 Replies
- 192 Views
- Last post by MrProgrammer
Thu Dec 03, 2020 10:03 pm
- [Solved] Keep selection in cell after pressing Enter
-
- Unable to open file, shows ASCII Filter Options dialog
by jefflyon6502 » Wed Dec 02, 2020 4:26 pm - 5 Replies
- 259 Views
- Last post by jefflyon6502
Wed Dec 02, 2020 11:10 pm
- Unable to open file, shows ASCII Filter Options dialog
-
- [Solved] Function like UNIQUE() in Google Sheets
by polly » Wed Dec 02, 2020 6:20 pm - 4 Replies
- 229 Views
- Last post by polly
Wed Dec 02, 2020 10:54 pm
- [Solved] Function like UNIQUE() in Google Sheets
-
- [Solved] Return most displayed text from a column range
by johnarthur » Mon Nov 30, 2020 1:06 am
- 1 Replies
- 220 Views
- Last post by MrProgrammer
Wed Dec 02, 2020 5:30 am
- [Solved] Return most displayed text from a column range
-
- [Solved] Line break in function if cell is not empty
by manosdet » Mon Nov 30, 2020 12:05 pm
- 6 Replies
- 207 Views
- Last post by manosdet
Tue Dec 01, 2020 4:53 pm
- [Solved] Line break in function if cell is not empty
-
- [Solved] What Can I Hide?
by Bloodknot » Mon Nov 30, 2020 4:04 pm - 5 Replies
- 290 Views
- Last post by Bloodknot
Tue Dec 01, 2020 12:10 am
- [Solved] What Can I Hide?
-
- [Solved] Sum a column based on matches in other columns
by cul » Tue Sep 29, 2020 2:08 pm
- 6 Replies
- 840 Views
- Last post by cul
Mon Nov 30, 2020 8:15 am
- [Solved] Sum a column based on matches in other columns
-
- [Solved] Naming tables in Calc 4.1.8
by h8ids » Sun Nov 29, 2020 7:26 pm
- 2 Replies
- 213 Views
- Last post by h8ids
Mon Nov 30, 2020 4:13 am
- [Solved] Naming tables in Calc 4.1.8
-
- [Solved] Format error discovered in the file in sub-document
by nph2011 » Fri Jan 14, 2011 11:21 am
- 21 Replies
- 27195 Views
- Last post by Gangadhar
Sat Nov 28, 2020 6:38 pm
- [Solved] Format error discovered in the file in sub-document
-
- [Solved] Calculate hours in work schedule
by carwena » Thu Nov 12, 2020 10:28 pm
- 10 Replies
- 568 Views
- Last post by carwena
Sat Nov 28, 2020 5:59 pm
- [Solved] Calculate hours in work schedule
-
- [Solved] Extract uppercase words to a different cell
by fiona87 » Wed Nov 25, 2020 6:27 pm
- 4 Replies
- 369 Views
- Last post by lader
Fri Nov 27, 2020 6:07 pm
- [Solved] Extract uppercase words to a different cell
-
- [Solved] Telefon number format
by Emilio » Mon Nov 23, 2020 5:04 pm
- 11 Replies
- 491 Views
- Last post by Emilio
Fri Nov 27, 2020 5:49 pm
- [Solved] Telefon number format
-
- [Solved] Remove blue arrow which hides cell content
by kleajmp » Fri Nov 27, 2020 1:23 am
- 2 Replies
- 186 Views
- Last post by MrProgrammer
Fri Nov 27, 2020 4:47 pm
- [Solved] Remove blue arrow which hides cell content
-
- [Solved] Put border around group of selected cells
by jimbir » Thu Nov 26, 2020 9:22 pm - 1 Replies
- 171 Views
- Last post by RoryOF
Thu Nov 26, 2020 9:30 pm
- [Solved] Put border around group of selected cells
-
- [Solved] #NAME? error in Spreadhsheet
by 06honda » Wed Nov 18, 2020 4:25 pm
- 6 Replies
- 390 Views
- Last post by 06honda
Wed Nov 25, 2020 5:30 pm
- [Solved] #NAME? error in Spreadhsheet
-
- [Solved] MID() parameters change but outcome does not
by jelket » Wed Nov 25, 2020 1:28 pm - 4 Replies
- 239 Views
- Last post by DiGro
Wed Nov 25, 2020 4:01 pm
- [Solved] MID() parameters change but outcome does not
-
- [Solved] How to shift columns up or down
by cjoh11 » Tue Nov 24, 2020 4:00 pm - 3 Replies
- 255 Views
- Last post by Villeroy
Tue Nov 24, 2020 6:21 pm
- [Solved] How to shift columns up or down
-
- Font is changed when pasting into Calc
by porttownsend119 » Tue Nov 24, 2020 1:03 am - 0 Replies
- 187 Views
- Last post by porttownsend119
Tue Nov 24, 2020 1:03 am
- Font is changed when pasting into Calc
-
- [Solved] Writer (an archaic version) Date problem
by Hrodlanson » Mon Nov 23, 2020 7:23 pm - 3 Replies
- 247 Views
- Last post by Villeroy
Mon Nov 23, 2020 10:10 pm
- [Solved] Writer (an archaic version) Date problem
-
- [Solved] Want to split data, multiple rows
by drp_61 » Sun Nov 22, 2020 10:18 am - 3 Replies
- 297 Views
- Last post by drp_61
Mon Nov 23, 2020 10:30 am
- [Solved] Want to split data, multiple rows
-
- Calc crashes every time I use "Find"
by manoman » Sun Nov 22, 2020 3:44 am
- 3 Replies
- 229 Views
- Last post by RoryOF
Sun Nov 22, 2020 5:31 pm
- Calc crashes every time I use "Find"
-
- [Solved] Want to split data
by drp_61 » Sun Nov 22, 2020 6:41 am
- 1 Replies
- 246 Views
- Last post by robleyd
Sun Nov 22, 2020 6:57 am
- [Solved] Want to split data
-
- How to specify x axis
by ronhud » Sat Nov 21, 2020 2:16 pm - 5 Replies
- 242 Views
- Last post by Villeroy
Sat Nov 21, 2020 7:41 pm
- How to specify x axis
-
- Corrupted file - having issues
by mistahjoe » Sat Nov 21, 2020 6:17 pm
- 1 Replies
- 179 Views
- Last post by RusselB
Sat Nov 21, 2020 6:27 pm
- Corrupted file - having issues
-
- Newer version message when opening Calc document
by officevortex » Sat Nov 21, 2020 12:07 am - 1 Replies
- 177 Views
- Last post by robleyd
Sat Nov 21, 2020 1:16 am
- Newer version message when opening Calc document
-
- [Solved] Multiplying columns
by Nitrocowboy » Mon Jan 12, 2009 5:15 am - 5 Replies
- 18284 Views
- Last post by universe
Sat Nov 21, 2020 1:14 am
- [Solved] Multiplying columns
-
- [Solved] Calc is not exporting whole document to PDF
by officevortex » Sat Nov 21, 2020 12:28 am - 0 Replies
- 142 Views
- Last post by officevortex
Sat Nov 21, 2020 12:28 am
- [Solved] Calc is not exporting whole document to PDF
-
- Format Cell as Date - LibreOffice
by Alex in Grimsby » Fri Nov 20, 2020 1:53 pm - 11 Replies
- 359 Views
- Last post by Villeroy
Fri Nov 20, 2020 10:35 pm
- Format Cell as Date - LibreOffice
-
- [Solved] Count cells (COUNTIF?) containing the word «and»
by 73and6man » Fri Nov 20, 2020 1:12 pm - 7 Replies
- 254 Views
- Last post by 73and6man
Fri Nov 20, 2020 9:27 pm
- [Solved] Count cells (COUNTIF?) containing the word «and»
-
- Show Bitcoin price "at the time"
by snowman123 » Sat Dec 16, 2017 10:26 pm
- 11 Replies
- 5251 Views
- Last post by pjmcclore
Fri Nov 20, 2020 6:28 pm
- Show Bitcoin price "at the time"
-
- Lost the handy tools window at right side of calc pages
by oldnavyabm@yahoo.com » Fri Nov 20, 2020 3:04 pm - 1 Replies
- 144 Views
- Last post by RoryOF
Fri Nov 20, 2020 3:19 pm
- Lost the handy tools window at right side of calc pages
-
- [Solved] Stop cursor moving down to next cell
by Jude58c » Fri Nov 20, 2020 2:38 pm - 2 Replies
- 167 Views
- Last post by Jude58c
Fri Nov 20, 2020 3:16 pm
- [Solved] Stop cursor moving down to next cell
-
- [Solved] Compare a single cell to a group of cells?
by Acidello » Thu Nov 19, 2020 1:19 am - 2 Replies
- 263 Views
- Last post by Acidello
Thu Nov 19, 2020 7:42 pm
- [Solved] Compare a single cell to a group of cells?
-
- [Solved] Beginner questions
by weygtya » Wed Mar 27, 2019 6:01 pm
- 16 Replies
- 903 Views
- Last post by weygtya
Wed Nov 18, 2020 5:25 pm
- [Solved] Beginner questions
-
- [Solved] Listbox text alignment
by Bloodknot » Sun Nov 15, 2020 6:28 pm
- 3 Replies
- 213 Views
- Last post by Bloodknot
Wed Nov 18, 2020 12:47 pm
- [Solved] Listbox text alignment
-
- [SOLVED] Create Pivot Table
by sf_of » Tue Nov 10, 2020 7:53 am
- 6 Replies
- 375 Views
- Last post by Villeroy
Wed Nov 18, 2020 12:10 pm
- [SOLVED] Create Pivot Table
-
- Set value in D based on value in A (1,2,3,…)
by onlyjohn » Tue Nov 17, 2020 2:34 pm - 1 Replies
- 174 Views
- Last post by FJCC
Tue Nov 17, 2020 4:55 pm
- Set value in D based on value in A (1,2,3,…)
-
- [Solved] Find rows with same prefix (different suffix)
by raykt » Fri Nov 13, 2020 4:51 pm
- 3 Replies
- 265 Views
- Last post by MrProgrammer
Mon Nov 16, 2020 7:34 pm
- [Solved] Find rows with same prefix (different suffix)
Who is online
Users browsing this forum: andersmart, Villeroy and 30 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
|