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: 34691
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 36682
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 33637
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 9934 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Find Col B's Num If Its Col A Is All 0
by raykt » Sun Nov 08, 2020 1:14 pm
- 2 Replies
- 189 Views
- Last post by raykt
Sun Nov 08, 2020 3:19 pm
- [Solved] Find Col B's Num If Its Col A Is All 0
-
- Solver tool does not find optimal solution
by meeranair2020 » Wed Nov 04, 2020 7:32 pm
- 5 Replies
- 414 Views
- Last post by lader
Sat Nov 07, 2020 6:12 pm
- Solver tool does not find optimal solution
-
- [Solved] Calculate the hours between two dates
by XsiSec » Fri Nov 06, 2020 12:40 pm
- 5 Replies
- 241 Views
- Last post by Villeroy
Fri Nov 06, 2020 9:03 pm
- [Solved] Calculate the hours between two dates
-
- Calc - right click - format - font = hour wait
by ironfistx » Fri Nov 06, 2020 4:01 am - 3 Replies
- 197 Views
- Last post by RoryOF
Fri Nov 06, 2020 6:53 pm
- Calc - right click - format - font = hour wait
-
- DBF file getting auto populated
by bl4ckh4t » Thu Nov 05, 2020 9:59 pm - 1 Replies
- 280 Views
- Last post by Villeroy
Thu Nov 05, 2020 11:34 pm
- DBF file getting auto populated
-
- Help with conditional formatting
by mxtown » Wed Nov 04, 2020 11:34 pm - 5 Replies
- 237 Views
- Last post by mxtown
Thu Nov 05, 2020 5:42 pm
- Help with conditional formatting
-
- [Solved] Some images become corrupted on importing
by AuSolomon » Thu Nov 05, 2020 7:04 am
- 2 Replies
- 197 Views
- Last post by AuSolomon
Thu Nov 05, 2020 9:39 am
- [Solved] Some images become corrupted on importing
-
- [Solved] Simplify a table lookup formula
by Zul » Wed Nov 04, 2020 7:29 pm
- 4 Replies
- 253 Views
- Last post by Zul
Thu Nov 05, 2020 6:40 am
- [Solved] Simplify a table lookup formula
-
- [Solved] How to return value with 2 or 3 condition?
by Zul » Tue Nov 03, 2020 1:49 pm
- 4 Replies
- 267 Views
- Last post by Zul
Thu Nov 05, 2020 2:13 am
- [Solved] How to return value with 2 or 3 condition?
-
- [SOLVED Run macro when cell value changes-without a msg box?
by imadumby » Wed Nov 04, 2020 2:12 am - 4 Replies
- 288 Views
- Last post by imadumby
Wed Nov 04, 2020 11:29 pm
- [SOLVED Run macro when cell value changes-without a msg box?
-
- [Solved] Sum does not include values from new rows
by dagmyh » Tue Nov 03, 2020 3:51 pm - 4 Replies
- 207 Views
- Last post by MrProgrammer
Tue Nov 03, 2020 5:23 pm
- [Solved] Sum does not include values from new rows
-
- [Solved] StarDesktop.loadComponentFromURL and TLS version
by khanlon » Mon Nov 02, 2020 8:28 pm - 3 Replies
- 236 Views
- Last post by khanlon
Tue Nov 03, 2020 3:50 am
- [Solved] StarDesktop.loadComponentFromURL and TLS version
-
- [Solved] Undesired change to character case after entry
by jbl1954 » Fri Jan 17, 2020 5:58 pm - 5 Replies
- 434 Views
- Last post by Gazita
Mon Nov 02, 2020 7:26 pm
- [Solved] Undesired change to character case after entry
-
- [Solved] Caps won't hold
by Munchkin53 » Thu Sep 24, 2020 9:11 pm - 2 Replies
- 350 Views
- Last post by Gazita
Mon Nov 02, 2020 7:12 pm
- [Solved] Caps won't hold
-
- Corrupted file?
by kelly_najo » Mon Nov 02, 2020 8:06 am - 3 Replies
- 191 Views
- Last post by robleyd
Mon Nov 02, 2020 9:06 am
- Corrupted file?
-
- [Solved] Simple Sortable List
by DayPopper » Sun Nov 01, 2020 1:21 pm
- 4 Replies
- 329 Views
- Last post by Bill
Mon Nov 02, 2020 4:06 am
- [Solved] Simple Sortable List
-
- [Solved] Link Graph Axis Title to Cell Value
by Bloodknot » Sat Oct 31, 2020 4:04 pm
- 6 Replies
- 391 Views
- Last post by Villeroy
Sun Nov 01, 2020 3:07 pm
- [Solved] Link Graph Axis Title to Cell Value
-
- [Solved] How to put slash in specific cell
by mickstereen » Sat Oct 31, 2020 6:38 pm
- 3 Replies
- 187 Views
- Last post by mickstereen
Sat Oct 31, 2020 8:44 pm
- [Solved] How to put slash in specific cell
-
- [Solved] Combine select from list with other conditions
by Baggins » Sat Oct 31, 2020 5:15 pm - 2 Replies
- 170 Views
- Last post by Baggins
Sat Oct 31, 2020 6:19 pm
- [Solved] Combine select from list with other conditions
-
- [Solved] Dynamically insert rows or columns from calculation
by sysadm » Thu Oct 29, 2020 6:52 am
- 6 Replies
- 380 Views
- Last post by sysadm
Sat Oct 31, 2020 3:24 am
- [Solved] Dynamically insert rows or columns from calculation
-
- Pass exiftool's output to Calc cell
by danjde » Thu Oct 29, 2020 3:04 pm - 4 Replies
- 320 Views
- Last post by danjde
Fri Oct 30, 2020 1:25 pm
- Pass exiftool's output to Calc cell
-
- Flickering text when pressing "F2"
by AppleJuice » Fri Oct 30, 2020 7:49 am - 0 Replies
- 150 Views
- Last post by AppleJuice
Fri Oct 30, 2020 7:49 am
- Flickering text when pressing "F2"
-
- [Solved] Get text from table, using specified key for lookup
by pleides » Fri Oct 30, 2020 1:59 am - 3 Replies
- 240 Views
- Last post by MrProgrammer
Fri Oct 30, 2020 4:14 am
- [Solved] Get text from table, using specified key for lookup
-
- [Solved] Always open CSV files as UTF-8 English?
by collector dave » Sun Oct 25, 2020 5:12 am - 10 Replies
- 856 Views
- Last post by collector dave
Thu Oct 29, 2020 5:44 am
- [Solved] Always open CSV files as UTF-8 English?
-
- [Solved] Sort a column based on list order
by ssar17 » Wed Oct 28, 2020 3:01 am
- 3 Replies
- 362 Views
- Last post by MrProgrammer
Wed Oct 28, 2020 5:11 pm
- [Solved] Sort a column based on list order
-
- [Solved] Syles & Formatting & Conditional Formatting - ✔
by ssar17 » Wed Oct 28, 2020 3:10 am
- 4 Replies
- 380 Views
- Last post by MrProgrammer
Wed Oct 28, 2020 4:49 pm
- [Solved] Syles & Formatting & Conditional Formatting - ✔
-
- [SOLVED] Display cell containing the lowest number
by cephas » Mon Oct 26, 2020 8:25 am - 7 Replies
- 471 Views
- Last post by cephas
Tue Oct 27, 2020 11:59 pm
- [SOLVED] Display cell containing the lowest number
-
- [Solved] Why won’t this spreadsheet JUST sort...
by imadumby » Sat Oct 24, 2020 6:26 pm
- 9 Replies
- 563 Views
- Last post by imadumby
Tue Oct 27, 2020 11:00 pm
- [Solved] Why won’t this spreadsheet JUST sort...
-
- [Solved] Adding Percentage
by Andoo » Tue Oct 27, 2020 1:42 pm - 2 Replies
- 282 Views
- Last post by Andoo
Tue Oct 27, 2020 8:52 pm
- [Solved] Adding Percentage
-
- A retrieval out of 4 x 700 records of national data-sets
by sayhello » Sat Oct 24, 2020 5:36 pm
- 5 Replies
- 474 Views
- Last post by sayhello
Mon Oct 26, 2020 3:18 pm
- A retrieval out of 4 x 700 records of national data-sets
-
- Install Calc by itself on Windows Tablet?
by spikels6 » Mon Oct 26, 2020 2:30 pm - 2 Replies
- 246 Views
- Last post by spikels6
Mon Oct 26, 2020 2:52 pm
- Install Calc by itself on Windows Tablet?
-
- Printing the spreadsheet grid in Calc does not seem to work
by Kate G. » Sat Oct 24, 2020 6:02 pm
- 8 Replies
- 481 Views
- Last post by Zizi64
Sun Oct 25, 2020 7:52 pm
- Printing the spreadsheet grid in Calc does not seem to work
-
- [Solved] Shortcut for importing MANY fixed-width files?
by steve-o » Tue Oct 13, 2020 11:47 pm - 7 Replies
- 453 Views
- Last post by steve-o
Sun Oct 25, 2020 7:15 pm
- [Solved] Shortcut for importing MANY fixed-width files?
-
- [Solved] how to delete a row in spreadsheet
by bernieb123 » Sun Oct 25, 2020 1:44 am - 2 Replies
- 247 Views
- Last post by bernieb123
Sun Oct 25, 2020 2:07 am
- [Solved] how to delete a row in spreadsheet
-
- [Solved] Page numbers
by Powderdog » Sun Oct 25, 2020 12:38 am - 2 Replies
- 223 Views
- Last post by Powderdog
Sun Oct 25, 2020 1:53 am
- [Solved] Page numbers
-
- [Solved] Scatter chart Inoperable
by jyohe » Sat Oct 24, 2020 3:30 am
- 7 Replies
- 358 Views
- Last post by jyohe
Sun Oct 25, 2020 12:02 am
- [Solved] Scatter chart Inoperable
-
- [Solved] Formula not working #VALUE!
by Hardrockbaer » Thu Oct 08, 2020 9:55 am - 13 Replies
- 730 Views
- Last post by MrProgrammer
Sat Oct 24, 2020 5:57 pm
- [Solved] Formula not working #VALUE!
-
- Cash flow Spreadsheets
by admanone2002m » Fri Oct 23, 2020 12:17 am - 2 Replies
- 328 Views
- Last post by John_Ha
Fri Oct 23, 2020 3:53 pm
- Cash flow Spreadsheets
-
- Linebreak as column separator?
by fiona87 » Wed Oct 21, 2020 7:38 pm
- 5 Replies
- 353 Views
- Last post by Zizi64
Thu Oct 22, 2020 9:09 am
- Linebreak as column separator?
-
- Calc for Voice Over business operations
by DeLaVega1944 » Wed Oct 21, 2020 8:12 pm - 2 Replies
- 223 Views
- Last post by RusselB
Wed Oct 21, 2020 8:29 pm
- Calc for Voice Over business operations
-
- Maths help needed
by mshowe » Wed Oct 21, 2020 6:34 pm - 1 Replies
- 189 Views
- Last post by Villeroy
Wed Oct 21, 2020 7:50 pm
- Maths help needed
-
- Sheet Tab in Calc too small in Windows
by ellgee » Tue Oct 20, 2020 6:19 pm - 1 Replies
- 217 Views
- Last post by Bill
Tue Oct 20, 2020 10:59 pm
- Sheet Tab in Calc too small in Windows
-
- Goal: Freeze row 1; Result: I froze column A
by kevinmcfeely » Mon Oct 19, 2020 6:11 pm - 2 Replies
- 230 Views
- Last post by Bill
Tue Oct 20, 2020 10:30 pm
- Goal: Freeze row 1; Result: I froze column A
-
- Stopping Calc from changing uppercase to lowercase
by TJOnline » Mon Oct 19, 2020 11:23 pm - 2 Replies
- 216 Views
- Last post by robleyd
Tue Oct 20, 2020 1:18 am
- Stopping Calc from changing uppercase to lowercase
-
- Insert a number in a cell
by danno » Mon Oct 19, 2020 12:49 pm
- 3 Replies
- 247 Views
- Last post by danno
Mon Oct 19, 2020 3:40 pm
- Insert a number in a cell
-
- Need help with complex formula
by Esch » Mon Oct 19, 2020 3:32 am
- 4 Replies
- 341 Views
- Last post by Villeroy
Mon Oct 19, 2020 2:48 pm
- Need help with complex formula
-
- Print preview is blank
by danno » Mon Oct 19, 2020 12:47 am
- 6 Replies
- 305 Views
- Last post by danno
Mon Oct 19, 2020 12:44 pm
- Print preview is blank
-
- [Solved] Move multiple entire rows
by stacie » Sun Oct 18, 2020 12:25 am - 8 Replies
- 421 Views
- Last post by stacie
Sun Oct 18, 2020 9:20 pm
- [Solved] Move multiple entire rows
-
- [Solved] Equation doesn't work in one cell, works in others
by stacie » Sun Oct 18, 2020 5:36 pm - 2 Replies
- 236 Views
- Last post by stacie
Sun Oct 18, 2020 5:54 pm
- [Solved] Equation doesn't work in one cell, works in others
-
- [Solved] Recover hyperlink
by kenppy » Sat Oct 17, 2020 9:20 pm
- 1 Replies
- 173 Views
- Last post by Lupp
Sun Oct 18, 2020 12:15 am
- [Solved] Recover hyperlink
Who is online
Users browsing this forum: eeigor and 22 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
|