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: 31818
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33654
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 30546
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 133530 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Adding preference shortcut to toolbar
by orionp3 » Sun Feb 16, 2020 7:42 am - 2 Replies
- 312 Views
- Last post by orionp3
Wed Feb 19, 2020 2:24 pm
- Adding preference shortcut to toolbar
-
- [Solved] Get a value and a letter next to each other
by maxbb » Tue Feb 18, 2020 9:22 pm
- 6 Replies
- 393 Views
- Last post by maxbb
Wed Feb 19, 2020 10:31 am
- [Solved] Get a value and a letter next to each other
-
- Publish larger amounts of data in google-calendar-events !?
by sayhello » Sun Feb 09, 2020 5:03 pm
- 6 Replies
- 565 Views
- Last post by sayhello
Mon Feb 17, 2020 4:59 pm
- Publish larger amounts of data in google-calendar-events !?
-
- [Solved] Creating a new column from bits of existing column
by DavidATK » Thu Feb 13, 2020 1:04 am - 7 Replies
- 513 Views
- Last post by DavidATK
Sun Feb 16, 2020 11:12 pm
- [Solved] Creating a new column from bits of existing column
-
- Data labels from third column in scatter plot
by Rayosu » Sun Feb 16, 2020 2:52 am
- 1 Replies
- 253 Views
- Last post by FJCC
Sun Feb 16, 2020 7:09 am
- Data labels from third column in scatter plot
-
- Adding a value to a specific cell
by tkadz » Sat Feb 15, 2020 7:44 pm
- 3 Replies
- 288 Views
- Last post by robleyd
Sun Feb 16, 2020 12:48 am
- Adding a value to a specific cell
-
- [Solved] Inline functions/macros inside a cell?
by CaveDweller » Fri Feb 14, 2020 3:35 am
- 2 Replies
- 312 Views
- Last post by CaveDweller
Fri Feb 14, 2020 10:19 pm
- [Solved] Inline functions/macros inside a cell?
-
- [Solved] Help me fix "=+SUMIF(... ;" >TODAY()-30" ;...)"
by cliffb » Fri Feb 14, 2020 6:33 am
- 7 Replies
- 412 Views
- Last post by robleyd
Fri Feb 14, 2020 10:35 am
- [Solved] Help me fix "=+SUMIF(... ;" >TODAY()-30" ;...)"
-
- Bult-In Functions and named Cells
by CaveDweller » Fri Feb 14, 2020 3:12 am
- 2 Replies
- 263 Views
- Last post by Zizi64
Fri Feb 14, 2020 7:53 am
- Bult-In Functions and named Cells
-
- Need a method of getting a number that's circular
by RusselB » Thu Feb 13, 2020 6:06 am - 6 Replies
- 419 Views
- Last post by RusselB
Thu Feb 13, 2020 6:38 pm
- Need a method of getting a number that's circular
-
- Setting up some default values when saving document
by stonexman » Wed Feb 12, 2020 3:30 pm - 4 Replies
- 347 Views
- Last post by stonexman
Wed Feb 12, 2020 11:58 pm
- Setting up some default values when saving document
-
- File Names and Location
by quarkrad » Tue Feb 11, 2020 7:03 pm
- 4 Replies
- 458 Views
- Last post by jrkrideau
Wed Feb 12, 2020 4:06 am
- File Names and Location
-
- Solved
by lexmailman » Tue Feb 11, 2020 11:09 pm - 1 Replies
- 232 Views
- Last post by Villeroy
Tue Feb 11, 2020 11:16 pm
- Solved
-
- Setting Custom Line Widths
by justinmreina » Mon Feb 03, 2020 6:15 pm
- 3 Replies
- 348 Views
- Last post by justinmreina
Tue Feb 11, 2020 4:25 pm
- Setting Custom Line Widths
-
- [SOLVED] Conditional array sum?
by Ssronica » Mon Feb 10, 2020 5:46 pm
- 6 Replies
- 407 Views
- Last post by Lupp
Mon Feb 10, 2020 10:57 pm
- [SOLVED] Conditional array sum?
-
- [Solved] Create chart with baseline and data readings
by TiaVali » Sun Feb 09, 2020 9:48 pm
- 9 Replies
- 580 Views
- Last post by jrkrideau
Mon Feb 10, 2020 2:44 pm
- [Solved] Create chart with baseline and data readings
-
- [Solved] Need help sorting and counting...
by withnail » Sun Feb 09, 2020 12:46 am
- 2 Replies
- 399 Views
- Last post by withnail
Sun Feb 09, 2020 4:18 pm
- [Solved] Need help sorting and counting...
-
- Find box in tool bar cause OpenOffice to crash
by ausbane » Sat Feb 08, 2020 6:02 pm - 3 Replies
- 357 Views
- Last post by RoryOF
Sat Feb 08, 2020 6:35 pm
- Find box in tool bar cause OpenOffice to crash
-
- [Solved] Cells formatted as currency display as percentage
by crusader » Sat Feb 08, 2020 7:45 am
- 4 Replies
- 462 Views
- Last post by crusader
Sat Feb 08, 2020 3:59 pm
- [Solved] Cells formatted as currency display as percentage
-
- [Solved] Control F "Find" feature not working
by ausbane » Sat Feb 08, 2020 12:06 am - 2 Replies
- 313 Views
- Last post by ausbane
Sat Feb 08, 2020 2:09 am
- [Solved] Control F "Find" feature not working
-
- [Solved] Date formatting problem in Calc
by Baasha » Fri Feb 07, 2020 3:14 am - 5 Replies
- 1102 Views
- Last post by Lupp
Fri Feb 07, 2020 9:46 pm
- [Solved] Date formatting problem in Calc
-
- [Solved] SAVE a SOLVER model in Calc
by gpgrego » Fri Jan 31, 2020 4:54 pm
- 17 Replies
- 1421 Views
- Last post by gpgrego
Thu Feb 06, 2020 4:31 pm
- [Solved] SAVE a SOLVER model in Calc
-
- Open .qif in OpenOffice Calc 4.1.7/Windows 10
by BJK » Wed Feb 05, 2020 10:00 pm - 2 Replies
- 302 Views
- Last post by Zizi64
Thu Feb 06, 2020 7:30 am
- Open .qif in OpenOffice Calc 4.1.7/Windows 10
-
- [Solved] 360 degree problem
by marty-0750 » Wed Feb 05, 2020 4:14 pm - 2 Replies
- 270 Views
- Last post by marty-0750
Thu Feb 06, 2020 4:56 am
- [Solved] 360 degree problem
-
- Conditional Formatting / Reference
by A.Fish » Wed Feb 05, 2020 7:38 pm - 5 Replies
- 419 Views
- Last post by Villeroy
Thu Feb 06, 2020 12:36 am
- Conditional Formatting / Reference
-
- Calc crashes when copying entire column
by SteveBros » Sun Feb 02, 2020 11:50 pm
- 13 Replies
- 716 Views
- Last post by RoryOF
Wed Feb 05, 2020 11:20 am
- Calc crashes when copying entire column
-
- [Solved] Database unable to open
by wharroff » Tue Feb 04, 2020 3:36 am - 6 Replies
- 517 Views
- Last post by Hagar Delest
Tue Feb 04, 2020 11:36 pm
- [Solved] Database unable to open
-
- Autorecover just restored an old version
by JackHolmes » Tue Feb 04, 2020 11:25 am - 1 Replies
- 201 Views
- Last post by RoryOF
Tue Feb 04, 2020 11:42 am
- Autorecover just restored an old version
-
- [Solved] Cannot delete duplicate line of spreadsheet
by SharonAnne » Tue Feb 04, 2020 9:29 am
- 2 Replies
- 222 Views
- Last post by Villeroy
Tue Feb 04, 2020 11:11 am
- [Solved] Cannot delete duplicate line of spreadsheet
-
- [Solved] Change Legend
by ehj69a5 » Sun Feb 02, 2020 11:39 pm
- 15 Replies
- 868 Views
- Last post by ehj69a5
Mon Feb 03, 2020 11:55 pm
- [Solved] Change Legend
-
- [Solved] Change cells to hyperlinks
by trogne » Sat Feb 01, 2020 4:42 pm
- 17 Replies
- 919 Views
- Last post by Zizi64
Mon Feb 03, 2020 11:19 pm
- [Solved] Change cells to hyperlinks
-
- [Solved] Transposing Columns to Rows?
by Dink Martini » Tue Jan 28, 2020 10:06 pm
- 4 Replies
- 451 Views
- Last post by Dink Martini
Mon Feb 03, 2020 8:04 pm
- [Solved] Transposing Columns to Rows?
-
- [Solved] Copying a formula with CONCATENATE
by rjmnook@gmail.com » Mon Feb 03, 2020 4:59 pm - 2 Replies
- 216 Views
- Last post by rjmnook@gmail.com
Mon Feb 03, 2020 5:08 pm
- [Solved] Copying a formula with CONCATENATE
-
- [Solved] Sharing a spreadsheet
by judgesinel » Sun Feb 02, 2020 12:46 pm
- 5 Replies
- 499 Views
- Last post by judgesinel
Mon Feb 03, 2020 4:03 pm
- [Solved] Sharing a spreadsheet
-
- [Solved] Average every n-th column based on condition
by Andyfc » Sun Feb 02, 2020 1:48 pm
- 4 Replies
- 341 Views
- Last post by Lupp
Mon Feb 03, 2020 3:40 pm
- [Solved] Average every n-th column based on condition
-
- [Solved] Align text vertically
by robp » Thu Jan 30, 2020 12:53 pm
- 8 Replies
- 617 Views
- Last post by robp
Mon Feb 03, 2020 3:21 pm
- [Solved] Align text vertically
-
- Archived file can not be edited and saved
by toucango » Fri Jan 24, 2020 6:36 pm
- 27 Replies
- 1303 Views
- Last post by Zizi64
Mon Feb 03, 2020 7:49 am
- Archived file can not be edited and saved
-
- [Solved] Is it possible to have a cell be a date picker?
by hypGnosis » Sun Feb 02, 2020 4:28 am
- 4 Replies
- 687 Views
- Last post by Zizi64
Sun Feb 02, 2020 1:27 pm
- [Solved] Is it possible to have a cell be a date picker?
-
- [Solved] Protect Cell Formatting
by JamesSmith32 » Sun Feb 02, 2020 4:50 am - 2 Replies
- 231 Views
- Last post by JamesSmith32
Sun Feb 02, 2020 11:11 am
- [Solved] Protect Cell Formatting
-
- [Solved] Plot two graphs against each other
by Athiril » Fri Jan 31, 2020 11:44 am
- 2 Replies
- 281 Views
- Last post by FJCC
Fri Jan 31, 2020 4:24 pm
- [Solved] Plot two graphs against each other
-
- [Solved] Leap year problems with sum and averages
by gmccollam » Fri Jan 31, 2020 2:55 am
- 4 Replies
- 333 Views
- Last post by gmccollam
Fri Jan 31, 2020 4:35 am
- [Solved] Leap year problems with sum and averages
-
- Help with the formula
by duh123 » Thu Jan 30, 2020 10:40 am - 3 Replies
- 334 Views
- Last post by Zizi64
Thu Jan 30, 2020 4:16 pm
- Help with the formula
-
- Making a multiple tables on a single sheet extension?
by hugoromor » Wed Jan 29, 2020 1:25 am - 4 Replies
- 372 Views
- Last post by Villeroy
Wed Jan 29, 2020 4:18 pm
- Making a multiple tables on a single sheet extension?
-
- Pivot table as formula - possible - how
by Albireo » Mon Jan 27, 2020 12:17 pm - 7 Replies
- 561 Views
- Last post by Villeroy
Wed Jan 29, 2020 12:40 pm
- Pivot table as formula - possible - how
-
- [Solved] Display cell content of selectable column
by morphingstar » Sat Jan 25, 2020 12:01 am - 2 Replies
- 304 Views
- Last post by morphingstar
Wed Jan 29, 2020 7:13 am
- [Solved] Display cell content of selectable column
-
- [Solved] Count Fridays in current month
by killerpip4 » Tue Jan 28, 2020 5:53 pm - 1 Replies
- 251 Views
- Last post by MrProgrammer
Tue Jan 28, 2020 6:31 pm
- [Solved] Count Fridays in current month
-
- [Solved] Sort four columns, match same data?
by MaCro » Tue Jan 07, 2020 4:14 pm
- 2 Replies
- 420 Views
- Last post by MaCro
Tue Jan 28, 2020 4:31 pm
- [Solved] Sort four columns, match same data?
-
- [Solved] #VALUE! result when adding 7 days to a date
by tricia.young » Fri Jan 17, 2020 5:24 pm - 3 Replies
- 344 Views
- Last post by tricia.young
Tue Jan 28, 2020 3:22 pm
- [Solved] #VALUE! result when adding 7 days to a date
-
- [Solved] Entering info in cell
by transistor » Fri Jan 24, 2020 10:34 pm - 3 Replies
- 346 Views
- Last post by RusselB
Mon Jan 27, 2020 9:37 pm
- [Solved] Entering info in cell
-
- [Solved] AutoFilter Header Disapears
by jdhamilton » Sun Jan 26, 2020 9:47 pm
- 2 Replies
- 284 Views
- Last post by jdhamilton
Mon Jan 27, 2020 12:05 am
- [Solved] AutoFilter Header Disapears
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
|