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: 27977
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 29469
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26064
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 80394 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved)] IF() Formula
by bulsimike » Sat Apr 20, 2019 9:45 am
- 16 Replies
- 418 Views
- Last post by bulsimike
Sat Apr 20, 2019 12:49 pm
- [Solved)] IF() Formula
-
- [Solved] AutoFill and custom sort list
by jjon » Fri Apr 19, 2019 11:53 pm - 3 Replies
- 189 Views
- Last post by FJCC
Sat Apr 20, 2019 2:18 am
- [Solved] AutoFill and custom sort list
-
- Spreadsheet Headings
by Leveraa » Fri Apr 19, 2019 11:23 pm - 1 Replies
- 174 Views
- Last post by Leveraa
Fri Apr 19, 2019 11:32 pm
- Spreadsheet Headings
-
- [Solved] Operation on group
by Carter7Gindenv » Thu Apr 18, 2019 11:32 am
- 5 Replies
- 317 Views
- Last post by Villeroy
Fri Apr 19, 2019 12:14 pm
- [Solved] Operation on group
-
- Auto-filter for non-empty and containing string
by DynV » Thu Apr 18, 2019 10:45 pm - 2 Replies
- 168 Views
- Last post by RusselB
Fri Apr 19, 2019 2:51 am
- Auto-filter for non-empty and containing string
-
- [Solved] SUMs from multiple sheets filtered by category
by yoyopoc » Wed Apr 17, 2019 1:21 pm - 4 Replies
- 233 Views
- Last post by yoyopoc
Thu Apr 18, 2019 12:49 pm
- [Solved] SUMs from multiple sheets filtered by category
-
- [Solved] Forms: Bug or Feature?
by AndresSolar » Tue Apr 09, 2019 8:28 pm
- 13 Replies
- 498 Views
- Last post by AndresSolar
Thu Apr 18, 2019 3:28 am
- [Solved] Forms: Bug or Feature?
-
- [Solved] Are there limitations on chart locations?
by IsabelDalhousie » Wed Apr 17, 2019 1:14 am - 4 Replies
- 261 Views
- Last post by IsabelDalhousie
Thu Apr 18, 2019 12:40 am
- [Solved] Are there limitations on chart locations?
-
- Flash fill
by lebyarules » Wed Apr 17, 2019 6:01 pm - 2 Replies
- 242 Views
- Last post by RusselB
Wed Apr 17, 2019 11:00 pm
- Flash fill
-
- [Solved] Is it possible to remove "empty" rows in drop list?
by Fredrik Nilsson » Thu Apr 11, 2019 1:56 pm
- 3 Replies
- 243 Views
- Last post by Fredrik Nilsson
Wed Apr 17, 2019 7:38 pm
- [Solved] Is it possible to remove "empty" rows in drop list?
-
- [Solved] Adding data to existing CSV document
by bobbert » Tue Apr 16, 2019 4:57 pm - 3 Replies
- 207 Views
- Last post by bobbert
Wed Apr 17, 2019 5:17 pm
- [Solved] Adding data to existing CSV document
-
- [Solved] Origin of a Hyperlink within Calc
by wfjones1572 » Wed Apr 17, 2019 1:06 am - 4 Replies
- 199 Views
- Last post by Lupp
Wed Apr 17, 2019 3:12 pm
- [Solved] Origin of a Hyperlink within Calc
-
- [Solved] Confine Selected to One Page
by AOOUzr007 » Wed Apr 03, 2019 4:28 am
- 4 Replies
- 276 Views
- Last post by AOOUzr007
Wed Apr 17, 2019 5:42 am
- [Solved] Confine Selected to One Page
-
- [Solved] Charts on New Sheet & Printing Charts
by 2CV67oo » Mon Nov 14, 2011 12:46 pm - 1 Replies
- 13746 Views
- Last post by IsabelDalhousie
Wed Apr 17, 2019 2:16 am
- [Solved] Charts on New Sheet & Printing Charts
-
- UK VAT making tax digital API
by Lupin » Tue Apr 16, 2019 10:41 am - 4 Replies
- 287 Views
- Last post by keme
Tue Apr 16, 2019 1:53 pm
- UK VAT making tax digital API
-
- [Solved] Bugs with the dialog box "updating external links"
by Taren » Sun Apr 14, 2019 9:31 pm - 7 Replies
- 260 Views
- Last post by Villeroy
Tue Apr 16, 2019 1:09 pm
- [Solved] Bugs with the dialog box "updating external links"
-
- [Solved] SUM IF with a date
by MCR » Fri Apr 12, 2019 11:18 pm
- 11 Replies
- 388 Views
- Last post by Lupp
Mon Apr 15, 2019 11:53 pm
- [Solved] SUM IF with a date
-
- [Solved] Formula Showing #NAME as result
by Nageswar992 » Mon Apr 15, 2019 7:12 am - 4 Replies
- 230 Views
- Last post by Lupp
Mon Apr 15, 2019 5:09 pm
- [Solved] Formula Showing #NAME as result
-
- How to extract text and append it to another cell?
by xuzo » Mon Apr 15, 2019 4:28 am - 7 Replies
- 257 Views
- Last post by Lupp
Mon Apr 15, 2019 4:55 pm
- How to extract text and append it to another cell?
-
- Can Cell content will displayed in comment box
by chandrankrishnan » Thu Apr 11, 2019 9:24 am
- 2 Replies
- 180 Views
- Last post by chandrankrishnan
Mon Apr 15, 2019 1:39 pm
- Can Cell content will displayed in comment box
-
- Create multiple IF function criteria-error
by no middle name » Sun Apr 14, 2019 3:23 pm - 1 Replies
- 178 Views
- Last post by MrProgrammer
Sun Apr 14, 2019 3:51 pm
- Create multiple IF function criteria-error
-
- Can't sort range with merged cells
by draker » Fri Apr 22, 2011 9:23 pm
- 20 Replies
- 24379 Views
- Last post by Villeroy
Sun Apr 14, 2019 12:32 pm
- Can't sort range with merged cells
-
- OpenOffice VS Google Sheets, any benefits?
by xuzo » Sun Apr 14, 2019 4:55 am - 1 Replies
- 200 Views
- Last post by erbsenzahl
Sun Apr 14, 2019 10:53 am
- OpenOffice VS Google Sheets, any benefits?
-
- Password protection for multiple files
by sainudeen » Fri Apr 12, 2019 1:38 pm - 4 Replies
- 237 Views
- Last post by sainudeen
Sat Apr 13, 2019 9:22 am
- Password protection for multiple files
-
- Show only integers, whole numbers without rounding
by szkodnik2103 » Fri Apr 12, 2019 10:38 pm - 2 Replies
- 206 Views
- Last post by MrProgrammer
Fri Apr 12, 2019 11:50 pm
- Show only integers, whole numbers without rounding
-
- Hide Cell with specific value/keyword
by Azshara » Fri Apr 12, 2019 2:16 pm - 1 Replies
- 151 Views
- Last post by Villeroy
Fri Apr 12, 2019 3:53 pm
- Hide Cell with specific value/keyword
-
- [Solved] Replace reference letters with words in drop list
by Fredrik Nilsson » Thu Apr 11, 2019 2:10 pm
- 6 Replies
- 252 Views
- Last post by Fredrik Nilsson
Fri Apr 12, 2019 2:24 pm
- [Solved] Replace reference letters with words in drop list
-
- I am unable to get this formula to work
by duckie256 » Fri Apr 12, 2019 6:10 am - 1 Replies
- 163 Views
- Last post by robleyd
Fri Apr 12, 2019 6:26 am
- I am unable to get this formula to work
-
- [Solved] Almost There - IF Statement
by quarkrad » Thu Apr 11, 2019 8:34 pm
- 5 Replies
- 214 Views
- Last post by Villeroy
Thu Apr 11, 2019 11:06 pm
- [Solved] Almost There - IF Statement
-
- Column name instead of letter
by sfhertach » Thu Apr 27, 2017 5:34 am - 9 Replies
- 1790 Views
- Last post by Villeroy
Thu Apr 11, 2019 12:37 pm
- Column name instead of letter
-
- [Solved] String Data Entry
by jhonpaul72 » Mon Apr 08, 2019 4:50 pm
- 22 Replies
- 519 Views
- Last post by jhonpaul72
Thu Apr 11, 2019 12:37 pm
- [Solved] String Data Entry
-
- Please clarify selection modes in Libreoffice Calc
by catbill » Thu Nov 22, 2018 11:12 pm
- 10 Replies
- 491 Views
- Last post by catbill
Thu Apr 11, 2019 1:27 am
- Please clarify selection modes in Libreoffice Calc
-
- [Solved] Keeping a cell calculation static if other data...
by freshbread » Tue Apr 09, 2019 4:18 am - 2 Replies
- 184 Views
- Last post by freshbread
Wed Apr 10, 2019 8:25 pm
- [Solved] Keeping a cell calculation static if other data...
-
- I want connect Calc to ODBC tables - how?
by Albireo » Sun Apr 07, 2019 4:03 pm - 13 Replies
- 522 Views
- Last post by Villeroy
Wed Apr 10, 2019 1:20 pm
- I want connect Calc to ODBC tables - how?
-
- [Solved] If specific string is not detected or missing
by jhonpaul72 » Tue Apr 09, 2019 5:11 pm
- 6 Replies
- 231 Views
- Last post by jhonpaul72
Wed Apr 10, 2019 12:22 pm
- [Solved] If specific string is not detected or missing
-
- Problem med utskrift
by kalepe » Wed Apr 10, 2019 11:00 am - 1 Replies
- 120 Views
- Last post by robleyd
Wed Apr 10, 2019 11:30 am
- Problem med utskrift
-
- Live Spreadsheet
by dctazz » Tue Apr 09, 2019 3:11 pm - 5 Replies
- 273 Views
- Last post by RoryOF
Tue Apr 09, 2019 7:44 pm
- Live Spreadsheet
-
- [Solved] IF, Between, Less Than, Then Add ...
by quarkrad » Tue Apr 09, 2019 5:42 pm
- 4 Replies
- 206 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
- 183 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
- 194 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
- 223 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
- 147 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
- 148 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
- 527 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
- 234 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
- 238 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
- 152 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
- 519 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
- 419 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
- 236 Views
- Last post by Zizi64
Sat Apr 06, 2019 11:14 am
- 3D chart-% data no show outside each segment
Who is online
Users browsing this forum: No registered users and 16 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
|