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: 26137
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 27174
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 23701
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.5 now available
by RoryOF » Thu Oct 19, 2017 6:08 pm - 2 Replies
- 141611 Views
- Last post by Hagar Delest
Wed Jan 10, 2018 10:56 pm
- Apache OpenOffice 4.1.5 now available
-
- 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
- 29889 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Force Calc to Use 100% CPU
by 3VA41570 » Fri Aug 18, 2017 2:21 am - 13 Replies
- 1681 Views
- Last post by Villeroy
Thu Nov 15, 2018 8:53 pm
- Force Calc to Use 100% CPU
-
- Plot bug with column selection
by Carter7Gindenv » Thu Nov 15, 2018 3:41 pm - 1 Replies
- 19 Views
- Last post by FJCC
Thu Nov 15, 2018 6:55 pm
- Plot bug with column selection
-
- Styles for text & numbers in same column
1, 2
by Skompy » Wed Oct 10, 2018 4:32 pm
- 37 Replies
- 1539 Views
- Last post by Lupp
Thu Nov 15, 2018 5:45 pm
- Styles for text & numbers in same column
-
- Sum the multiple of 2 columns without creating a 3rd column
by stevenm » Wed Nov 14, 2018 2:08 pm
- 3 Replies
- 90 Views
- Last post by stevenm
Thu Nov 15, 2018 2:47 pm
- Sum the multiple of 2 columns without creating a 3rd column
-
- Get address of value in range
by Deever » Wed Nov 14, 2018 8:59 pm
- 3 Replies
- 82 Views
- Last post by Lupp
Thu Nov 15, 2018 2:25 pm
- Get address of value in range
-
- Import from NotePad
by Wilvin » Thu Nov 15, 2018 9:57 am
- 2 Replies
- 39 Views
- Last post by John_Ha
Thu Nov 15, 2018 1:10 pm
- Import from NotePad
-
- [Solved]Function SUBSTITUTE not working
by philipps » Wed Nov 14, 2018 7:56 pm
- 4 Replies
- 94 Views
- Last post by Zizi64
Wed Nov 14, 2018 11:59 pm
- [Solved]Function SUBSTITUTE not working
-
- Data exceeds column width
by neilhmurphy » Wed Nov 14, 2018 3:50 am - 1 Replies
- 94 Views
- Last post by RusselB
Wed Nov 14, 2018 5:38 am
- Data exceeds column width
-
- Grab Handle size
by THEBookMan » Tue Nov 13, 2018 5:51 pm - 0 Replies
- 68 Views
- Last post by THEBookMan
Tue Nov 13, 2018 5:51 pm
- Grab Handle size
-
- Spreadsheet prints blank except for red letters. Baffling.
by yfrigi » Tue Nov 13, 2018 5:16 am - 1 Replies
- 108 Views
- Last post by soby
Tue Nov 13, 2018 8:53 am
- Spreadsheet prints blank except for red letters. Baffling.
-
- Pivot table and text set of data
by mic8 » Mon Nov 12, 2018 4:07 pm - 2 Replies
- 110 Views
- Last post by MrProgrammer
Mon Nov 12, 2018 4:50 pm
- Pivot table and text set of data
-
- [Solved] Conditional Formats Applied in a Macro
by darkfire.shadows » Thu Apr 23, 2009 5:34 pm - 7 Replies
- 1268 Views
- Last post by valimaties
Mon Nov 12, 2018 2:26 pm
- [Solved] Conditional Formats Applied in a Macro
-
- Results of CountIf as Ratios or Percentages
by bluhawk19 » Mon Nov 12, 2018 12:38 pm - 1 Replies
- 76 Views
- Last post by Lupp
Mon Nov 12, 2018 1:04 pm
- Results of CountIf as Ratios or Percentages
-
- [Solved] Formula help with budget sheet
by sajnoor » Fri Nov 09, 2018 3:03 pm
- 13 Replies
- 243 Views
- Last post by sajnoor
Mon Nov 12, 2018 12:11 pm
- [Solved] Formula help with budget sheet
-
- Auto-sorting data (with colors) based on other sheet.
by DariusGalaxyz » Sun Nov 11, 2018 3:58 pm
- 9 Replies
- 178 Views
- Last post by Lupp
Sun Nov 11, 2018 7:36 pm
- Auto-sorting data (with colors) based on other sheet.
-
- [Solved] Work schedule
by RusselB » Sat Nov 10, 2018 5:34 am
- 4 Replies
- 196 Views
- Last post by njhub
Sun Nov 11, 2018 5:41 am
- [Solved] Work schedule
-
- [SOLVED] Identify which the row in one column to display
by michaelgingras » Thu Nov 01, 2018 10:37 pm
- 7 Replies
- 370 Views
- Last post by MrProgrammer
Sun Nov 11, 2018 12:25 am
- [SOLVED] Identify which the row in one column to display
-
- OpenOffice Calc hangs during auto save
by Nick Hope » Sat Nov 10, 2018 3:55 pm - 4 Replies
- 123 Views
- Last post by RoryOF
Sat Nov 10, 2018 8:29 pm
- OpenOffice Calc hangs during auto save
-
- Calc Incompatibility with Excel When Editing Sheets
by delbue » Fri Nov 09, 2018 1:08 pm - 3 Replies
- 136 Views
- Last post by Zizi64
Fri Nov 09, 2018 4:24 pm
- Calc Incompatibility with Excel When Editing Sheets
-
- [Solved] Mixing concatenate and if statements?
by adventurehouse » Tue Nov 06, 2018 2:14 am
- 15 Replies
- 386 Views
- Last post by robleyd
Fri Nov 09, 2018 11:28 am
- [Solved] Mixing concatenate and if statements?
-
- It doesnt add up!
by burneyboy » Thu Nov 08, 2018 10:43 pm
- 9 Replies
- 214 Views
- Last post by Zizi64
Fri Nov 09, 2018 8:05 am
- It doesnt add up!
-
- [Solved] 0-100 Scale, +30 -30
by BTH456 » Mon Nov 05, 2018 11:37 pm
- 4 Replies
- 209 Views
- Last post by BTH456
Wed Nov 07, 2018 11:32 pm
- [Solved] 0-100 Scale, +30 -30
-
- Cannot restore user profile + Cannot record Macro
by Stockman1 » Tue Nov 06, 2018 12:46 pm - 1 Replies
- 128 Views
- Last post by Stockman1
Tue Nov 06, 2018 1:03 pm
- Cannot restore user profile + Cannot record Macro
-
- [Solved] Conditional Formatting
by No3Jacks » Tue Nov 06, 2018 12:04 am
- 2 Replies
- 144 Views
- Last post by No3Jacks
Tue Nov 06, 2018 4:57 am
- [Solved] Conditional Formatting
-
- Changing the AutoInput Selection List
by BigDogs » Sat Oct 27, 2018 3:58 pm - 5 Replies
- 330 Views
- Last post by db22
Sun Nov 04, 2018 3:49 pm
- Changing the AutoInput Selection List
-
- [Solved] Cannot Reference a Cell in Another Sheet
by lfriii » Mon Sep 18, 2017 9:59 pm
- 11 Replies
- 2584 Views
- Last post by jimmy_521
Sat Nov 03, 2018 10:33 am
- [Solved] Cannot Reference a Cell in Another Sheet
-
- Migrate MS Excel file to Calc ods
by julie1368 » Fri Nov 02, 2018 3:54 pm
- 3 Replies
- 172 Views
- Last post by njhub
Fri Nov 02, 2018 7:50 pm
- Migrate MS Excel file to Calc ods
-
- More efficient regex search
by DynV » Mon Oct 29, 2018 8:19 pm
- 10 Replies
- 462 Views
- Last post by DynV
Fri Nov 02, 2018 6:52 pm
- More efficient regex search
-
- Row insertion and crash
by rhpark » Fri Nov 02, 2018 12:44 pm
- 6 Replies
- 222 Views
- Last post by RoryOF
Fri Nov 02, 2018 6:30 pm
- Row insertion and crash
-
- Cell Protection via Conditional Formatting?
by hawkinst » Sat Mar 22, 2008 7:33 am
- 21 Replies
- 9267 Views
- Last post by Villeroy
Fri Nov 02, 2018 12:01 am
- Cell Protection via Conditional Formatting?
-
- [Solved] Stock Market Functions LO Calc Extension
1, 2 by crusader » Sun Jun 04, 2017 6:12 am
- 53 Replies
- 22020 Views
- Last post by hacketm
Thu Nov 01, 2018 7:34 pm
- [Solved] Stock Market Functions LO Calc Extension
-
- [Solved] Is an interactive worksheet possible ?
by cephas » Thu Nov 01, 2018 12:52 am - 2 Replies
- 182 Views
- Last post by cephas
Thu Nov 01, 2018 5:04 am
- [Solved] Is an interactive worksheet possible ?
-
- VLOOKUP for multiple criteriums
by ana.tvrdeic » Wed Oct 31, 2018 2:09 pm - 2 Replies
- 203 Views
- Last post by RusselB
Thu Nov 01, 2018 12:15 am
- VLOOKUP for multiple criteriums
-
- Calc and windows updates
by plcsparky » Wed Oct 24, 2018 10:32 am - 6 Replies
- 365 Views
- Last post by plcsparky
Wed Oct 31, 2018 7:37 am
- Calc and windows updates
-
- [Solved] Copied sheet has Gray Background - Calc
by bob1966tb » Fri Jan 11, 2013 6:24 pm - 3 Replies
- 2178 Views
- Last post by annekaelber
Tue Oct 30, 2018 11:45 pm
- [Solved] Copied sheet has Gray Background - Calc
-
- [Solved] Corrupted .ods Calc files
1, 2by Prometheus76 » Fri Oct 12, 2018 10:43 pm - 38 Replies
- 1361 Views
- Last post by Prometheus76
Tue Oct 30, 2018 10:04 pm
- [Solved] Corrupted .ods Calc files
-
- Copying filtered data into new sheet and formatting
by keneso » Mon Oct 29, 2018 2:30 pm
- 10 Replies
- 369 Views
- Last post by Villeroy
Tue Oct 30, 2018 7:42 pm
- Copying filtered data into new sheet and formatting
-
- Using "NIL" as a value
by KenF » Sun Oct 28, 2018 9:04 pm
- 6 Replies
- 332 Views
- Last post by Villeroy
Tue Oct 30, 2018 7:26 pm
- Using "NIL" as a value
-
- Spread sheet not adding right (rounding?)
by fatmommacat » Mon Nov 21, 2011 4:36 am - 11 Replies
- 1082 Views
- Last post by keme
Tue Oct 30, 2018 4:15 pm
- Spread sheet not adding right (rounding?)
-
- [SOLVED] multiple IF solution.
by yadepvi » Mon Oct 29, 2018 9:21 am
- 4 Replies
- 282 Views
- Last post by yadepvi
Mon Oct 29, 2018 11:45 pm
- [SOLVED] multiple IF solution.
-
- [Solved] Finding matches, skip non-relevants and sort
by mrssec » Fri Aug 31, 2018 5:32 pm
- 11 Replies
- 893 Views
- Last post by mrssec
Mon Oct 29, 2018 10:59 am
- [Solved] Finding matches, skip non-relevants and sort
-
- Facebook does not accept my csv file
by gaabee » Mon Sep 24, 2018 11:31 am
- 6 Replies
- 534 Views
- Last post by keme
Mon Oct 29, 2018 9:17 am
- Facebook does not accept my csv file
-
- CVS Mime Type
by shotsy247 » Fri Oct 26, 2018 4:28 am
- 22 Replies
- 686 Views
- Last post by RoryOF
Sun Oct 28, 2018 2:33 pm
- CVS Mime Type
-
- Add ID Numbers to Matching Names.
by GG907 » Sun Oct 28, 2018 3:20 am - 4 Replies
- 279 Views
- Last post by Lupp
Sun Oct 28, 2018 11:48 am
- Add ID Numbers to Matching Names.
-
- [Solved] Bank of America exports only in Chinese
by willincalif » Sat Oct 27, 2018 3:54 am
- 3 Replies
- 261 Views
- Last post by willincalif
Sat Oct 27, 2018 7:40 pm
- [Solved] Bank of America exports only in Chinese
-
- Count Values across Sheets
by JacobAxiom » Fri Oct 26, 2018 5:23 pm
- 9 Replies
- 375 Views
- Last post by Villeroy
Sat Oct 27, 2018 2:08 pm
- Count Values across Sheets
-
- [Issue] Marching Ants
by rocky082259 » Thu Jan 03, 2008 7:40 pm - 7 Replies
- 3057 Views
- Last post by aaban894
Sat Oct 27, 2018 12:34 pm
- [Issue] Marching Ants
-
- [Solved] Why text is pasting on hidden page?
by kumarkutti » Fri Oct 26, 2018 6:30 pm - 1 Replies
- 204 Views
- Last post by FJCC
Fri Oct 26, 2018 8:24 pm
- [Solved] Why text is pasting on hidden page?
-
- [Solved] Calc errors start with year 2000
by CaliRay » Fri Oct 26, 2018 1:19 am
- 4 Replies
- 275 Views
- Last post by Lupp
Fri Oct 26, 2018 1:43 pm
- [Solved] Calc errors start with year 2000
Who is online
Users browsing this forum: FJCC, Google [Bot] and 37 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
|