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: 27535
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 28974
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 25524
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 64291 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- Templates: a dedicated repository in the OpenOffice web site
by Hagar Delest » Sun Feb 01, 2009 12:25 am - 6 Replies
- 34687 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- [Solved] Extract alphabet chars from alphanumeric text
by cub001 » Tue Jun 25, 2019 7:08 pm - 5 Replies
- 83 Views
- Last post by cub001
Tue Jun 25, 2019 11:55 pm
- [Solved] Extract alphabet chars from alphanumeric text
-
- [Solved] Date fill with blank rows
by manoman » Mon Jun 24, 2019 11:57 pm - 2 Replies
- 69 Views
- Last post by manoman
Tue Jun 25, 2019 5:11 pm
- [Solved] Date fill with blank rows
-
- Populating cell data from multiple sheets
by Renevaine » Tue Jun 25, 2019 9:41 am - 1 Replies
- 62 Views
- Last post by Villeroy
Tue Jun 25, 2019 11:28 am
- Populating cell data from multiple sheets
-
- Euro to US Dollar Conversion
by 3ME » Thu Aug 12, 2010 6:10 am
- 27 Replies
- 13037 Views
- Last post by Villeroy
Tue Jun 25, 2019 11:18 am
- Euro to US Dollar Conversion
-
- Creating IF/Else Formula - Extract Root Domain
by cristopher » Tue Jun 25, 2019 5:58 am
- 6 Replies
- 85 Views
- Last post by robleyd
Tue Jun 25, 2019 9:05 am
- Creating IF/Else Formula - Extract Root Domain
-
- How do I define groups and prioritize them?
by 3graygirls » Fri Jun 21, 2019 9:47 pm - 13 Replies
- 230 Views
- Last post by robleyd
Tue Jun 25, 2019 3:26 am
- How do I define groups and prioritize them?
-
- Unable to load csv file - Mojibake
by pnycooking » Mon Jun 24, 2019 5:06 pm
- 2 Replies
- 66 Views
- Last post by Villeroy
Mon Jun 24, 2019 5:50 pm
- Unable to load csv file - Mojibake
-
- Does not allow to open a spreadsheet
by bhargav27 » Mon Jun 24, 2019 3:04 pm - 3 Replies
- 70 Views
- Last post by RoryOF
Mon Jun 24, 2019 4:46 pm
- Does not allow to open a spreadsheet
-
- How to order rows into groups and filter them
by withnail » Sun Jun 23, 2019 6:42 pm
- 4 Replies
- 114 Views
- Last post by withnail
Mon Jun 24, 2019 12:05 pm
- How to order rows into groups and filter them
-
- [Solved] It always opens the Text Import
by hwrdmltn » Sun Jun 23, 2019 5:43 pm - 4 Replies
- 103 Views
- Last post by RoryOF
Mon Jun 24, 2019 6:51 am
- [Solved] It always opens the Text Import
-
- Multiply cell value in one column if there is a specific
by dontcareiii » Sun Jun 23, 2019 3:01 pm - 4 Replies
- 112 Views
- Last post by robleyd
Mon Jun 24, 2019 5:16 am
- Multiply cell value in one column if there is a specific
-
- [Solved] Pasting hyperlinks – Font problem
by CraigG58 » Sun Jun 23, 2019 5:25 pm - 2 Replies
- 61 Views
- Last post by CraigG58
Mon Jun 24, 2019 12:11 am
- [Solved] Pasting hyperlinks – Font problem
-
- Converting text to date
by jgriffs@comcast.net » Sun Jun 23, 2019 3:39 am - 4 Replies
- 106 Views
- Last post by MrProgrammer
Sun Jun 23, 2019 8:02 pm
- Converting text to date
-
- [Solved] Operator for value lower than negative value?
by withnail » Sat Jun 22, 2019 8:04 pm - 9 Replies
- 214 Views
- Last post by withnail
Sun Jun 23, 2019 11:38 am
- [Solved] Operator for value lower than negative value?
-
- Adjusting Row Height
by TTO » Sat Jun 22, 2019 4:46 pm - 4 Replies
- 102 Views
- Last post by RusselB
Sun Jun 23, 2019 10:48 am
- Adjusting Row Height
-
- How do I get spreadsheet to open in a larger window?
by Robincm » Fri Jan 25, 2019 11:27 am - 2 Replies
- 204 Views
- Last post by Robincm
Sun Jun 23, 2019 8:45 am
- How do I get spreadsheet to open in a larger window?
-
- [Solved] Highlight today cell
by arfa2 » Sat Jun 22, 2019 11:01 pm
- 2 Replies
- 81 Views
- Last post by arfa2
Sun Jun 23, 2019 2:16 am
- [Solved] Highlight today cell
-
- Merging Tables with Different Columns, based on 1 column's d
by dantastic » Tue Jun 18, 2019 9:19 am
- 2 Replies
- 131 Views
- Last post by MrProgrammer
Fri Jun 21, 2019 11:18 pm
- Merging Tables with Different Columns, based on 1 column's d
-
- The contents are gone!
by White_Luigi » Fri Jun 21, 2019 1:49 pm
- 7 Replies
- 132 Views
- Last post by RoryOF
Fri Jun 21, 2019 3:13 pm
- The contents are gone!
-
- [Solved] Swapping Columns and then syncing other columns
by Eb Dunn » Tue Jun 18, 2019 4:31 pm
- 21 Replies
- 312 Views
- Last post by robleyd
Fri Jun 21, 2019 1:44 am
- [Solved] Swapping Columns and then syncing other columns
-
- [Solved] How do I copy rows using a formula to a sheet?
by 3graygirls » Wed Jun 19, 2019 4:03 am
- 6 Replies
- 161 Views
- Last post by 3graygirls
Thu Jun 20, 2019 10:48 pm
- [Solved] How do I copy rows using a formula to a sheet?
-
- Cal/OpenOffice crashing: Save, Bad Allocation, various
by Imul » Tue Jun 18, 2019 2:48 pm - 10 Replies
- 166 Views
- Last post by fxguthri
Thu Jun 20, 2019 5:30 pm
- Cal/OpenOffice crashing: Save, Bad Allocation, various
-
- [Solved] Count last 3 cells and put multiple formula in cell
by withnail » Mon Jun 17, 2019 7:13 pm
- 5 Replies
- 184 Views
- Last post by withnail
Thu Jun 20, 2019 3:31 pm
- [Solved] Count last 3 cells and put multiple formula in cell
-
- Collect cell data and display in new cell.
by pherriot » Thu Jun 06, 2019 9:30 am
- 12 Replies
- 383 Views
- Last post by Lupp
Thu Jun 20, 2019 12:24 pm
- Collect cell data and display in new cell.
-
- [Solved] Formula for Paroli/Parlay betting system
by withnail » Sun Jun 16, 2019 4:39 pm
- 8 Replies
- 270 Views
- Last post by withnail
Thu Jun 20, 2019 9:40 am
- [Solved] Formula for Paroli/Parlay betting system
-
- [Solved] Specific spreadsheet; print preview shows blank
by videobruce » Wed Jun 19, 2019 9:15 pm
- 4 Replies
- 124 Views
- Last post by videobruce
Wed Jun 19, 2019 9:47 pm
- [Solved] Specific spreadsheet; print preview shows blank
-
- Text in input field not appearing in cells
by ph118446@sky.com » Wed Jun 19, 2019 11:51 am - 3 Replies
- 110 Views
- Last post by Hagar Delest
Wed Jun 19, 2019 8:54 pm
- Text in input field not appearing in cells
-
- Pages scrolling way to fast
by 2BadRic » Tue Jun 18, 2019 10:57 pm - 3 Replies
- 136 Views
- Last post by RusselB
Wed Jun 19, 2019 1:14 am
- Pages scrolling way to fast
-
- How to find 6 lowest positive numbers that do not equal 0
by carmsbody » Tue Jun 18, 2019 9:35 am
- 8 Replies
- 161 Views
- Last post by Villeroy
Tue Jun 18, 2019 1:22 pm
- How to find 6 lowest positive numbers that do not equal 0
-
- How to find and replace alt+enter data in cell
by dennlv » Tue Jun 18, 2019 5:22 am - 2 Replies
- 101 Views
- Last post by Villeroy
Tue Jun 18, 2019 11:04 am
- How to find and replace alt+enter data in cell
-
- How do I put a loop execution limit
by Viviany Souza » Mon Jun 17, 2019 8:19 pm - 4 Replies
- 132 Views
- Last post by Lupp
Mon Jun 17, 2019 9:47 pm
- How do I put a loop execution limit
-
- LOOKUP function in Array or Table
by spinifex » Mon Jun 17, 2019 4:46 am - 4 Replies
- 148 Views
- Last post by Villeroy
Mon Jun 17, 2019 8:58 am
- LOOKUP function in Array or Table
-
- [SOLVED] Colums data moved after saving and reopening ?
by ozstar » Sun Jun 16, 2019 2:02 am - 5 Replies
- 156 Views
- Last post by ozstar
Mon Jun 17, 2019 2:41 am
- [SOLVED] Colums data moved after saving and reopening ?
-
- Reading Background Color Information
by Valareos » Sat Jun 15, 2019 3:52 pm - 4 Replies
- 160 Views
- Last post by Lupp
Sun Jun 16, 2019 11:24 pm
- Reading Background Color Information
-
- How to calculate in a period: Years, Months and days.
by Juanchio88 » Thu Jan 26, 2017 6:56 pm
- 24 Replies
- 3579 Views
- Last post by Villeroy
Sun Jun 16, 2019 10:56 am
- How to calculate in a period: Years, Months and days.
-
- Saved .ods file
by dmhill22 » Sun Jun 16, 2019 3:58 am - 1 Replies
- 95 Views
- Last post by Zizi64
Sun Jun 16, 2019 5:59 am
- Saved .ods file
-
- Calc ignoring page breaks when pasting
by Fallynn » Sat Jun 15, 2019 5:14 pm - 3 Replies
- 157 Views
- Last post by Zizi64
Sun Jun 16, 2019 5:51 am
- Calc ignoring page breaks when pasting
-
- Seeking Spreadsheet Commands to Summarize Entries
by McBeardy » Sat Jun 15, 2019 4:38 pm
- 3 Replies
- 163 Views
- Last post by robleyd
Sun Jun 16, 2019 3:38 am
- Seeking Spreadsheet Commands to Summarize Entries
-
- How to enlarge the tab sheet?
by femto » Wed Jun 12, 2019 3:39 pm - 2 Replies
- 170 Views
- Last post by MrProgrammer
Sat Jun 15, 2019 8:50 pm
- How to enlarge the tab sheet?
-
- [Solved] Size ???
by fikey » Sat Jun 15, 2019 5:10 pm - 3 Replies
- 123 Views
- Last post by RoryOF
Sat Jun 15, 2019 5:33 pm
- [Solved] Size ???
-
- [Solved] Add numbers in the same cell
by Kacem » Thu Aug 20, 2015 8:47 am
- 23 Replies
- 1793 Views
- Last post by Key WiteWolf
Sat Jun 15, 2019 4:24 pm
- [Solved] Add numbers in the same cell
-
- Calc Error Message
by dickartale » Wed Jun 12, 2019 11:08 pm - 13 Replies
- 286 Views
- Last post by dickartale
Sat Jun 15, 2019 3:30 pm
- Calc Error Message
-
- [Solved] Cell Format when linking to external data
by gurkand » Wed Jun 12, 2019 9:27 pm
- 11 Replies
- 287 Views
- Last post by gurkand
Fri Jun 14, 2019 5:24 pm
- [Solved] Cell Format when linking to external data
-
- [Solved] Show hidden columns
by muttiallen » Sat Feb 16, 2008 9:58 pm - 9 Replies
- 34732 Views
- Last post by RoryOF
Fri Jun 14, 2019 9:46 am
- [Solved] Show hidden columns
-
- [Solved] Copy a cell exactly as is to an adjacent cell
by dsaldridge » Thu Jun 13, 2019 4:58 pm - 2 Replies
- 141 Views
- Last post by dsaldridge
Fri Jun 14, 2019 1:55 am
- [Solved] Copy a cell exactly as is to an adjacent cell
-
- [Solved] Search Value in a double column
by Marck_97 » Sat Jun 08, 2019 6:50 pm
- 5 Replies
- 263 Views
- Last post by Marck_97
Thu Jun 13, 2019 9:13 am
- [Solved] Search Value in a double column
-
- csv Text Import Dialog Not Opening
by tbuford634 » Thu Jun 13, 2019 8:38 am - 1 Replies
- 101 Views
- Last post by robleyd
Thu Jun 13, 2019 9:00 am
- csv Text Import Dialog Not Opening
-
- Removing text from a graph
by bandit73 » Wed Jun 12, 2019 5:02 pm - 2 Replies
- 149 Views
- Last post by Zizi64
Thu Jun 13, 2019 6:53 am
- Removing text from a graph
-
- INDEX MATCH with Sorting
by Azshara » Tue Jun 11, 2019 1:54 pm
- 11 Replies
- 321 Views
- Last post by Villeroy
Wed Jun 12, 2019 12:55 pm
- INDEX MATCH with Sorting
Who is online
Users browsing this forum: Google [Bot] and 17 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
|