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: 28538
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30123
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26709
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 9391 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] IF, Between, Less Than, Then Add ...
by quarkrad » Tue Apr 09, 2019 5:42 pm
- 4 Replies
- 225 Views
- Last post by quarkrad
Tue Apr 09, 2019 7:33 pm
- [Solved] IF, Between, Less Than, Then Add ...
-
- [Solved] Compare 3 columns values
by campanico » Mon Apr 08, 2019 4:13 pm
- 2 Replies
- 193 Views
- Last post by campanico
Tue Apr 09, 2019 5:15 pm
- [Solved] Compare 3 columns values
-
- Best Formula?
by quarkrad » Mon Apr 08, 2019 9:54 am
- 2 Replies
- 202 Views
- Last post by quarkrad
Tue Apr 09, 2019 8:54 am
- Best Formula?
-
- [Solved] Is it possible to show diffrent droplists in a cell
by Fredrik Nilsson » Sat Apr 06, 2019 4:13 pm
- 3 Replies
- 234 Views
- Last post by Fredrik Nilsson
Mon Apr 08, 2019 10:56 pm
- [Solved] Is it possible to show diffrent droplists in a cell
-
- [Solved] Workdays
by RusselB » Mon Apr 08, 2019 3:38 pm - 2 Replies
- 157 Views
- Last post by RusselB
Mon Apr 08, 2019 6:35 pm
- [Solved] Workdays
-
- [Solved] Search and Replace Text
by Moon Lit Nights » Mon Apr 08, 2019 4:16 pm - 2 Replies
- 158 Views
- Last post by Moon Lit Nights
Mon Apr 08, 2019 4:41 pm
- [Solved] Search and Replace Text
-
- [bug?] Editing/adjusting Calc's default data entry form
by ind » Tue Apr 02, 2019 8:06 pm
- 18 Replies
- 554 Views
- Last post by ind
Mon Apr 08, 2019 3:57 pm
- [bug?] Editing/adjusting Calc's default data entry form
-
- [Solved] How to turn off spellcheck (or capitalization)?
by Jeff Root » Sun Apr 07, 2019 12:20 pm - 5 Replies
- 249 Views
- Last post by Jeff Root
Mon Apr 08, 2019 6:16 am
- [Solved] How to turn off spellcheck (or capitalization)?
-
- Sum data from multiple spreadsheets
by bbeard » Sat Apr 06, 2019 6:21 pm
- 6 Replies
- 273 Views
- Last post by keme
Mon Apr 08, 2019 3:54 am
- Sum data from multiple spreadsheets
-
- Spreadsheet for storage of financial .csv data from the web
by nycpaulll » Sun Apr 07, 2019 10:15 pm - 2 Replies
- 158 Views
- Last post by FJCC
Mon Apr 08, 2019 3:06 am
- Spreadsheet for storage of financial .csv data from the web
-
- [Solved] Search and replace part of string with increment
by Fredrik Nilsson » Fri Mar 29, 2019 11:01 am
- 10 Replies
- 524 Views
- Last post by MrProgrammer
Sat Apr 06, 2019 4:33 pm
- [Solved] Search and replace part of string with increment
-
- IF for Interrogating cells for timings?
by pherriot » Thu Apr 04, 2019 2:21 pm
- 10 Replies
- 456 Views
- Last post by Villeroy
Sat Apr 06, 2019 3:03 pm
- IF for Interrogating cells for timings?
-
- 3D chart-% data no show outside each segment
by no middle name » Thu Apr 04, 2019 6:24 am
- 5 Replies
- 244 Views
- Last post by Zizi64
Sat Apr 06, 2019 11:14 am
- 3D chart-% data no show outside each segment
-
- Dates are entering as Fractions
1, 2 by walloon » Tue Mar 04, 2014 7:05 pm
- 30 Replies
- 6420 Views
- Last post by RusselB
Sat Apr 06, 2019 2:18 am
- Dates are entering as Fractions
-
- [Solved] Interactive quiz scoreboard
by wayrus » Fri Apr 05, 2019 1:39 pm
- 4 Replies
- 200 Views
- Last post by wayrus
Fri Apr 05, 2019 7:55 pm
- [Solved] Interactive quiz scoreboard
-
- [Solved] Function result "FALSE" Colour required in Calc
by Hp1961 » Fri Apr 05, 2019 6:39 pm - 2 Replies
- 167 Views
- Last post by Hp1961
Fri Apr 05, 2019 7:42 pm
- [Solved] Function result "FALSE" Colour required in Calc
-
- Calc Script/program refresh info from new sheets
by Kee » Mon Apr 01, 2019 4:47 pm - 3 Replies
- 261 Views
- Last post by Villeroy
Fri Apr 05, 2019 5:21 pm
- Calc Script/program refresh info from new sheets
-
- For discussion: Calc formula terms
by MrProgrammer » Thu Apr 04, 2019 7:15 pm - 4 Replies
- 236 Views
- Last post by Villeroy
Fri Apr 05, 2019 12:57 am
- For discussion: Calc formula terms
-
- [Solved] Summing From 2 Sheets Into A 3rd Sheet
by adventurehouse » Thu Apr 04, 2019 5:24 pm - 5 Replies
- 215 Views
- Last post by Villeroy
Thu Apr 04, 2019 10:55 pm
- [Solved] Summing From 2 Sheets Into A 3rd Sheet
-
- [Solved] =IF ISBLANK IF ISTEXT IF < "08:00" /2
by pherriot » Mon Apr 01, 2019 9:32 am - 2 Replies
- 219 Views
- Last post by pherriot
Thu Apr 04, 2019 2:58 pm
- [Solved] =IF ISBLANK IF ISTEXT IF < "08:00" /2
-
- [Solved] Rank according to style
by campanico » Thu Jun 30, 2016 12:25 pm
- 8 Replies
- 554 Views
- Last post by campanico
Wed Apr 03, 2019 5:42 pm
- [Solved] Rank according to style
-
- IF - ISBLANK - ISTEXT - A1 and A2 less than 08:00 then calc
by pherriot » Tue Apr 02, 2019 1:17 pm
- 4 Replies
- 270 Views
- Last post by pherriot
Wed Apr 03, 2019 9:05 am
- IF - ISBLANK - ISTEXT - A1 and A2 less than 08:00 then calc
-
- Not sure if my problem is complex, seeking conceptual help
by nichol88 » Tue Apr 02, 2019 11:32 am
- 3 Replies
- 182 Views
- Last post by jrkrideau
Tue Apr 02, 2019 2:08 pm
- Not sure if my problem is complex, seeking conceptual help
-
- Old user with new issue!!
by bgt » Tue Apr 02, 2019 6:06 am - 1 Replies
- 155 Views
- Last post by Hagar Delest
Tue Apr 02, 2019 8:08 am
- Old user with new issue!!
-
- Can your Calc file be hacked if it queries urls?
by snowman123 » Mon Mar 18, 2019 5:43 am - 10 Replies
- 845 Views
- Last post by keme
Tue Apr 02, 2019 1:22 am
- Can your Calc file be hacked if it queries urls?
-
- [SOLVED] Updating Spreadsheet does not update Database Table
by NorfolkGreg » Mon Mar 25, 2019 3:24 am - 7 Replies
- 508 Views
- Last post by NorfolkGreg
Mon Apr 01, 2019 11:46 pm
- [SOLVED] Updating Spreadsheet does not update Database Table
-
- [Solved] Label Making
by sebagostrider » Thu Mar 28, 2019 10:45 pm
- 3 Replies
- 222 Views
- Last post by sebagostrider
Mon Apr 01, 2019 8:07 pm
- [Solved] Label Making
-
- #NAME? error
by no middle name » Sun Mar 31, 2019 6:43 pm
- 12 Replies
- 432 Views
- Last post by RoryOF
Mon Apr 01, 2019 2:53 pm
- #NAME? error
-
- Dependent Drop-Down Lists
by MrHaz » Fri Mar 29, 2019 9:35 am
- 6 Replies
- 315 Views
- Last post by MrHaz
Sun Mar 31, 2019 2:49 am
- Dependent Drop-Down Lists
-
- MicroSoft aggression conspiracy?
by jkjambsj » Fri Mar 29, 2019 8:49 am - 3 Replies
- 259 Views
- Last post by keme
Sat Mar 30, 2019 11:15 am
- MicroSoft aggression conspiracy?
-
- [Solved] Date format in Calc
by somp » Mon Mar 11, 2019 12:38 pm - 15 Replies
- 937 Views
- Last post by UnklDonald418
Sat Mar 30, 2019 6:19 am
- [Solved] Date format in Calc
-
- [Solved] Convert text to date
by garfld » Fri Mar 29, 2019 6:23 pm
- 2 Replies
- 235 Views
- Last post by garfld
Fri Mar 29, 2019 7:36 pm
- [Solved] Convert text to date
-
- Need help with expanding my calc ability for my business
by alan@ohssresults.com » Fri Mar 29, 2019 12:53 pm - 1 Replies
- 183 Views
- Last post by John_Ha
Fri Mar 29, 2019 1:20 pm
- Need help with expanding my calc ability for my business
-
- [Solved] Downloaded account info not useable
by DandZS » Fri Mar 29, 2019 2:59 am - 1 Replies
- 151 Views
- Last post by RusselB
Fri Mar 29, 2019 5:05 am
- [Solved] Downloaded account info not useable
-
- DDE Links on Linux using Wine external application
by Tarkovsky » Fri Mar 29, 2019 3:20 am - 0 Replies
- 160 Views
- Last post by Tarkovsky
Fri Mar 29, 2019 3:20 am
- DDE Links on Linux using Wine external application
-
- [Solved] References to other cells work on some sheets
by pherriot » Thu Mar 28, 2019 4:44 pm
- 3 Replies
- 180 Views
- Last post by pherriot
Thu Mar 28, 2019 6:52 pm
- [Solved] References to other cells work on some sheets
-
- Beginner questions
by weygtya » Wed Mar 27, 2019 6:01 pm
- 10 Replies
- 351 Views
- Last post by MrProgrammer
Thu Mar 28, 2019 5:16 pm
- Beginner questions
-
- [Solved] Grouping (hide/show) columns in a pivot table
by pbschmidt » Thu Mar 28, 2019 4:22 pm - 1 Replies
- 134 Views
- Last post by pbschmidt
Thu Mar 28, 2019 4:39 pm
- [Solved] Grouping (hide/show) columns in a pivot table
-
- [Solved] =IF ISBLANK and if not ISTEXT and if not::
by pherriot » Wed Mar 27, 2019 8:26 pm
- 5 Replies
- 224 Views
- Last post by pherriot
Thu Mar 28, 2019 3:20 pm
- [Solved] =IF ISBLANK and if not ISTEXT and if not::
-
- Creating a chart for Yes/No answers
by rabidmiacid » Wed Mar 27, 2019 9:43 pm
- 4 Replies
- 271 Views
- Last post by Villeroy
Wed Mar 27, 2019 11:24 pm
- Creating a chart for Yes/No answers
-
- [Solved] IF ISBLANK with time increments
by pherriot » Wed Mar 27, 2019 1:26 pm
- 2 Replies
- 165 Views
- Last post by pherriot
Wed Mar 27, 2019 5:39 pm
- [Solved] IF ISBLANK with time increments
-
- Currency zero values are missing
by camo » Tue Mar 26, 2019 1:19 pm
- 9 Replies
- 261 Views
- Last post by Villeroy
Wed Mar 27, 2019 2:20 pm
- Currency zero values are missing
-
- Cannot update mysql Database from spreadsheet
by weyestudio » Tue Mar 26, 2019 5:34 am
- 4 Replies
- 183 Views
- Last post by Villeroy
Tue Mar 26, 2019 4:16 pm
- Cannot update mysql Database from spreadsheet
-
- [Solved] ODS Can't be written
by THEBookMan » Mon Jun 11, 2018 5:35 pm - 6 Replies
- 588 Views
- Last post by John_Ha
Tue Mar 26, 2019 1:36 pm
- [Solved] ODS Can't be written
-
- Protect spreadsheets from piracy
by krabban » Mon Mar 25, 2019 1:51 pm - 3 Replies
- 185 Views
- Last post by krabban
Tue Mar 26, 2019 9:40 am
- Protect spreadsheets from piracy
-
- Isolate entry on a drop down
by wildwildcoast » Tue Mar 26, 2019 6:24 am - 0 Replies
- 112 Views
- Last post by wildwildcoast
Tue Mar 26, 2019 6:24 am
- Isolate entry on a drop down
-
- [Solved] Average a column but ignore cells with zero
by manntis » Tue Mar 26, 2019 1:14 am - 3 Replies
- 148 Views
- Last post by robleyd
Tue Mar 26, 2019 3:33 am
- [Solved] Average a column but ignore cells with zero
-
- [Solved] Cell border frustrations
by manntis » Mon Mar 25, 2019 9:04 pm
- 7 Replies
- 192 Views
- Last post by manntis
Tue Mar 26, 2019 1:07 am
- [Solved] Cell border frustrations
-
- Format Error in Sub-Document content.xml
by Faraway » Mon Mar 25, 2019 2:50 am
- 6 Replies
- 212 Views
- Last post by Faraway
Mon Mar 25, 2019 10:55 pm
- Format Error in Sub-Document content.xml
-
- [Solved] Help with formula in spreadsheet
by krabban » Fri Mar 22, 2019 4:08 pm
- 12 Replies
- 512 Views
- Last post by krabban
Mon Mar 25, 2019 3:03 pm
- [Solved] Help with formula in spreadsheet
Who is online
Users browsing this forum: dawidek990, Zizi64 and 20 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
|