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: 31890
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33733
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30631
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 136198 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Select Unique Values and count
by Ganit » Sat Apr 25, 2020 4:33 pm - 1 Replies
- 303 Views
- Last post by MrProgrammer
Sat Apr 25, 2020 6:57 pm
- [Solved] Select Unique Values and count
-
- [Solved] Data Validity on a Date
by bobgilbert » Thu Apr 23, 2020 9:31 pm
- 9 Replies
- 534 Views
- Last post by bobgilbert
Fri Apr 24, 2020 4:39 pm
- [Solved] Data Validity on a Date
-
- [Solved] Increase multiplication by column
by almost317 » Fri Apr 24, 2020 6:36 am - 2 Replies
- 255 Views
- Last post by almost317
Fri Apr 24, 2020 1:00 pm
- [Solved] Increase multiplication by column
-
- Saving a Template
by quarkrad » Thu Apr 23, 2020 3:26 pm - 5 Replies
- 384 Views
- Last post by John_Ha
Fri Apr 24, 2020 10:28 am
- Saving a Template
-
- Spreadsheet crashed and won't recover
by PEZASN » Fri Apr 24, 2020 8:48 am
- 3 Replies
- 299 Views
- Last post by robleyd
Fri Apr 24, 2020 9:55 am
- Spreadsheet crashed and won't recover
-
- Automatically add to cell values
by adamberkey » Thu Apr 23, 2020 5:25 am
- 6 Replies
- 475 Views
- Last post by adamberkey
Fri Apr 24, 2020 5:33 am
- Automatically add to cell values
-
- Inserting specific data from URL to Calc?
by roboticfood » Mon Apr 20, 2020 12:12 am
- 4 Replies
- 408 Views
- Last post by roboticfood
Fri Apr 24, 2020 3:37 am
- Inserting specific data from URL to Calc?
-
- [Solved] Match then color background
by howtha » Thu Apr 23, 2020 3:51 pm - 2 Replies
- 279 Views
- Last post by howtha
Thu Apr 23, 2020 7:06 pm
- [Solved] Match then color background
-
- [Solved] Help with macro/formula
by marco169 » Thu Apr 23, 2020 4:27 pm - 5 Replies
- 389 Views
- Last post by marco169
Thu Apr 23, 2020 5:38 pm
- [Solved] Help with macro/formula
-
- Form elements occasionally "getting out of shape"
by 3+4i » Tue Apr 21, 2020 5:59 pm
- 9 Replies
- 488 Views
- Last post by 3+4i
Thu Apr 23, 2020 12:39 pm
- Form elements occasionally "getting out of shape"
-
- Printing landscape in calc
by Blisk » Thu Apr 23, 2020 9:51 am
- 3 Replies
- 248 Views
- Last post by Zizi64
Thu Apr 23, 2020 11:08 am
- Printing landscape in calc
-
- [Solved] Concatenating using number formats
by AWoodShed » Wed Apr 22, 2020 2:35 am
- 5 Replies
- 420 Views
- Last post by Lupp
Thu Apr 23, 2020 1:09 am
- [Solved] Concatenating using number formats
-
- [Solved] Expand selection with keyboard
by dentopolis » Wed Apr 22, 2020 8:07 pm - 2 Replies
- 241 Views
- Last post by Zizi64
Wed Apr 22, 2020 10:14 pm
- [Solved] Expand selection with keyboard
-
- Bad/Corrupt/Incompatible File after computer froze
by Deano » Mon Apr 20, 2020 10:46 pm
- 2 Replies
- 276 Views
- Last post by robleyd
Tue Apr 21, 2020 9:16 am
- Bad/Corrupt/Incompatible File after computer froze
-
- [Solved] IF ... THEN Macro in CALC
by marco169 » Mon Apr 20, 2020 5:30 pm - 3 Replies
- 366 Views
- Last post by marco169
Tue Apr 21, 2020 7:32 am
- [Solved] IF ... THEN Macro in CALC
-
- [Solved] Using the find function
by nova » Mon Apr 20, 2020 9:55 am
- 10 Replies
- 493 Views
- Last post by Villeroy
Mon Apr 20, 2020 11:44 pm
- [Solved] Using the find function
-
- Cell automatically changes lowercase "c" to uppercase
by roddy » Mon Apr 20, 2020 5:45 am
- 18 Replies
- 479 Views
- Last post by roddy
Mon Apr 20, 2020 11:10 pm
- Cell automatically changes lowercase "c" to uppercase
-
- [Solved] Changing Color of n Fields
by Kapa150 » Sun Apr 19, 2020 1:50 pm
- 18 Replies
- 816 Views
- Last post by Lupp
Mon Apr 20, 2020 3:25 pm
- [Solved] Changing Color of n Fields
-
- Borders right and bottom
by jucala » Mon Apr 20, 2020 10:50 am
- 2 Replies
- 194 Views
- Last post by Zizi64
Mon Apr 20, 2020 11:06 am
- Borders right and bottom
-
- [Solved] Apply white background, no visible grid
by jucala » Fri Oct 25, 2019 5:26 pm
- 7 Replies
- 593 Views
- Last post by jucala
Mon Apr 20, 2020 10:44 am
- [Solved] Apply white background, no visible grid
-
- [Solved] Untitled 1 in OpenOffice.org Calc is corrupted
by miranda » Sat Jun 25, 2011 3:37 pm - 3 Replies
- 1697 Views
- Last post by Mike Ayling
Mon Apr 20, 2020 9:22 am
- [Solved] Untitled 1 in OpenOffice.org Calc is corrupted
-
- [Solved] CSV-Export - cannot Edit filter options
by tosho » Mon Nov 01, 2010 8:29 pm - 5 Replies
- 3980 Views
- Last post by jesanabriah
Mon Apr 20, 2020 8:30 am
- [Solved] CSV-Export - cannot Edit filter options
-
- How to Create Dependent Drop Down List - Newbie Q
by bcaldwellmusic » Sun Apr 19, 2020 4:17 pm - 4 Replies
- 315 Views
- Last post by Lupp
Sun Apr 19, 2020 8:59 pm
- How to Create Dependent Drop Down List - Newbie Q
-
- Custom sort needed
by drslim212 » Sun Apr 19, 2020 8:11 pm
- 2 Replies
- 208 Views
- Last post by Villeroy
Sun Apr 19, 2020 8:35 pm
- Custom sort needed
-
- [Solved] Pivot Table... ish...
by TheNamelessPoet » Sat Apr 18, 2020 3:47 pm
- 4 Replies
- 353 Views
- Last post by Villeroy
Sun Apr 19, 2020 12:19 pm
- [Solved] Pivot Table... ish...
-
- Andropen office charts
by Arro » Sat Apr 18, 2020 10:03 am
- 8 Replies
- 582 Views
- Last post by Villeroy
Sun Apr 19, 2020 9:16 am
- Andropen office charts
-
- [Solved] Remove any instances of "(integer)" from a cell
by cul » Sun Apr 19, 2020 4:34 am - 4 Replies
- 319 Views
- Last post by cul
Sun Apr 19, 2020 8:32 am
- [Solved] Remove any instances of "(integer)" from a cell
-
- [Solved] Percentage of Change
by Padeen » Sat Apr 18, 2020 11:34 pm - 2 Replies
- 246 Views
- Last post by Padeen
Sun Apr 19, 2020 5:52 am
- [Solved] Percentage of Change
-
- [Solved] Get numbers from a mixed string
by Hellopaul » Sat Apr 18, 2020 4:47 pm - 6 Replies
- 332 Views
- Last post by Hellopaul
Sat Apr 18, 2020 7:55 pm
- [Solved] Get numbers from a mixed string
-
- Formula to access merged cells as if they're not merged
by Hellopaul » Sat Apr 18, 2020 3:35 pm
- 3 Replies
- 266 Views
- Last post by Hellopaul
Sat Apr 18, 2020 7:52 pm
- Formula to access merged cells as if they're not merged
-
- [Solved] Strip non-URL characters from text
by Hellopaul » Sat Apr 18, 2020 2:45 pm - 6 Replies
- 289 Views
- Last post by Hellopaul
Sat Apr 18, 2020 5:20 pm
- [Solved] Strip non-URL characters from text
-
- [Solved] Conditional Format for Highest Lowest
by neil-uk » Wed Apr 01, 2020 1:21 pm
- 11 Replies
- 591 Views
- Last post by robleyd
Sat Apr 18, 2020 2:25 am
- [Solved] Conditional Format for Highest Lowest
-
- Clickable link inserted instead of image
by crunchie » Fri Apr 17, 2020 6:28 pm
- 2 Replies
- 199 Views
- Last post by RoryOF
Fri Apr 17, 2020 7:55 pm
- Clickable link inserted instead of image
-
- Multiple tabs in a workbook ONLY the 1st one will print
by martysgcal » Fri Apr 17, 2020 6:29 pm - 1 Replies
- 178 Views
- Last post by Zizi64
Fri Apr 17, 2020 7:45 pm
- Multiple tabs in a workbook ONLY the 1st one will print
-
- COUNTIF and external documents
by imtonyr » Fri Apr 17, 2020 5:47 pm - 2 Replies
- 239 Views
- Last post by Zizi64
Fri Apr 17, 2020 5:58 pm
- COUNTIF and external documents
-
- [Solved] Assign X-axis labels in column or line graphs
by ronanski » Fri Apr 17, 2020 1:54 pm - 4 Replies
- 262 Views
- Last post by Zizi64
Fri Apr 17, 2020 5:38 pm
- [Solved] Assign X-axis labels in column or line graphs
-
- How do I add a row when the data changes in LibreOffice Calc
by Pankaj2006 » Thu Apr 16, 2020 4:44 pm
- 11 Replies
- 507 Views
- Last post by Villeroy
Fri Apr 17, 2020 2:58 pm
- How do I add a row when the data changes in LibreOffice Calc
-
- [Solved] Fiscal Year Week Number Formula
by apallo » Thu Apr 16, 2020 7:19 am
- 3 Replies
- 344 Views
- Last post by apallo
Fri Apr 17, 2020 3:35 am
- [Solved] Fiscal Year Week Number Formula
-
- [Solved] Offpage scrolling crashes the program
by mogur » Wed Apr 15, 2020 9:58 pm - 6 Replies
- 443 Views
- Last post by mogur
Thu Apr 16, 2020 10:28 pm
- [Solved] Offpage scrolling crashes the program
-
- [Solved] View all sheets in workbook
by rbc » Sun Apr 12, 2020 7:22 pm - 4 Replies
- 339 Views
- Last post by rbc
Thu Apr 16, 2020 9:56 pm
- [Solved] View all sheets in workbook
-
- Year & week number
by cul » Thu Apr 16, 2020 9:41 am - 11 Replies
- 419 Views
- Last post by Villeroy
Thu Apr 16, 2020 8:17 pm
- Year & week number
-
- [Solved] Estimate differentials with exponential function
by zap » Tue Apr 14, 2020 12:21 am
- 4 Replies
- 347 Views
- Last post by Lupp
Thu Apr 16, 2020 7:50 pm
- [Solved] Estimate differentials with exponential function
-
- Vlookup not working where numbers are a mixed format
by deutscheparts » Thu Apr 16, 2020 11:08 am
- 6 Replies
- 366 Views
- Last post by Villeroy
Thu Apr 16, 2020 4:44 pm
- Vlookup not working where numbers are a mixed format
-
- [Solved] Right to left sheet
by flyingfalafel » Tue Apr 14, 2020 8:39 am - 2 Replies
- 245 Views
- Last post by flyingfalafel
Thu Apr 16, 2020 9:17 am
- [Solved] Right to left sheet
-
- Live table extraction
by JLeite » Thu Apr 16, 2020 2:32 am - 1 Replies
- 227 Views
- Last post by robleyd
Thu Apr 16, 2020 2:54 am
- Live table extraction
-
- [Solved] Portrait/Landscape layouts in Calc
by xyzsail » Wed Apr 15, 2020 9:28 pm - 4 Replies
- 279 Views
- Last post by xyzsail
Thu Apr 16, 2020 12:43 am
- [Solved] Portrait/Landscape layouts in Calc
-
- [Issue] External workbook reference (Err:504)
by navimils » Tue Apr 14, 2020 12:35 pm
- 4 Replies
- 321 Views
- Last post by Villeroy
Tue Apr 14, 2020 5:55 pm
- [Issue] External workbook reference (Err:504)
-
- [Solved] Effective printing
by MDK » Mon Apr 13, 2020 3:47 am - 5 Replies
- 341 Views
- Last post by MDK
Mon Apr 13, 2020 4:47 pm
- [Solved] Effective printing
-
- Wanting to find the last non-empty cell in a column
by roddy » Sun Apr 12, 2020 12:09 pm
- 8 Replies
- 623 Views
- Last post by roddy
Mon Apr 13, 2020 12:24 am
- Wanting to find the last non-empty cell in a column
-
- Insert specific number of rows or columns in Calc
by roddy » Sun Apr 12, 2020 2:24 am - 3 Replies
- 279 Views
- Last post by Villeroy
Sun Apr 12, 2020 7:04 pm
- Insert specific number of rows or columns in Calc
Who is online
Users browsing this forum: calculateur and 19 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
|