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: 21796
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 21847
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 18362
-
-
- 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
- 14843 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Problem with data in tables converted from Excel
by dizzy7 » Sun Sep 11, 2016 5:26 pm
- 6 Replies
- 122 Views
- Last post by MrProgrammer
Mon Sep 26, 2016 6:38 pm
- Problem with data in tables converted from Excel
-
- [Solved] IF Function - Using cell range
by amyhart420 » Sun Sep 25, 2016 12:46 am - 3 Replies
- 93 Views
- Last post by RusselB
Mon Sep 26, 2016 4:06 pm
- [Solved] IF Function - Using cell range
-
- Lookup functions
by tabster » Mon Sep 26, 2016 11:25 am - 2 Replies
- 41 Views
- Last post by tabster
Mon Sep 26, 2016 3:52 pm
- Lookup functions
-
- How to link to external data csv/xml?
by penetrator » Mon Sep 26, 2016 2:40 pm - 0 Replies
- 20 Views
- Last post by penetrator
Mon Sep 26, 2016 2:40 pm
- How to link to external data csv/xml?
-
- The arrow of the 'Comment' box moves to cell A1
by Ozi Ian » Mon Sep 26, 2016 9:16 am
- 0 Replies
- 15 Views
- Last post by Ozi Ian
Mon Sep 26, 2016 9:16 am
- The arrow of the 'Comment' box moves to cell A1
-
- Printing
by Ed Milliron » Mon Sep 26, 2016 1:52 am - 2 Replies
- 50 Views
- Last post by RusselB
Mon Sep 26, 2016 6:05 am
- Printing
-
- [Solved] Split a Column of numbers evenly across
by Officefish » Sun Sep 18, 2016 8:35 pm
- 6 Replies
- 149 Views
- Last post by Officefish
Sun Sep 25, 2016 9:19 pm
- [Solved] Split a Column of numbers evenly across
-
- Nifty download
by selvanraj » Fri Sep 23, 2016 8:48 pm
- 9 Replies
- 183 Views
- Last post by Zizi64
Sun Sep 25, 2016 6:05 pm
- Nifty download
-
- Conditional Formatting
by Donovan Frasure » Sun Sep 25, 2016 12:41 am - 5 Replies
- 93 Views
- Last post by Lupp
Sun Sep 25, 2016 2:30 pm
- Conditional Formatting
-
- Dropdown lists on/off reacting on eachother
by Niek » Sun Sep 25, 2016 12:43 am
- 3 Replies
- 73 Views
- Last post by Lupp
Sun Sep 25, 2016 2:18 pm
- Dropdown lists on/off reacting on eachother
-
- [Solved] Countif react with 2 Columns
by Niek » Thu Sep 22, 2016 9:55 pm
- 7 Replies
- 118 Views
- Last post by Niek
Sun Sep 25, 2016 12:11 am
- [Solved] Countif react with 2 Columns
-
- Analysis ToolPack in AOO
by MathFool » Sat Sep 24, 2016 9:33 am - 4 Replies
- 85 Views
- Last post by Villeroy
Sat Sep 24, 2016 7:49 pm
- Analysis ToolPack in AOO
-
- vlookup n/a on text strings
by degarb » Thu Sep 22, 2016 4:05 pm - 5 Replies
- 86 Views
- Last post by Zizi64
Sat Sep 24, 2016 4:21 pm
- vlookup n/a on text strings
-
- xlsx file with password protection
by glowworm » Fri Sep 23, 2016 11:00 pm - 1 Replies
- 53 Views
- Last post by RusselB
Sat Sep 24, 2016 1:04 am
- xlsx file with password protection
-
- [Solved] CVS import OOo adds an apostrophe to value
by Jay.guretsky » Thu Sep 22, 2016 8:09 pm - 6 Replies
- 100 Views
- Last post by Jay.guretsky
Fri Sep 23, 2016 9:50 pm
- [Solved] CVS import OOo adds an apostrophe to value
-
- How to find a number within a number
by deutscheparts » Fri Sep 23, 2016 5:53 pm - 3 Replies
- 57 Views
- Last post by Lupp
Fri Sep 23, 2016 7:16 pm
- How to find a number within a number
-
- Conditional Format Hyperlink
by Kerithlan » Fri Sep 23, 2016 2:54 am
- 3 Replies
- 93 Views
- Last post by Villeroy
Fri Sep 23, 2016 6:06 pm
- Conditional Format Hyperlink
-
- [Solved] Why is this flagged as an error?
by neilhmurphy » Tue Sep 06, 2016 2:34 am
- 4 Replies
- 133 Views
- Last post by james7fl
Fri Sep 23, 2016 4:25 am
- [Solved] Why is this flagged as an error?
-
- Why can't set the a1:a20 to be number?
by pengsir » Thu Sep 22, 2016 10:09 am
- 3 Replies
- 82 Views
- Last post by MrProgrammer
Fri Sep 23, 2016 1:46 am
- Why can't set the a1:a20 to be number?
-
- [Solved] Visible tekst count as number
by Niek » Wed Sep 21, 2016 10:12 pm - 3 Replies
- 83 Views
- Last post by Niek
Thu Sep 22, 2016 9:31 pm
- [Solved] Visible tekst count as number
-
- [Solved] Multiple lookup values index, small vlookup
by rune@maagensen.dk » Thu Sep 22, 2016 2:18 pm
- 2 Replies
- 70 Views
- Last post by Lupp
Thu Sep 22, 2016 4:14 pm
- [Solved] Multiple lookup values index, small vlookup
-
- [Solved] Aggregate data from DB export into logical columns
by deadpandodo » Wed Sep 21, 2016 3:37 pm
- 2 Replies
- 92 Views
- Last post by deadpandodo
Thu Sep 22, 2016 3:30 pm
- [Solved] Aggregate data from DB export into logical columns
-
- [Solved] XSLT Export Filter produces empty XML tags
by JacoSk » Thu Sep 22, 2016 2:54 pm - 0 Replies
- 29 Views
- Last post by JacoSk
Thu Sep 22, 2016 2:54 pm
- [Solved] XSLT Export Filter produces empty XML tags
-
- Histogram of strings
by pixellone » Thu Sep 22, 2016 11:39 am
- 3 Replies
- 55 Views
- Last post by keme
Thu Sep 22, 2016 1:28 pm
- Histogram of strings
-
- [Solved] Show all results of VLOOKUP in a Dropdown
by JacoSk » Tue Sep 20, 2016 3:43 pm
- 6 Replies
- 119 Views
- Last post by JacoSk
Thu Sep 22, 2016 12:29 pm
- [Solved] Show all results of VLOOKUP in a Dropdown
-
- [Solved] Group values into columns with headers from another
by JacoSk » Wed Sep 21, 2016 3:02 pm
- 2 Replies
- 94 Views
- Last post by JacoSk
Thu Sep 22, 2016 11:37 am
- [Solved] Group values into columns with headers from another
-
- Date format changes after cell edit
by andrew59 » Tue Sep 20, 2016 9:49 am
- 10 Replies
- 196 Views
- Last post by Villeroy
Thu Sep 22, 2016 8:39 am
- Date format changes after cell edit
-
- Scheduling
by griggsrick » Tue Sep 20, 2016 2:29 am - 4 Replies
- 97 Views
- Last post by Villeroy
Tue Sep 20, 2016 7:57 pm
- Scheduling
-
- [Solved] Calc Not Responding,Hanging,Crashing Windows 10 Pro
by AreaMan2016 » Mon Sep 19, 2016 8:30 pm - 6 Replies
- 112 Views
- Last post by AreaMan2016
Tue Sep 20, 2016 7:23 pm
- [Solved] Calc Not Responding,Hanging,Crashing Windows 10 Pro
-
- [Solved] Percentages multiplying problem
by Puma1 » Tue Sep 20, 2016 4:30 am - 3 Replies
- 84 Views
- Last post by Puma1
Tue Sep 20, 2016 4:05 pm
- [Solved] Percentages multiplying problem
-
- [Solved] Specify worksheet in XSLT export filter
by JacoSk » Tue Sep 20, 2016 12:17 pm - 2 Replies
- 53 Views
- Last post by JacoSk
Tue Sep 20, 2016 3:45 pm
- [Solved] Specify worksheet in XSLT export filter
-
- [Solved] Adding and subtracting
by oldgeezett » Tue Sep 20, 2016 9:45 am - 6 Replies
- 82 Views
- Last post by oldgeezett
Tue Sep 20, 2016 12:07 pm
- [Solved] Adding and subtracting
-
- [Solved] Excluding empty cells from a range in data>Validity
by Michaud79 » Tue Sep 20, 2016 9:15 am - 1 Replies
- 46 Views
- Last post by Michaud79
Tue Sep 20, 2016 9:30 am
- [Solved] Excluding empty cells from a range in data>Validity
-
- [Solved] Does OpenOffice handle the extra Rows & Columns?
by RVBuson » Tue Sep 20, 2016 4:51 am
- 4 Replies
- 89 Views
- Last post by RVBuson
Tue Sep 20, 2016 7:07 am
- [Solved] Does OpenOffice handle the extra Rows & Columns?
-
- Convert data and make template
by MeltedMoon » Mon Sep 19, 2016 10:51 am
- 6 Replies
- 96 Views
- Last post by coray80
Tue Sep 20, 2016 5:46 am
- Convert data and make template
-
- Drop down box / table look up
by lcm2104 » Mon Sep 19, 2016 2:05 pm
- 3 Replies
- 85 Views
- Last post by RusselB
Mon Sep 19, 2016 10:35 pm
- Drop down box / table look up
-
- [Solved] Filtering data range within multiple columns
by ebeck1 » Mon Sep 19, 2016 4:56 pm - 4 Replies
- 88 Views
- Last post by ebeck1
Mon Sep 19, 2016 10:11 pm
- [Solved] Filtering data range within multiple columns
-
- OOBasic help me please I am desperate
by brandonmm1 » Mon Sep 19, 2016 6:14 am
- 7 Replies
- 136 Views
- Last post by brandonmm1
Mon Sep 19, 2016 7:32 pm
- OOBasic help me please I am desperate
-
- [Solved] Fill Dropdown from Database?
by JacoSk » Mon Sep 19, 2016 11:24 am - 7 Replies
- 84 Views
- Last post by Villeroy
Mon Sep 19, 2016 4:37 pm
- [Solved] Fill Dropdown from Database?
-
- [Solved] Get MyDocuments folder programatically
by pajkec2031 » Mon Sep 19, 2016 2:43 pm - 2 Replies
- 46 Views
- Last post by pajkec2031
Mon Sep 19, 2016 3:39 pm
- [Solved] Get MyDocuments folder programatically
-
- Store Strings in new column if condition is met
by Piktetos » Mon Sep 19, 2016 1:26 pm
- 2 Replies
- 51 Views
- Last post by Villeroy
Mon Sep 19, 2016 2:06 pm
- Store Strings in new column if condition is met
-
- [Solved] Negative numbers not correctly summed
by felixsefton » Sun Sep 18, 2016 4:56 am
- 20 Replies
- 203 Views
- Last post by felixsefton
Mon Sep 19, 2016 10:41 am
- [Solved] Negative numbers not correctly summed
-
- [Solved] 2017 displaying 2016 MM/YY; DDE function influenced
by eddieinOK » Sat Aug 27, 2016 9:07 pm - 14 Replies
- 263 Views
- Last post by Villeroy
Sun Sep 18, 2016 7:14 pm
- [Solved] 2017 displaying 2016 MM/YY; DDE function influenced
-
- Data than Sort re-assigned the dates for movies/TV shows
by php111 » Sat Sep 17, 2016 10:03 pm
- 16 Replies
- 176 Views
- Last post by Bill
Sun Sep 18, 2016 5:40 pm
- Data than Sort re-assigned the dates for movies/TV shows
-
- [Solved] New Spreadsheet Cells too small
by insconsultant » Sun Sep 18, 2016 12:28 am
- 2 Replies
- 73 Views
- Last post by insconsultant
Sun Sep 18, 2016 4:44 pm
- [Solved] New Spreadsheet Cells too small
-
- Calc doesn't save language-specific signs in .xls files
by StarshipJake » Tue Sep 06, 2016 8:18 pm
- 7 Replies
- 211 Views
- Last post by keme
Sun Sep 18, 2016 2:37 pm
- Calc doesn't save language-specific signs in .xls files
-
- [Solved] What is ###
by i75Dave » Sat Sep 17, 2016 10:43 pm - 2 Replies
- 64 Views
- Last post by i75Dave
Sat Sep 17, 2016 11:48 pm
- [Solved] What is ###
-
- [Solved] Work schedule format issues
by Arlans26 » Sat Sep 17, 2016 7:48 pm - 3 Replies
- 76 Views
- Last post by Arlans26
Sat Sep 17, 2016 11:47 pm
- [Solved] Work schedule format issues
-
- Cut/Copy + Paste only works on borders, not content
by MariamHabach » Sat Sep 17, 2016 6:01 pm - 7 Replies
- 89 Views
- Last post by Bill
Sat Sep 17, 2016 8:39 pm
- Cut/Copy + Paste only works on borders, not content
Who is online
Users browsing this forum: Google [Bot], MrProgrammer and 44 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
|