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: 31203
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 33029
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 29882
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 115392 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Operation started with an invalid parameter
by mallomar » Fri Feb 28, 2020 9:35 am - 1 Replies
- 341 Views
- Last post by mallomar
Fri Feb 28, 2020 1:54 pm
- [Solved] Operation started with an invalid parameter
-
- Numbers saved as values in error, how to converts back
by kenkreger » Thu Feb 27, 2020 11:49 pm - 1 Replies
- 232 Views
- Last post by Villeroy
Fri Feb 28, 2020 12:50 am
- Numbers saved as values in error, how to converts back
-
- [Solved...ish] Export/Import Question
by Inservio Letum » Thu Feb 13, 2020 5:00 pm
- 8 Replies
- 577 Views
- Last post by jrkrideau
Wed Feb 26, 2020 4:53 pm
- [Solved...ish] Export/Import Question
-
- [Solved] Need formula to enter data every 28 days
by Clarky64 » Tue Feb 25, 2020 2:50 pm
- 5 Replies
- 415 Views
- Last post by RusselB
Wed Feb 26, 2020 3:37 am
- [Solved] Need formula to enter data every 28 days
-
- [Solved] Error in simple sum
by Clarky64 » Tue Feb 25, 2020 1:37 pm
- 2 Replies
- 278 Views
- Last post by Clarky64
Tue Feb 25, 2020 8:20 pm
- [Solved] Error in simple sum
-
- Lost part of my spread sheet
by pganey » Mon Feb 24, 2020 9:18 pm - 4 Replies
- 390 Views
- Last post by RoryOF
Tue Feb 25, 2020 12:34 pm
- Lost part of my spread sheet
-
- [Solved] Recovery file
by qvaqsha » Fri Feb 21, 2020 9:35 am
- 8 Replies
- 527 Views
- Last post by qvaqsha
Tue Feb 25, 2020 4:07 am
- [Solved] Recovery file
-
- ods file keeps opening through csv importer
by allhopeisgone91 » Mon Feb 24, 2020 9:39 pm - 5 Replies
- 400 Views
- Last post by RoryOF
Mon Feb 24, 2020 10:43 pm
- ods file keeps opening through csv importer
-
- [Solved] #VALUE! Error
by Sherwood » Mon Feb 24, 2020 5:25 pm
- 2 Replies
- 267 Views
- Last post by Sherwood
Mon Feb 24, 2020 5:56 pm
- [Solved] #VALUE! Error
-
- [Solved] opening existing calc sheet issue
by rvgypsy » Sun Feb 23, 2020 3:55 pm - 3 Replies
- 381 Views
- Last post by rvgypsy
Sun Feb 23, 2020 7:42 pm
- [Solved] opening existing calc sheet issue
-
- Can't write a needed formula in my checkbook sheet
by jhoward1950 » Sun Feb 23, 2020 1:38 pm
- 1 Replies
- 327 Views
- Last post by Villeroy
Sun Feb 23, 2020 3:39 pm
- Can't write a needed formula in my checkbook sheet
-
- .ods file has gone wonky
by Sated » Sat Feb 22, 2020 1:31 am - 1 Replies
- 267 Views
- Last post by FJCC
Sat Feb 22, 2020 3:33 am
- .ods file has gone wonky
-
- Delete all cells that have a specific word in them
by maxbb » Fri Feb 21, 2020 7:24 am - 6 Replies
- 326 Views
- Last post by Villeroy
Fri Feb 21, 2020 9:21 am
- Delete all cells that have a specific word in them
-
- [Solved] Arrow keys move page instead of changing cells
by Ripcord » Fri Feb 21, 2020 3:08 am - 2 Replies
- 281 Views
- Last post by Ripcord
Fri Feb 21, 2020 6:19 am
- [Solved] Arrow keys move page instead of changing cells
-
- [Solved] Data Bars with OpenOffice Calc?
by Jay_Dee » Sun Feb 16, 2020 9:46 am - 14 Replies
- 800 Views
- Last post by jrkrideau
Fri Feb 21, 2020 4:48 am
- [Solved] Data Bars with OpenOffice Calc?
-
- [Solved] Query and store results from multiple spreadsheets
by peace2 » Sat Feb 15, 2020 9:00 pm
- 26 Replies
- 1029 Views
- Last post by Villeroy
Wed Feb 19, 2020 11:18 pm
- [Solved] Query and store results from multiple spreadsheets
-
- [Solved] Which cell has the most characters? formula?
by dawidek990 » Wed Feb 19, 2020 5:09 pm
- 6 Replies
- 329 Views
- Last post by dawidek990
Wed Feb 19, 2020 9:55 pm
- [Solved] Which cell has the most characters? formula?
-
- [Solved] Error reading data from the internet
by go2visions » Thu Nov 03, 2016 2:29 pm - 4 Replies
- 2763 Views
- Last post by Chainmailguy
Wed Feb 19, 2020 5:16 pm
- [Solved] Error reading data from the internet
-
- "Constants" in a spreadsheet
by j4nd3r53n » Wed Feb 19, 2020 3:39 pm
- 2 Replies
- 254 Views
- Last post by FJCC
Wed Feb 19, 2020 4:32 pm
- "Constants" in a spreadsheet
-
- Adding preference shortcut to toolbar
by orionp3 » Sun Feb 16, 2020 7:42 am - 2 Replies
- 290 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
- 354 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
- 529 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
- 443 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
- 232 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
- 264 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
- 291 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
- 368 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
- 236 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
- 371 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
- 282 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
- 399 Views
- Last post by jrkrideau
Wed Feb 12, 2020 4:06 am
- File Names and Location
-
- Locking choices for cells
by lexmailman » Tue Feb 11, 2020 11:09 pm - 1 Replies
- 211 Views
- Last post by Villeroy
Tue Feb 11, 2020 11:16 pm
- Locking choices for cells
-
- Setting Custom Line Widths
by justinmreina » Mon Feb 03, 2020 6:15 pm
- 3 Replies
- 317 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
- 379 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
- 540 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
- 376 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
- 321 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
- 406 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
- 266 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
- 807 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
- 1194 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
- 264 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
- 239 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
- 360 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
- 651 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
- 427 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
- 182 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
- 194 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
- 705 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
- 779 Views
- Last post by Zizi64
Mon Feb 03, 2020 11:19 pm
- [Solved] Change cells to hyperlinks
Who is online
Users browsing this forum: Garawa, RPG and 16 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
|