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: 27002
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 28385
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 24884
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 46099 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
- 33393 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Make one cell use a formula from another cell?
by LGN » Sat Apr 20, 2019 2:52 pm
- 6 Replies
- 116 Views
- Last post by Villeroy
Sun Apr 21, 2019 11:18 am
- Make one cell use a formula from another cell?
-
- No Grid in Calc
by coppens1 » Sat Apr 20, 2019 8:11 pm - 1 Replies
- 56 Views
- Last post by FJCC
Sat Apr 20, 2019 8:18 pm
- No Grid in Calc
-
- [Solved] Stacked Bar Heights Error!
by jkwanpg » Fri Apr 19, 2019 9:07 pm
- 8 Replies
- 125 Views
- Last post by jkwanpg
Sat Apr 20, 2019 7:53 pm
- [Solved] Stacked Bar Heights Error!
-
- [Solved)] IF() Formula
by bulsimike » Sat Apr 20, 2019 9:45 am
- 16 Replies
- 157 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
- 65 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
- 43 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
- 143 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
- 63 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
- 113 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
- 291 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
- 132 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
- 84 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
- 138 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
- 114 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
- 95 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
- 172 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
- 13246 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
- 96 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
- 133 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
- 220 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
- 133 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
- 138 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
- 106 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
- 111 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
- 23280 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
- 117 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
- 129 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
- 133 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
- 101 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
- 147 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
- 105 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
- 134 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
- 1393 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
- 320 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
- 360 Views
- Last post by catbill
Thu Apr 11, 2019 1:27 am
- Please clarify selection modes in Libreoffice Calc
-
- time*money
by bkkMarty » Wed Apr 10, 2019 2:25 pm
- 4 Replies
- 154 Views
- Last post by Villeroy
Wed Apr 10, 2019 8:40 pm
- time*money
-
- [Solved] Keeping a cell calculation static if other data...
by freshbread » Tue Apr 09, 2019 4:18 am - 2 Replies
- 132 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
- 279 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/missing on a cell
by jhonpaul72 » Tue Apr 09, 2019 5:11 pm
- 6 Replies
- 139 Views
- Last post by jhonpaul72
Wed Apr 10, 2019 12:22 pm
- [Solved]If specific string is not detected/missing on a cell
-
- Problem med utskrift
by kalepe » Wed Apr 10, 2019 11:00 am - 1 Replies
- 76 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
- 154 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
- 128 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
- 134 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
- 135 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
- 165 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
- 101 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
- 99 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
- 369 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
- 150 Views
- Last post by Jeff Root
Mon Apr 08, 2019 6:16 am
- [Solved] How to turn off spellcheck (or capitalization)?
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
|