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: 26452
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 27566
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 24139
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 20287 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
- 31460 Views
- Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
- Templates: a dedicated repository in the OpenOffice web site
-
- Lower VS Upper Case in VLOOKUP
by ptownpapa » Tue Jan 22, 2019 1:03 am - 4 Replies
- 69 Views
- Last post by Lupp
Tue Jan 22, 2019 12:34 pm
- Lower VS Upper Case in VLOOKUP
-
- Damaged .ods file
by OPenOffice 1 » Tue Jan 22, 2019 8:37 am - 4 Replies
- 32 Views
- Last post by OPenOffice 1
Tue Jan 22, 2019 9:15 am
- Damaged .ods file
-
- Too less number of rows.
by gorinw10 » Mon Jan 21, 2019 10:23 pm - 3 Replies
- 81 Views
- Last post by gorinw10
Tue Jan 22, 2019 3:40 am
- Too less number of rows.
-
- Copying cell entries
by IanP » Mon Jan 21, 2019 10:59 am
- 4 Replies
- 88 Views
- Last post by IanP
Tue Jan 22, 2019 12:59 am
- Copying cell entries
-
- Array with empty cell
by britto » Mon Jan 21, 2019 4:44 pm - 2 Replies
- 68 Views
- Last post by mikele
Mon Jan 21, 2019 5:25 pm
- Array with empty cell
-
- [Solved] Value selected from IF() won't work
by gahelton1 » Mon Jan 21, 2019 7:31 am - 4 Replies
- 75 Views
- Last post by MrProgrammer
Mon Jan 21, 2019 5:23 pm
- [Solved] Value selected from IF() won't work
-
- [Solved] Replace '\n' in a multi line in a Cell
by gutee » Mon Jan 21, 2019 5:12 am - 7 Replies
- 97 Views
- Last post by Villeroy
Mon Jan 21, 2019 4:22 pm
- [Solved] Replace '\n' in a multi line in a Cell
-
- What logic function to use?
by DennyNet » Mon Jan 21, 2019 12:31 am - 3 Replies
- 106 Views
- Last post by RusselB
Mon Jan 21, 2019 2:11 am
- What logic function to use?
-
- Cells to Watch for Negatives
by NotLeftBehind » Sun Jan 20, 2019 7:13 pm - 2 Replies
- 61 Views
- Last post by RoryOF
Sun Jan 20, 2019 7:29 pm
- Cells to Watch for Negatives
-
- How to multiply column A by Column B.
by louispaul » Fri Jan 18, 2019 10:36 pm - 7 Replies
- 147 Views
- Last post by RusselB
Sun Jan 20, 2019 7:09 pm
- How to multiply column A by Column B.
-
- Change False?
by dawidek990 » Sat Jan 19, 2019 2:56 pm - 10 Replies
- 175 Views
- Last post by RusselB
Sun Jan 20, 2019 5:37 pm
- Change False?
-
- [Solved] Sum values in a column based on values in another
by peltto7 » Thu Dec 06, 2018 8:47 am
- 5 Replies
- 218 Views
- Last post by FJCC
Sun Jan 20, 2019 4:12 am
- [Solved] Sum values in a column based on values in another
-
- [Issue] Formatting data series on Stock chart
by TropicWill » Wed Jan 16, 2019 10:06 pm
- 6 Replies
- 171 Views
- Last post by TropicWill
Sat Jan 19, 2019 10:45 pm
- [Issue] Formatting data series on Stock chart
-
- [Solved] VLOOKUP not retrieving info
by TalonsPryde » Sat Jan 19, 2019 7:52 am - 5 Replies
- 118 Views
- Last post by RusselB
Sat Jan 19, 2019 10:38 pm
- [Solved] VLOOKUP not retrieving info
-
- [Solved] Entering trig formula
by crabmann » Thu Jan 17, 2019 11:31 pm
- 6 Replies
- 161 Views
- Last post by crabmann
Sat Jan 19, 2019 8:49 pm
- [Solved] Entering trig formula
-
- Crash Calc graphics
by rbappelbaum » Wed Jan 09, 2019 12:37 am - 7 Replies
- 180 Views
- Last post by Zizi64
Sat Jan 19, 2019 6:25 pm
- Crash Calc graphics
-
- Printing Difficulties with Spreadsheets
by Ahmpizzedoff » Fri Jan 18, 2019 8:24 pm - 1 Replies
- 79 Views
- Last post by Zizi64
Sat Jan 19, 2019 10:04 am
- Printing Difficulties with Spreadsheets
-
- How to prevent a graph from drawing empty cells?
by Angry Ashley » Fri Jan 18, 2019 12:02 pm
- 2 Replies
- 78 Views
- Last post by Angry Ashley
Fri Jan 18, 2019 8:22 pm
- How to prevent a graph from drawing empty cells?
-
- Search a Cell based on the content and return the position
by gutee » Fri Jan 18, 2019 9:24 am
- 4 Replies
- 96 Views
- Last post by Lupp
Fri Jan 18, 2019 3:43 pm
- Search a Cell based on the content and return the position
-
- Filter deleting #N/D
by dawidek990 » Wed Jan 16, 2019 3:23 pm - 5 Replies
- 120 Views
- Last post by Lupp
Fri Jan 18, 2019 1:56 pm
- Filter deleting #N/D
-
- Problem I Have
by fjwag3 » Wed Jan 16, 2019 8:12 pm - 7 Replies
- 206 Views
- Last post by keme
Fri Jan 18, 2019 10:44 am
- Problem I Have
-
- Calc 4.1.6 Freeze (Win 7)
by chrshea » Wed Jan 16, 2019 9:40 pm - 2 Replies
- 77 Views
- Last post by chrshea
Wed Jan 16, 2019 11:48 pm
- Calc 4.1.6 Freeze (Win 7)
-
- [Solved] Count adjacent cells that meet specific criteria
by taras_frolov » Wed Jan 16, 2019 4:51 pm - 3 Replies
- 114 Views
- Last post by taras_frolov
Wed Jan 16, 2019 10:47 pm
- [Solved] Count adjacent cells that meet specific criteria
-
- [Solved] CSV imports as text rather than numbers
by jackrcook » Tue Jan 15, 2019 3:55 am
- 9 Replies
- 200 Views
- Last post by jackrcook
Wed Jan 16, 2019 8:06 pm
- [Solved] CSV imports as text rather than numbers
-
- [Solved] File Owner
by RonOO » Fri Jun 02, 2017 6:36 am - 4 Replies
- 1238 Views
- Last post by lmo46
Wed Jan 16, 2019 7:58 pm
- [Solved] File Owner
-
- [Solved] Checkbox and IF function problem
by kmnbc13 » Wed Jan 16, 2019 4:16 am - 2 Replies
- 122 Views
- Last post by kmnbc13
Wed Jan 16, 2019 4:47 am
- [Solved] Checkbox and IF function problem
-
- [Solved] Cell display of function results
by rtaylor@ntin.net » Wed Jan 16, 2019 1:09 am - 4 Replies
- 112 Views
- Last post by robleyd
Wed Jan 16, 2019 2:33 am
- [Solved] Cell display of function results
-
- Calc keeps crashing, lots of lost work
by willsanderson1 » Fri Jan 11, 2019 7:50 pm - 4 Replies
- 189 Views
- Last post by RoryOF
Tue Jan 15, 2019 6:25 pm
- Calc keeps crashing, lots of lost work
-
- Computer shut down, corrupted my database file
by Neisner » Tue Jan 15, 2019 5:58 am - 4 Replies
- 93 Views
- Last post by John_Ha
Tue Jan 15, 2019 1:48 pm
- Computer shut down, corrupted my database file
-
- [Solved] I want to understand how can i do that
by appoffice » Mon Jan 14, 2019 7:45 pm - 12 Replies
- 262 Views
- Last post by appoffice
Tue Jan 15, 2019 1:47 pm
- [Solved] I want to understand how can i do that
-
- [Solved] DDE links break when emailed
by badassbiologist » Thu Jan 03, 2019 11:32 pm - 21 Replies
- 353 Views
- Last post by badassbiologist
Mon Jan 14, 2019 11:21 pm
- [Solved] DDE links break when emailed
-
- Retaining Window Size in MacOS Mojave
by spock999 » Mon Jan 14, 2019 9:56 pm - 0 Replies
- 70 Views
- Last post by spock999
Mon Jan 14, 2019 9:56 pm
- Retaining Window Size in MacOS Mojave
-
- .ods spreadsheet gets bold on network sharing
by RW9275 » Sun Jan 13, 2019 1:10 am
- 14 Replies
- 319 Views
- Last post by RW9275
Mon Jan 14, 2019 7:48 pm
- .ods spreadsheet gets bold on network sharing
-
- [Solved] Date Calculation
by Papa_P » Sun Jan 13, 2019 6:34 pm - 6 Replies
- 169 Views
- Last post by Villeroy
Sun Jan 13, 2019 9:28 pm
- [Solved] Date Calculation
-
- [Solved] Multiple filters conflict with each other
by SteveBros » Sun Jan 13, 2019 9:32 am - 4 Replies
- 179 Views
- Last post by SteveBros
Sun Jan 13, 2019 9:24 pm
- [Solved] Multiple filters conflict with each other
-
- Search similar cell.
by dawidek990 » Sat Jan 12, 2019 11:27 pm
- 3 Replies
- 158 Views
- Last post by Villeroy
Sun Jan 13, 2019 4:00 pm
- Search similar cell.
-
- Trouble copying formulas
by Honorable_newbie » Sun Jan 13, 2019 1:58 am - 5 Replies
- 155 Views
- Last post by RusselB
Sun Jan 13, 2019 8:41 am
- Trouble copying formulas
-
- Separate last word?
by dawidek990 » Thu Jan 10, 2019 6:36 pm - 2 Replies
- 158 Views
- Last post by dawidek990
Sat Jan 12, 2019 11:46 pm
- Separate last word?
-
- User-Defined Cell Format: Letters and Numbers
by BiscuitEater » Sat Jan 12, 2019 7:55 pm
- 2 Replies
- 115 Views
- Last post by BiscuitEater
Sat Jan 12, 2019 10:59 pm
- User-Defined Cell Format: Letters and Numbers
-
- [Solved] Find&Replace regular expressions are not recognized
by TToth » Fri Jan 11, 2019 4:49 pm - 4 Replies
- 170 Views
- Last post by TToth
Sat Jan 12, 2019 9:41 pm
- [Solved] Find&Replace regular expressions are not recognized
-
- [Solved] Find largest conditional value
by Alexie » Sat Jan 12, 2019 5:59 pm
- 4 Replies
- 118 Views
- Last post by Alexie
Sat Jan 12, 2019 7:33 pm
- [Solved] Find largest conditional value
-
- Sum of weekdays on Weekends irrespective of Position
by Venkatesh1128 » Thu Jan 10, 2019 4:41 am
- 8 Replies
- 222 Views
- Last post by mikele
Sat Jan 12, 2019 3:48 pm
- Sum of weekdays on Weekends irrespective of Position
-
- Links not working
by neiljacobson » Sat Jan 12, 2019 6:28 am - 2 Replies
- 104 Views
- Last post by Zizi64
Sat Jan 12, 2019 9:57 am
- Links not working
-
- Code to find a cell contains image or pic
by Nayan9245 » Fri Jan 11, 2019 9:12 am
- 3 Replies
- 133 Views
- Last post by Lupp
Fri Jan 11, 2019 11:11 pm
- Code to find a cell contains image or pic
-
- Invoice automation advice?
by kups93 » Fri Jan 11, 2019 4:59 pm
- 3 Replies
- 142 Views
- Last post by Villeroy
Fri Jan 11, 2019 10:51 pm
- Invoice automation advice?
-
- [Solved] Showing last 10 rows based on match.
by Kinoss » Thu Jan 10, 2019 9:43 pm
- 6 Replies
- 180 Views
- Last post by Kinoss
Fri Jan 11, 2019 9:43 pm
- [Solved] Showing last 10 rows based on match.
-
- [Solved] Re-arranging cells
by NWSailor » Tue Jan 08, 2019 8:34 pm
- 7 Replies
- 230 Views
- Last post by NWSailor
Fri Jan 11, 2019 7:38 pm
- [Solved] Re-arranging cells
-
- [Solved] Conditional sum of the product of two columns
by josephj » Fri Jan 11, 2019 6:41 am - 1 Replies
- 114 Views
- Last post by FJCC
Fri Jan 11, 2019 6:47 am
- [Solved] Conditional sum of the product of two columns
-
- [Solved] How to draw a rectangle in a spreadsheet
by gutee » Wed Jan 09, 2019 9:34 am - 4 Replies
- 195 Views
- Last post by gutee
Fri Jan 11, 2019 6:10 am
- [Solved] How to draw a rectangle in a spreadsheet
Who is online
Users browsing this forum: No registered users and 43 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
|