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: 28499
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 30075
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 26669
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 8170 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Cell Sizes Change When Opening ODS File on Another PC
by typicallytiffany » Sat Jul 20, 2019 6:54 am - 5 Replies
- 226 Views
- Last post by Zizi64
Sun Jul 21, 2019 8:58 pm
- Cell Sizes Change When Opening ODS File on Another PC
-
- How to keep today's Date from updating
by Brevardo » Sat Jul 20, 2019 1:30 pm
- 13 Replies
- 383 Views
- Last post by Zizi64
Sun Jul 21, 2019 12:11 pm
- How to keep today's Date from updating
-
- Getting creative with = RANDBETWEEN
by Brevardo » Sat Jul 20, 2019 1:45 pm
- 2 Replies
- 162 Views
- Last post by F3K Total
Sat Jul 20, 2019 3:03 pm
- Getting creative with = RANDBETWEEN
-
- [Solved] LOOKUP function returns odd results
by HelloW » Sat Jul 20, 2019 3:37 am
- 3 Replies
- 188 Views
- Last post by Villeroy
Sat Jul 20, 2019 9:09 am
- [Solved] LOOKUP function returns odd results
-
- Row height not sticking
by wendi » Sat Jul 20, 2019 4:13 am
- 8 Replies
- 257 Views
- Last post by wendi
Sat Jul 20, 2019 6:38 am
- Row height not sticking
-
- [Solved] Add value in col unless empty
by swmwshrk » Thu Jul 18, 2019 2:46 am - 2 Replies
- 173 Views
- Last post by swmwshrk
Sat Jul 20, 2019 1:07 am
- [Solved] Add value in col unless empty
-
- [Solved] Email address background
by Bob Coleman » Fri Jul 19, 2019 11:06 pm - 6 Replies
- 252 Views
- Last post by Bob Coleman
Sat Jul 20, 2019 12:17 am
- [Solved] Email address background
-
- How to calculate in a period: Years, Months and days.
1, 2 by Juanchio88 » Thu Jan 26, 2017 6:56 pm
- 35 Replies
- 5226 Views
- Last post by Villeroy
Fri Jul 19, 2019 7:28 pm
- How to calculate in a period: Years, Months and days.
-
- Acquiring and importing data from source spreadsheet
by CNR » Fri Jul 19, 2019 10:58 am - 7 Replies
- 261 Views
- Last post by Villeroy
Fri Jul 19, 2019 2:55 pm
- Acquiring and importing data from source spreadsheet
-
- [Solved] Filter year & ignore MM DD
by morphingstar » Thu Jul 18, 2019 8:19 pm - 3 Replies
- 177 Views
- Last post by morphingstar
Thu Jul 18, 2019 8:46 pm
- [Solved] Filter year & ignore MM DD
-
- Issue with changing text in cells automatically
by allfourone » Wed Jul 17, 2019 1:20 am
- 17 Replies
- 446 Views
- Last post by Sliderule
Thu Jul 18, 2019 8:15 pm
- Issue with changing text in cells automatically
-
- It scrolls to the bottom when I click on it?????
by 2BadRic » Tue Mar 19, 2019 10:09 pm - 6 Replies
- 487 Views
- Last post by 2BadRic
Thu Jul 18, 2019 4:28 pm
- It scrolls to the bottom when I click on it?????
-
- [Solved] X-axis not related to X values using scatter chart
by CLC » Thu Jul 04, 2019 12:46 pm
- 5 Replies
- 249 Views
- Last post by CLC
Thu Jul 18, 2019 4:05 pm
- [Solved] X-axis not related to X values using scatter chart
-
- [Solved] Averaging the top 10 scores out of 20
by mrmark » Tue Jul 16, 2019 2:43 pm
- 4 Replies
- 276 Views
- Last post by mrmark
Thu Jul 18, 2019 2:27 pm
- [Solved] Averaging the top 10 scores out of 20
-
- [Solved]Conditional Formatting - change cell background
by SnehalS » Wed Jul 17, 2019 8:09 am
- 5 Replies
- 223 Views
- Last post by Zizi64
Thu Jul 18, 2019 6:38 am
- [Solved]Conditional Formatting - change cell background
-
- [Solved] Text to columns - split at first space
by cul » Wed Jul 17, 2019 10:12 am - 5 Replies
- 226 Views
- Last post by cul
Thu Jul 18, 2019 6:11 am
- [Solved] Text to columns - split at first space
-
- [Solved] Carry over the greater value from three columns
by egfreeze » Wed Jul 17, 2019 4:45 pm - 2 Replies
- 165 Views
- Last post by egfreeze
Wed Jul 17, 2019 4:47 pm
- [Solved] Carry over the greater value from three columns
-
- [Solved] Error 508
by pratikpa » Tue Jul 16, 2019 8:19 pm - 2 Replies
- 175 Views
- Last post by pratikpa
Wed Jul 17, 2019 3:05 pm
- [Solved] Error 508
-
- [Solved] Create a drop down list with coloured box
by Senko » Tue Jul 16, 2019 9:55 am
- 2 Replies
- 219 Views
- Last post by Senko
Wed Jul 17, 2019 4:26 am
- [Solved] Create a drop down list with coloured box
-
- Conditional Formatting by Date
by jc macgiver » Mon Jul 15, 2019 8:00 pm
- 6 Replies
- 291 Views
- Last post by jc macgiver
Tue Jul 16, 2019 12:21 am
- Conditional Formatting by Date
-
- [Solved] Plz translate Excel formula to OpenOffice
by statiyo » Mon Jul 15, 2019 4:01 am
- 12 Replies
- 410 Views
- Last post by John_Ha
Mon Jul 15, 2019 10:29 pm
- [Solved] Plz translate Excel formula to OpenOffice
-
- Select cells in particular sequence
by Osmario » Mon Jul 15, 2019 1:44 pm - 3 Replies
- 177 Views
- Last post by RusselB
Mon Jul 15, 2019 4:44 pm
- Select cells in particular sequence
-
- How many times the word appears in the cell
by dawidek990 » Mon Jul 15, 2019 12:58 pm
- 3 Replies
- 165 Views
- Last post by Zizi64
Mon Jul 15, 2019 4:01 pm
- How many times the word appears in the cell
-
- List the results of a query
by Marck_97 » Sat Jul 13, 2019 6:37 pm
- 2 Replies
- 173 Views
- Last post by Marck_97
Mon Jul 15, 2019 2:29 pm
- List the results of a query
-
- [Solved] Trouble Sorting Numbers in a Range Left to Right
by Deese » Sun Jul 14, 2019 7:28 pm
- 10 Replies
- 244 Views
- Last post by Deese
Mon Jul 15, 2019 2:08 pm
- [Solved] Trouble Sorting Numbers in a Range Left to Right
-
- [Solved] Exclude word from sentence
by dawidek990 » Fri Mar 01, 2019 8:12 pm
- 29 Replies
- 790 Views
- Last post by dawidek990
Mon Jul 15, 2019 12:45 pm
- [Solved] Exclude word from sentence
-
- [Solved] Moving info in a row to a column in different sheet
by swmwshrk » Sat Jul 13, 2019 8:05 pm - 2 Replies
- 202 Views
- Last post by swmwshrk
Sun Jul 14, 2019 4:34 pm
- [Solved] Moving info in a row to a column in different sheet
-
- Stopwatch timing
by ndiniz2012 » Sun Jul 14, 2019 7:54 am - 3 Replies
- 188 Views
- Last post by F3K Total
Sun Jul 14, 2019 9:40 am
- Stopwatch timing
-
- [Solved] Simple SUM calculation is doubling final total
by PatrickJD » Sat Jul 13, 2019 5:04 pm
- 5 Replies
- 197 Views
- Last post by PatrickJD
Sat Jul 13, 2019 6:27 pm
- [Solved] Simple SUM calculation is doubling final total
-
- [Solved] Grouping and sorting
by macjohn79 » Mon Jul 08, 2019 9:43 pm
- 3 Replies
- 283 Views
- Last post by Villeroy
Fri Jul 12, 2019 10:05 pm
- [Solved] Grouping and sorting
-
- Spreadsheet corrupt?
by robertje3 » Fri Jul 12, 2019 12:36 pm - 1 Replies
- 147 Views
- Last post by RoryOF
Fri Jul 12, 2019 12:40 pm
- Spreadsheet corrupt?
-
- CellFormat weeknumber-to-date ?
by onidarbe » Fri Jan 23, 2009 3:26 am - 13 Replies
- 6633 Views
- Last post by RusselB
Fri Jul 12, 2019 5:29 am
- CellFormat weeknumber-to-date ?
-
- [Solved] Calc cell phone numbers
by wallroad » Thu Mar 06, 2014 10:34 pm
- 13 Replies
- 6055 Views
- Last post by auntiebk
Thu Jul 11, 2019 7:26 pm
- [Solved] Calc cell phone numbers
-
- edit Chart TITLE
by abi » Thu Jul 11, 2019 2:47 pm - 1 Replies
- 134 Views
- Last post by MrProgrammer
Thu Jul 11, 2019 5:36 pm
- edit Chart TITLE
-
- [SOLVED] SUBSTITUTE drop downs x2 variables (nested?)
by pherriot » Fri May 31, 2019 10:37 am
- 5 Replies
- 315 Views
- Last post by pherriot
Thu Jul 11, 2019 2:23 pm
- [SOLVED] SUBSTITUTE drop downs x2 variables (nested?)
-
- [SOLVED] Collect cell data and display in new cell.
by pherriot » Thu Jun 06, 2019 9:30 am
- 13 Replies
- 835 Views
- Last post by pherriot
Thu Jul 11, 2019 2:20 pm
- [SOLVED] Collect cell data and display in new cell.
-
- [Solved] Copy a portion of one sheet to another sheet.
by BarnMgr » Wed Jul 10, 2019 9:39 pm - 3 Replies
- 209 Views
- Last post by BarnMgr
Thu Jul 11, 2019 1:58 am
- [Solved] Copy a portion of one sheet to another sheet.
-
- [Solved] Add items with respect to previous entries
by EduardDurb » Tue Jul 09, 2019 5:39 pm
- 7 Replies
- 295 Views
- Last post by Villeroy
Wed Jul 10, 2019 4:24 pm
- [Solved] Add items with respect to previous entries
-
- [Solved] Excel-AddIn 'Power Query' in OpenOffice Calc
by OtenMoten » Tue Aug 22, 2017 9:11 am - 12 Replies
- 6338 Views
- Last post by Zizi64
Wed Jul 10, 2019 12:17 pm
- [Solved] Excel-AddIn 'Power Query' in OpenOffice Calc
-
- Changes Information it's not showing !
by im.eugen » Mon Jul 08, 2019 2:28 pm
- 4 Replies
- 226 Views
- Last post by RoryOF
Tue Jul 09, 2019 4:57 pm
- Changes Information it's not showing !
-
- [Solved] How to find the last word in cell, copy to new cell
by 3graygirls » Tue Jul 09, 2019 1:28 am - 6 Replies
- 332 Views
- Last post by FJCC
Tue Jul 09, 2019 4:27 am
- [Solved] How to find the last word in cell, copy to new cell
-
- [SOLVED] How to copy-paste the result of =TODAY() as a date?
by raschumacher » Wed Jul 03, 2019 9:16 pm - 6 Replies
- 284 Views
- Last post by raschumacher
Tue Jul 09, 2019 12:02 am
- [SOLVED] How to copy-paste the result of =TODAY() as a date?
-
- [Solved] Unique Value Formula (very researched)
by monkeyisland » Tue Jul 02, 2019 1:54 am
- 5 Replies
- 389 Views
- Last post by monkeyisland
Mon Jul 08, 2019 7:51 pm
- [Solved] Unique Value Formula (very researched)
-
- [Solved] Extract Month Name from Date
by Phillip » Fri Jul 05, 2019 1:54 pm
- 6 Replies
- 348 Views
- Last post by Phillip
Mon Jul 08, 2019 1:35 pm
- [Solved] Extract Month Name from Date
-
- Interrupted Sequential Numbering
by mel3264 » Sat Jul 06, 2019 8:37 am
- 3 Replies
- 239 Views
- Last post by keme
Mon Jul 08, 2019 8:47 am
- Interrupted Sequential Numbering
-
- Data Matrix Code
by WalkerWight » Sun Jul 07, 2019 11:55 pm
- 4 Replies
- 207 Views
- Last post by WalkerWight
Mon Jul 08, 2019 8:38 am
- Data Matrix Code
-
- [Solved] Combining spreadsheets
by BillJ » Thu Jul 04, 2019 1:15 am
- 9 Replies
- 518 Views
- Last post by BillJ
Sat Jul 06, 2019 5:17 pm
- [Solved] Combining spreadsheets
-
- Update of Graphs Fails
by himpelr » Wed Jul 16, 2014 5:10 pm
- 11 Replies
- 3403 Views
- Last post by claytonrogers
Sat Jul 06, 2019 4:25 am
- Update of Graphs Fails
-
- [Solved] Persistent Column Headings
by immarci2 » Sat Jul 06, 2019 12:30 am - 2 Replies
- 146 Views
- Last post by FJCC
Sat Jul 06, 2019 1:19 am
- [Solved] Persistent Column Headings
Who is online
Users browsing this forum: No registered users and 11 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
|