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: 27939
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 29425
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26020
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 78522 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Duplicating formulas automatically upon row insert
by CFoertmeyer » Wed May 01, 2019 10:45 pm - 4 Replies
- 178 Views
- Last post by Villeroy
Thu May 02, 2019 12:19 am
- [Solved] Duplicating formulas automatically upon row insert
-
- [Solved] Check cell against array content - display if TRUE
by morphingstar » Tue Apr 30, 2019 1:25 am
- 2 Replies
- 190 Views
- Last post by morphingstar
Wed May 01, 2019 9:03 pm
- [Solved] Check cell against array content - display if TRUE
-
- [Solved] Weekday by combining cells
by tpox » Wed May 01, 2019 5:27 pm
- 2 Replies
- 149 Views
- Last post by tpox
Wed May 01, 2019 6:40 pm
- [Solved] Weekday by combining cells
-
- [Solved] Using formula on entire column
by bigdaddyfred » Tue Apr 30, 2019 10:49 pm - 1 Replies
- 168 Views
- Last post by MrProgrammer
Tue Apr 30, 2019 10:53 pm
- [Solved] Using formula on entire column
-
- Appending text to existing text, selectively
by Skompy » Wed Mar 29, 2017 5:05 pm
- 15 Replies
- 1953 Views
- Last post by Skompy
Tue Apr 30, 2019 7:22 pm
- Appending text to existing text, selectively
-
- [Solved] Product If help
by Umphridas » Mon Apr 29, 2019 11:21 pm
- 5 Replies
- 202 Views
- Last post by Umphridas
Tue Apr 30, 2019 5:47 pm
- [Solved] Product If help
-
- Calc chart will not refresh
by cajun4046 » Mon Apr 29, 2019 7:58 pm - 2 Replies
- 176 Views
- Last post by Villeroy
Mon Apr 29, 2019 9:06 pm
- Calc chart will not refresh
-
- SUM Veritical/Horizonal
by MCR » Fri Apr 26, 2019 10:18 pm - 7 Replies
- 295 Views
- Last post by MrProgrammer
Mon Apr 29, 2019 4:25 pm
- SUM Veritical/Horizonal
-
- [solved] Checking values
by jimbokea » Sat Apr 27, 2019 2:53 am - 9 Replies
- 394 Views
- Last post by robleyd
Mon Apr 29, 2019 2:16 am
- [solved] Checking values
-
- Copy and paste part of a column
by mukiduk » Sun Apr 28, 2019 11:36 pm - 3 Replies
- 198 Views
- Last post by FJCC
Mon Apr 29, 2019 1:27 am
- Copy and paste part of a column
-
- [solved] validity check
by jimbokea » Mon Apr 29, 2019 12:44 am - 1 Replies
- 127 Views
- Last post by jimbokea
Mon Apr 29, 2019 12:57 am
- [solved] validity check
-
- Format error in sub-document
by viking55 » Sat Apr 27, 2019 8:16 pm - 7 Replies
- 241 Views
- Last post by RoryOF
Sun Apr 28, 2019 4:02 pm
- Format error in sub-document
-
- Excel Spreadsheet vs Apache Calc
by RonWil » Sat Apr 27, 2019 6:40 pm - 2 Replies
- 185 Views
- Last post by Villeroy
Sat Apr 27, 2019 9:03 pm
- Excel Spreadsheet vs Apache Calc
-
- [Solved] Transposing data in a column to multiple rows
by Prasanjith » Thu Apr 25, 2019 9:15 pm
- 9 Replies
- 272 Views
- Last post by Prasanjith
Sat Apr 27, 2019 6:51 pm
- [Solved] Transposing data in a column to multiple rows
-
- Automaticly Highlight duplicate values in a column row
by MiRaDoR » Mon Nov 09, 2015 3:21 pm
- 4 Replies
- 14663 Views
- Last post by atxemtp
Fri Apr 26, 2019 4:54 pm
- Automaticly Highlight duplicate values in a column row
-
- If/Then with positive and negative numbers
by keithbakerlv » Fri Apr 26, 2019 3:52 pm - 1 Replies
- 158 Views
- Last post by FJCC
Fri Apr 26, 2019 4:27 pm
- If/Then with positive and negative numbers
-
- e-mail addresses highlighted in spreadsheet
by samcl » Thu Apr 25, 2019 5:37 pm
- 7 Replies
- 258 Views
- Last post by Zizi64
Fri Apr 26, 2019 7:15 am
- e-mail addresses highlighted in spreadsheet
-
- Why is it printing the whole file?
by thaX » Wed Apr 24, 2019 3:38 am - 4 Replies
- 208 Views
- Last post by Zizi64
Fri Apr 26, 2019 6:57 am
- Why is it printing the whole file?
-
- [Solved] Question on qualifiers
by macjohn79 » Thu Apr 25, 2019 9:40 pm - 2 Replies
- 153 Views
- Last post by RusselB
Fri Apr 26, 2019 4:14 am
- [Solved] Question on qualifiers
-
- [Solved] Simple Calculation Gives Me "Err:522"
by Colin-Campbell » Sun Apr 21, 2019 9:58 pm
- 12 Replies
- 593 Views
- Last post by Villeroy
Thu Apr 25, 2019 2:11 pm
- [Solved] Simple Calculation Gives Me "Err:522"
-
- [Solved] Adding two columns in a Row with Criteria
by quarkrad » Tue Apr 23, 2019 7:49 pm
- 10 Replies
- 337 Views
- Last post by quarkrad
Wed Apr 24, 2019 8:34 pm
- [Solved] Adding two columns in a Row with Criteria
-
- [Solved] Arrow suddenly change
by Adelheid » Wed Apr 24, 2019 11:49 am - 2 Replies
- 187 Views
- Last post by Adelheid
Wed Apr 24, 2019 1:35 pm
- [Solved] Arrow suddenly change
-
- [Solved] Adding cells that are only numbers
by PTReese » Wed Apr 24, 2019 3:44 am - 3 Replies
- 200 Views
- Last post by RusselB
Wed Apr 24, 2019 4:31 am
- [Solved] Adding cells that are only numbers
-
- [Solved] No Grid in Calc
by coppens1 » Sat Apr 20, 2019 8:11 pm - 2 Replies
- 223 Views
- Last post by coppens1
Tue Apr 23, 2019 5:46 pm
- [Solved] No Grid in Calc
-
- [Solved] Copying a cell
by keithbakerlv » Tue Apr 23, 2019 2:14 am - 2 Replies
- 173 Views
- Last post by MrProgrammer
Tue Apr 23, 2019 2:33 am
- [Solved] Copying a cell
-
- Problem with .ods file. File date went back 2 months
by dumpie_n » Tue Apr 23, 2019 12:21 am - 1 Replies
- 152 Views
- Last post by RoryOF
Tue Apr 23, 2019 12:36 am
- Problem with .ods file. File date went back 2 months
-
- [Solved] How to remove left ribbon?
by Perflourate » Mon Apr 22, 2019 4:09 am
- 2 Replies
- 160 Views
- Last post by Perflourate
Mon Apr 22, 2019 6:54 am
- [Solved] How to remove left ribbon?
-
- Make one cell use a formula from another cell?
by LGN » Sat Apr 20, 2019 2:52 pm
- 6 Replies
- 337 Views
- Last post by Villeroy
Sun Apr 21, 2019 11:18 am
- Make one cell use a formula from another cell?
-
- [Solved] Stacked Bar Heights Error!
by jkwanpg » Fri Apr 19, 2019 9:07 pm
- 8 Replies
- 282 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
- 401 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
- 185 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
- 170 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
- 307 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
- 165 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
- 222 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
- 484 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
- 254 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
- 232 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
- 237 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
- 203 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
- 194 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
- 270 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
- 13728 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
- 271 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
- 252 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
- 376 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
- 224 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
- 248 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
- 176 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
- 176 Views
- Last post by MrProgrammer
Sun Apr 14, 2019 3:51 pm
- Create multiple IF function criteria-error
Who is online
Users browsing this forum: cdorman2 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
|