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: 30938
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 32746
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 29587
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 105548 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 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
- 42737 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Copy cell on certain date and save
by howtha » Thu Jul 09, 2020 6:09 pm - 1 Replies
- 49 Views
- Last post by Lupp
Thu Jul 09, 2020 9:48 pm
- Copy cell on certain date and save
-
- Function to Calculate per ton/mile
by stacie » Tue Jul 07, 2020 5:38 pm - 1 Replies
- 108 Views
- Last post by Villeroy
Thu Jul 09, 2020 10:26 am
- Function to Calculate per ton/mile
-
- "Optimal column Width" Makes Columns TINY in tiny Width??
by axelrose » Thu Jul 02, 2020 9:28 pm - 7 Replies
- 175 Views
- Last post by Lupp
Thu Jul 09, 2020 10:18 am
- "Optimal column Width" Makes Columns TINY in tiny Width??
-
- [Solved] Chart in spreadsheet add data
by legalnan » Tue Jul 07, 2020 8:17 pm
- 17 Replies
- 230 Views
- Last post by FJCC
Thu Jul 09, 2020 12:43 am
- [Solved] Chart in spreadsheet add data
-
- What is this and how do I do it?
by neil-uk » Wed Jul 08, 2020 11:14 pm
- 1 Replies
- 61 Views
- Last post by FJCC
Thu Jul 09, 2020 12:41 am
- What is this and how do I do it?
-
- [Solved] Unable to turn off design mode in Open Office Calc.
by jeevanthara » Wed Jul 08, 2020 2:38 pm - 4 Replies
- 75 Views
- Last post by jeevanthara
Wed Jul 08, 2020 7:21 pm
- [Solved] Unable to turn off design mode in Open Office Calc.
-
- Column and Stacked Together?
by jmsld_ » Sun Jul 05, 2020 2:35 pm
- 2 Replies
- 106 Views
- Last post by jmsld_
Wed Jul 08, 2020 3:47 pm
- Column and Stacked Together?
-
- Increment/decrement feature for cells
by pecohen » Mon Jul 06, 2020 10:53 pm
- 7 Replies
- 209 Views
- Last post by Lupp
Wed Jul 08, 2020 12:18 am
- Increment/decrement feature for cells
-
- SUM function button gone
by tompkinstownship » Mon Jul 06, 2020 5:27 pm - 1 Replies
- 89 Views
- Last post by RoryOF
Mon Jul 06, 2020 5:51 pm
- SUM function button gone
-
- [Solved] Suddenly I cannot open my Calc file
by Fjallraven1 » Mon Jul 06, 2020 3:48 pm
- 2 Replies
- 94 Views
- Last post by Fjallraven1
Mon Jul 06, 2020 4:47 pm
- [Solved] Suddenly I cannot open my Calc file
-
- Merge only non existing data
by alienrobotghost » Sun Jul 05, 2020 3:21 pm
- 1 Replies
- 111 Views
- Last post by Lupp
Sun Jul 05, 2020 4:36 pm
- Merge only non existing data
-
- [Solved] WIN10 V2004 problems?
by THEBookMan » Fri Jul 03, 2020 6:03 pm - 4 Replies
- 166 Views
- Last post by DiGro
Sun Jul 05, 2020 2:49 pm
- [Solved] WIN10 V2004 problems?
-
- [Solved] Merge two (2 axis) spreadsheets into one
by alienrobotghost » Thu Jun 25, 2020 10:29 am
- 9 Replies
- 300 Views
- Last post by alienrobotghost
Sun Jul 05, 2020 2:37 pm
- [Solved] Merge two (2 axis) spreadsheets into one
-
- Index and match multiple results/rows
by zander73 » Fri Jul 03, 2020 12:41 am
- 7 Replies
- 273 Views
- Last post by zander73
Sat Jul 04, 2020 9:15 pm
- Index and match multiple results/rows
-
- Copy emails separated with comma in a cell into a row
by norwegenfan2020 » Fri Jul 03, 2020 10:39 am - 1 Replies
- 108 Views
- Last post by Jeff
Sat Jul 04, 2020 3:08 pm
- Copy emails separated with comma in a cell into a row
-
- [Solved] Follow-Up, Counting Unique Items by Group
by nasch » Wed Jul 01, 2020 5:30 pm
- 10 Replies
- 296 Views
- Last post by nasch
Sat Jul 04, 2020 1:47 pm
- [Solved] Follow-Up, Counting Unique Items by Group
-
- [Solved] Formula for multiplying one cell by another
by themechanic » Sat Jul 04, 2020 8:52 am
- 4 Replies
- 125 Views
- Last post by themechanic
Sat Jul 04, 2020 10:43 am
- [Solved] Formula for multiplying one cell by another
-
- [Solved] Detect duplicate entries easier
by alienrobotghost » Thu Jul 02, 2020 1:01 pm
- 4 Replies
- 129 Views
- Last post by alienrobotghost
Fri Jul 03, 2020 10:38 am
- [Solved] Detect duplicate entries easier
-
- Determine average weight per day per person
by ReggaeRoy » Thu Jul 02, 2020 12:25 pm
- 2 Replies
- 122 Views
- Last post by ReggaeRoy
Fri Jul 03, 2020 10:38 am
- Determine average weight per day per person
-
- [Solved] Dragging first value of a column all the way down
by dharmarick » Thu Jul 02, 2020 10:35 pm - 3 Replies
- 97 Views
- Last post by dharmarick
Thu Jul 02, 2020 11:00 pm
- [Solved] Dragging first value of a column all the way down
-
- Edit / Fill not working as i expected
by Burgundybay » Thu Jul 02, 2020 1:11 pm - 1 Replies
- 125 Views
- Last post by RoryOF
Thu Jul 02, 2020 5:10 pm
- Edit / Fill not working as i expected
-
- [Solved] Creating dynamic hyperlink using OpenOffice Calc
by jeevanthara » Wed Jul 01, 2020 11:18 am - 6 Replies
- 186 Views
- Last post by jeevanthara
Wed Jul 01, 2020 1:06 pm
- [Solved] Creating dynamic hyperlink using OpenOffice Calc
-
- [Solved] OpenOffice Calc changing dates
by elf » Wed Jul 01, 2020 4:10 am
- 3 Replies
- 184 Views
- Last post by Villeroy
Wed Jul 01, 2020 11:31 am
- [Solved] OpenOffice Calc changing dates
-
- [SOLVED] Another issue with conditional formatting...
by SCFrolich » Tue Jun 30, 2020 11:54 pm
- 5 Replies
- 169 Views
- Last post by SCFrolich
Wed Jul 01, 2020 9:27 am
- [SOLVED] Another issue with conditional formatting...
-
- [Solved] Create rows as specified by a number in a cell
by Pancevac » Tue Jun 23, 2020 3:04 am
- 10 Replies
- 375 Views
- Last post by Pancevac
Wed Jul 01, 2020 4:22 am
- [Solved] Create rows as specified by a number in a cell
-
- Formula does not transfer to other cells
by jeffrey3600 » Tue Jun 30, 2020 1:18 pm - 2 Replies
- 128 Views
- Last post by robleyd
Tue Jun 30, 2020 3:01 pm
- Formula does not transfer to other cells
-
- Show a plus or minus result
by jeffrey3600 » Tue Jun 30, 2020 12:25 pm - 4 Replies
- 135 Views
- Last post by Hagar Delest
Tue Jun 30, 2020 1:33 pm
- Show a plus or minus result
-
- [Solved] complicated conditional formatting & data validity
by SCFrolich » Sun Jun 28, 2020 10:58 pm - 3 Replies
- 195 Views
- Last post by SCFrolich
Tue Jun 30, 2020 5:06 am
- [Solved] complicated conditional formatting & data validity
-
- [NOT Solved ... abandoned] Dates changed
by THEBookMan » Sat Jun 27, 2020 6:42 pm
- 24 Replies
- 572 Views
- Last post by Villeroy
Mon Jun 29, 2020 9:58 pm
- [NOT Solved ... abandoned] Dates changed
-
- [Solved] Find and replace help
by JDT » Mon Jun 29, 2020 6:47 pm - 3 Replies
- 141 Views
- Last post by JDT
Mon Jun 29, 2020 7:48 pm
- [Solved] Find and replace help
-
- How to unlink sheet formatting within a spreadsheet?
by nebowofa » Mon Jun 29, 2020 4:42 am - 2 Replies
- 124 Views
- Last post by Zizi64
Mon Jun 29, 2020 6:07 am
- How to unlink sheet formatting within a spreadsheet?
-
- Calc changing numbers without asking
by amdcrash » Sun Jun 28, 2020 11:16 am - 11 Replies
- 235 Views
- Last post by Villeroy
Sun Jun 28, 2020 6:55 pm
- Calc changing numbers without asking
-
- Default sheet after opening
by dentopolis » Thu Jun 25, 2020 8:34 pm - 11 Replies
- 335 Views
- Last post by Villeroy
Fri Jun 26, 2020 1:52 pm
- Default sheet after opening
-
- [Solved] How to transpose cells
by withnail » Wed Jun 24, 2020 11:58 pm
- 4 Replies
- 232 Views
- Last post by withnail
Thu Jun 25, 2020 5:43 pm
- [Solved] How to transpose cells
-
- ?Increment cell call =A1 to become =A2 farDown inLARGE sheet
by Penguin_In_Circles » Wed Jun 24, 2020 9:45 pm - 3 Replies
- 140 Views
- Last post by Lupp
Wed Jun 24, 2020 11:47 pm
- ?Increment cell call =A1 to become =A2 farDown inLARGE sheet
-
- [Solved] WEEKNUM for today's date
by gibsongk55 » Wed Jun 24, 2020 11:40 am - 4 Replies
- 155 Views
- Last post by Lupp
Wed Jun 24, 2020 10:00 pm
- [Solved] WEEKNUM for today's date
-
- [Solved] Counting with 2 Criteria (One could be a date)
by nasch » Tue Jun 23, 2020 12:27 pm
- 2 Replies
- 173 Views
- Last post by nasch
Wed Jun 24, 2020 12:40 pm
- [Solved] Counting with 2 Criteria (One could be a date)
-
- [Solved] Button Hyperlink in Calc
by arc1950 » Tue Jun 23, 2020 3:51 am - 4 Replies
- 205 Views
- Last post by arc1950
Wed Jun 24, 2020 7:20 am
- [Solved] Button Hyperlink in Calc
-
- [Solved] Anchor to cell doesn't work
by Surnis » Sat May 23, 2020 4:29 am
- 13 Replies
- 543 Views
- Last post by Zizi64
Wed Jun 24, 2020 5:59 am
- [Solved] Anchor to cell doesn't work
-
- [Solved] Conditional Formatting
by LloydIOW » Mon Jun 22, 2020 9:59 pm
- 2 Replies
- 235 Views
- Last post by LloydIOW
Tue Jun 23, 2020 6:42 pm
- [Solved] Conditional Formatting
-
- Split/add one cell into another cell
by darthstig » Mon Jun 22, 2020 10:19 pm
- 7 Replies
- 168 Views
- Last post by RusselB
Tue Jun 23, 2020 1:51 am
- Split/add one cell into another cell
-
- OGame Expeditions - Statistics Spreadsheet
by Runner1409 » Thu Jun 18, 2020 2:17 am
- 11 Replies
- 445 Views
- Last post by Runner1409
Mon Jun 22, 2020 12:40 pm
- OGame Expeditions - Statistics Spreadsheet
-
- How to have cells space out automatically
by Anduma22 » Fri Jun 19, 2020 3:43 pm - 6 Replies
- 291 Views
- Last post by Anduma22
Sun Jun 21, 2020 4:59 pm
- How to have cells space out automatically
-
- [Solved] Remove Blank Cells From Column
by zander73 » Mon Jun 15, 2020 10:17 pm
- 2 Replies
- 232 Views
- Last post by zander73
Sun Jun 21, 2020 4:25 am
- [Solved] Remove Blank Cells From Column
-
- Calc truncates xls file
by nigello » Thu Apr 13, 2017 11:42 am - 9 Replies
- 2054 Views
- Last post by richj
Sun Jun 21, 2020 1:32 am
- Calc truncates xls file
-
- [Solved] Chart color in Calc
by jyoung » Sat Jun 20, 2020 8:14 pm - 2 Replies
- 165 Views
- Last post by Zizi64
Sat Jun 20, 2020 10:22 pm
- [Solved] Chart color in Calc
-
- [Solved] CSV and COUNT questions
by Laporbo » Thu Jun 11, 2020 1:02 pm
- 16 Replies
- 540 Views
- Last post by robleyd
Sat Jun 20, 2020 4:34 am
- [Solved] CSV and COUNT questions
-
- [Solved] Pie chart colours
by Richarda44 » Thu Dec 01, 2016 3:02 pm
- 9 Replies
- 4161 Views
- Last post by yenaset630
Fri Jun 19, 2020 7:37 pm
- [Solved] Pie chart colours
-
- "Read Only"? and associated issues
by ColinH77 » Fri Jun 19, 2020 11:47 am - 6 Replies
- 224 Views
- Last post by robleyd
Fri Jun 19, 2020 3:18 pm
- "Read Only"? and associated issues
Who is online
Users browsing this forum: No registered users and 7 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
|