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: 34798
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 36798
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 33745
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 11472 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Trying to understand how to use functions with Calc
by DayGlittering » Thu Jul 23, 2020 4:25 pm - 4 Replies
- 1055 Views
- Last post by DayGlittering
Thu Jul 23, 2020 6:16 pm
- [Solved] Trying to understand how to use functions with Calc
-
- [Solved] IF() function generates Err:509 message
by John175 » Thu Jul 23, 2020 7:37 am - 1 Replies
- 808 Views
- Last post by MrProgrammer
Thu Jul 23, 2020 8:07 am
- [Solved] IF() function generates Err:509 message
-
- [Solved] Hide a row based on a cell - No Macro knowledge
by amirlamdan » Thu Jul 23, 2020 12:14 am - 2 Replies
- 774 Views
- Last post by amirlamdan
Thu Jul 23, 2020 2:07 am
- [Solved] Hide a row based on a cell - No Macro knowledge
-
- Remove decimal separator in number
by elliot_123 » Tue Jul 21, 2020 2:55 am
- 5 Replies
- 1053 Views
- Last post by keme
Wed Jul 22, 2020 12:26 pm
- Remove decimal separator in number
-
- [Solved] Can't move legend; Makes graphs tiny
by Pickerel » Mon Jul 20, 2020 9:46 pm
- 2 Replies
- 813 Views
- Last post by MrProgrammer
Tue Jul 21, 2020 7:28 pm
- [Solved] Can't move legend; Makes graphs tiny
-
- Why are Arai motorcycle helmets so expensive and is it worth
by Nakyra » Sat Jul 18, 2020 3:58 am - 2 Replies
- 763 Views
- Last post by Villeroy
Mon Jul 20, 2020 5:57 pm
- Why are Arai motorcycle helmets so expensive and is it worth
-
- Desperate for a fourth conditional format
by Pugilist_Puppy » Sun Jul 19, 2020 6:22 pm
- 5 Replies
- 930 Views
- Last post by Villeroy
Mon Jul 20, 2020 5:24 pm
- Desperate for a fourth conditional format
-
- Saved Calc file won't load
by Trenoweth » Mon Jul 20, 2020 2:57 am - 10 Replies
- 1057 Views
- Last post by Trenoweth
Mon Jul 20, 2020 6:32 am
- Saved Calc file won't load
-
- [Solved] Trouble with a long if string
by blairapd » Fri Jul 17, 2020 7:10 am
- 8 Replies
- 975 Views
- Last post by blairapd
Mon Jul 20, 2020 1:34 am
- [Solved] Trouble with a long if string
-
- OpenOffice Calculate with IB TWS
by statiyo » Thu Jul 16, 2020 3:30 am - 5 Replies
- 969 Views
- Last post by Villeroy
Sat Jul 18, 2020 8:51 pm
- OpenOffice Calculate with IB TWS
-
- [Solved] Display time with am or pm
by dafyddapw » Mon Apr 06, 2020 2:51 pm
- 9 Replies
- 1344 Views
- Last post by Lupp
Fri Jul 17, 2020 2:01 pm
- [Solved] Display time with am or pm
-
- [Solved] Help understanding a formula
by BTFT66 » Fri Jul 17, 2020 12:15 am - 4 Replies
- 716 Views
- Last post by BTFT66
Fri Jul 17, 2020 12:43 am
- [Solved] Help understanding a formula
-
- Getting the percentage results from a blood test.
by RichardPrincipal » Thu Jul 16, 2020 8:55 pm
- 1 Replies
- 604 Views
- Last post by Lupp
Thu Jul 16, 2020 10:11 pm
- Getting the percentage results from a blood test.
-
- What is a "Calc modules field"?
by Lupp » Thu Jul 16, 2020 5:55 pm - 1 Replies
- 533 Views
- Last post by Zizi64
Thu Jul 16, 2020 6:15 pm
- What is a "Calc modules field"?
-
- [Solved] Protecting a sheet from copying OpenOffice Calc
by jeevanthara » Thu Jul 16, 2020 8:18 am - 4 Replies
- 739 Views
- Last post by jeevanthara
Thu Jul 16, 2020 5:39 pm
- [Solved] Protecting a sheet from copying OpenOffice Calc
-
- [Solved] Automatic loading of files when opening Calc
by dalepubs » Wed Jul 15, 2020 12:19 pm - 6 Replies
- 813 Views
- Last post by RoryOF
Wed Jul 15, 2020 6:01 pm
- [Solved] Automatic loading of files when opening Calc
-
- [Solved] Module fields don't save configuration
by simonesilenzi » Tue Jul 14, 2020 4:29 pm - 5 Replies
- 860 Views
- Last post by Lupp
Wed Jul 15, 2020 12:24 pm
- [Solved] Module fields don't save configuration
-
- [Solved] Calculating payments based on hours and percentages
by DaWat » Tue Jul 14, 2020 7:20 pm
- 3 Replies
- 649 Views
- Last post by DaWat
Tue Jul 14, 2020 10:51 pm
- [Solved] Calculating payments based on hours and percentages
-
- [Solved] Show/hide groups of cells
by neil-uk » Wed Jul 08, 2020 11:14 pm
- 2 Replies
- 735 Views
- Last post by neil-uk
Tue Jul 14, 2020 2:22 am
- [Solved] Show/hide groups of cells
-
- Daily update from online delimited file
by fr3d » Mon Jul 13, 2020 7:52 am - 2 Replies
- 683 Views
- Last post by Villeroy
Mon Jul 13, 2020 2:01 pm
- Daily update from online delimited file
-
- OpenOffice crashing while I use Calc
by Anduma22 » Sat Jul 11, 2020 11:52 pm - 3 Replies
- 776 Views
- Last post by Zizi64
Sun Jul 12, 2020 7:55 am
- OpenOffice crashing while I use Calc
-
- [Solved] Sliders buttons for sheet tabs
by Anduma22 » Sat Jul 11, 2020 11:43 pm
- 1 Replies
- 566 Views
- Last post by MrProgrammer
Sun Jul 12, 2020 5:16 am
- [Solved] Sliders buttons for sheet tabs
-
- [Solved] Cell reference with another cell value?
by MrFixitND » Wed Jul 12, 2017 11:08 pm - 6 Replies
- 5646 Views
- Last post by RobtAndr
Sat Jul 11, 2020 9:58 pm
- [Solved] Cell reference with another cell value?
-
- VLOOKUP function showing #N/A!
by T3524 » Fri Jul 10, 2020 7:59 pm - 5 Replies
- 969 Views
- Last post by Villeroy
Sat Jul 11, 2020 4:44 pm
- VLOOKUP function showing #N/A!
-
- Numbers filling cell from right side
by renoraider » Fri Jul 10, 2020 7:17 pm - 2 Replies
- 727 Views
- Last post by Lupp
Sat Jul 11, 2020 2:25 pm
- Numbers filling cell from right side
-
- [Solved] Increment/decrement feature for cells
by pecohen » Mon Jul 06, 2020 10:53 pm
- 8 Replies
- 1399 Views
- Last post by MrProgrammer
Fri Jul 10, 2020 5:03 pm
- [Solved] Increment/decrement feature for cells
-
- Toolbar Pop-ups
by Honey62953 » Fri Jul 10, 2020 2:41 am - 2 Replies
- 652 Views
- Last post by Hagar Delest
Fri Jul 10, 2020 8:16 am
- Toolbar Pop-ups
-
- Copy cell on certain date and save
by howtha » Thu Jul 09, 2020 6:09 pm - 1 Replies
- 549 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
- 594 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
- 1126 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
- 1607 Views
- Last post by FJCC
Thu Jul 09, 2020 12:43 am
- [Solved] Chart in spreadsheet add data
-
- [Solved] Unable to turn off design mode in Open Office Calc.
by jeevanthara » Wed Jul 08, 2020 2:38 pm - 4 Replies
- 636 Views
- Last post by jeevanthara
Wed Jul 08, 2020 7:21 pm
- [Solved] Unable to turn off design mode in Open Office Calc.
-
- [Solved] Column and Stacked Together?
by jmsld_ » Sun Jul 05, 2020 2:35 pm
- 2 Replies
- 560 Views
- Last post by jmsld_
Wed Jul 08, 2020 3:47 pm
- [Solved] Column and Stacked Together?
-
- [Solved] SUM function button gone
by tompkinstownship » Mon Jul 06, 2020 5:27 pm - 1 Replies
- 453 Views
- Last post by RoryOF
Mon Jul 06, 2020 5:51 pm
- [Solved] SUM function button gone
-
- Merge only non existing data
by alienrobotghost » Sun Jul 05, 2020 3:21 pm
- 1 Replies
- 428 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
- 545 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
- 933 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
- 2787 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
- 361 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
- 1162 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
- 542 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
- 575 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
- 418 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
- 375 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
- 395 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
- 723 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
- 630 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
- 740 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
- 1161 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
- 440 Views
- Last post by robleyd
Tue Jun 30, 2020 3:01 pm
- Formula does not transfer to other cells
Who is online
Users browsing this forum: No registered users and 31 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
|