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: 30782
-
-
-
Calc Functions
Extended Help on the Calc functions - HTML - Total redirects: 32572
-
-
-
Calc Tutorials
Tutorials from this forum - Total redirects: 29351
-
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 91151 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Filling series in filtered column
by eezyrider » Wed Nov 06, 2019 12:03 am
- 2 Replies
- 237 Views
- Last post by eezyrider
Thu Nov 07, 2019 1:00 pm
- [Solved] Filling series in filtered column
-
- Background color not working
by Perplexed » Thu Oct 31, 2019 8:15 pm
- 13 Replies
- 628 Views
- Last post by Zizi64
Wed Nov 06, 2019 7:41 am
- Background color not working
-
- [Solved] IF function stopped working
by AlanDB » Tue Nov 05, 2019 4:31 pm - 1 Replies
- 171 Views
- Last post by Villeroy
Tue Nov 05, 2019 7:35 pm
- [Solved] IF function stopped working
-
- Chart Functionality: use cells for chart options & titles
by Myndex » Fri Nov 01, 2019 1:24 am
- 7 Replies
- 391 Views
- Last post by Zizi64
Tue Nov 05, 2019 8:26 am
- Chart Functionality: use cells for chart options & titles
-
- [Solved] Need to calculate a sum based on drop down list
by rjstamey » Tue Nov 05, 2019 3:19 am - 4 Replies
- 235 Views
- Last post by FJCC
Tue Nov 05, 2019 4:41 am
- [Solved] Need to calculate a sum based on drop down list
-
- Calc file open with text import dialog box
by darsh4126 » Tue Nov 05, 2019 12:36 am
- 1 Replies
- 170 Views
- Last post by RusselB
Tue Nov 05, 2019 2:07 am
- Calc file open with text import dialog box
-
- [Solved] Various Colour of text in a single cell formatting
by Dziki » Sun Nov 03, 2019 4:22 pm - 4 Replies
- 248 Views
- Last post by Dziki
Mon Nov 04, 2019 10:48 pm
- [Solved] Various Colour of text in a single cell formatting
-
- How to make arrows move cursor across the sheet ?
by doublehp » Sun Nov 03, 2019 2:01 pm - 10 Replies
- 340 Views
- Last post by doublehp
Mon Nov 04, 2019 1:29 am
- How to make arrows move cursor across the sheet ?
-
- Colour one entry every time
by atillaagain » Sun Nov 03, 2019 7:27 pm
- 4 Replies
- 227 Views
- Last post by Villeroy
Sun Nov 03, 2019 10:19 pm
- Colour one entry every time
-
- Flashing cell
by Arppa » Sun Nov 03, 2019 9:27 am
- 2 Replies
- 223 Views
- Last post by F3K Total
Sun Nov 03, 2019 1:45 pm
- Flashing cell
-
- Solver doenst take into account the binary function
by crf888 » Sat Nov 02, 2019 9:11 pm - 2 Replies
- 231 Views
- Last post by FJCC
Sat Nov 02, 2019 11:31 pm
- Solver doenst take into account the binary function
-
- [Solved] Can We Have A Selection 'Hidden' ?
by abrogard » Sat Nov 02, 2019 1:38 am - 4 Replies
- 250 Views
- Last post by abrogard
Sat Nov 02, 2019 9:51 pm
- [Solved] Can We Have A Selection 'Hidden' ?
-
- [Solved] Newly entered data not appearing on chart?
by Tim T » Thu Oct 31, 2019 1:57 am - 5 Replies
- 400 Views
- Last post by Villeroy
Sat Nov 02, 2019 9:29 pm
- [Solved] Newly entered data not appearing on chart?
-
- [Solved] Output Num of Unique Values From One Col to Another
by bharrison82 » Sat Nov 02, 2019 5:01 am
- 2 Replies
- 259 Views
- Last post by bharrison82
Sat Nov 02, 2019 2:52 pm
- [Solved] Output Num of Unique Values From One Col to Another
-
- User Interface Frustration (Formula Editing)
by Myndex » Fri Nov 01, 2019 1:06 am
- 3 Replies
- 368 Views
- Last post by Myndex
Sat Nov 02, 2019 1:39 am
- User Interface Frustration (Formula Editing)
-
- [Solved] Swap data - column parts
by me231 » Fri Nov 01, 2019 10:15 pm
- 3 Replies
- 248 Views
- Last post by Lupp
Sat Nov 02, 2019 12:58 am
- [Solved] Swap data - column parts
-
- [Solved] Calc not fully loading a large spreadsheet
by loubot1 » Fri Nov 01, 2019 4:19 pm - 5 Replies
- 230 Views
- Last post by loubot1
Fri Nov 01, 2019 10:11 pm
- [Solved] Calc not fully loading a large spreadsheet
-
- [Solved] Extracting right part of text
by bzw » Thu Jan 03, 2019 2:32 am
- 7 Replies
- 550 Views
- Last post by Lupp
Fri Nov 01, 2019 7:37 pm
- [Solved] Extracting right part of text
-
- [Solved] Turn cell into clickable command?
by JohnTheSavage » Wed Oct 30, 2019 8:43 pm
- 8 Replies
- 450 Views
- Last post by Zizi64
Fri Nov 01, 2019 6:11 pm
- [Solved] Turn cell into clickable command?
-
- [Solved] Time In Hours And Minutes...
by JoelDennysDM » Thu Oct 31, 2019 3:05 am
- 6 Replies
- 459 Views
- Last post by RusselB
Fri Nov 01, 2019 3:02 pm
- [Solved] Time In Hours And Minutes...
-
- [Solved] Update loan payoff based on extra payments
by awascholl » Wed Oct 30, 2019 11:04 pm
- 4 Replies
- 412 Views
- Last post by awascholl
Thu Oct 31, 2019 7:03 pm
- [Solved] Update loan payoff based on extra payments
-
- Can't read info on spreadsheet created on Win7
by txbikerinpa » Wed Oct 30, 2019 5:31 pm - 2 Replies
- 271 Views
- Last post by RoryOF
Wed Oct 30, 2019 6:29 pm
- Can't read info on spreadsheet created on Win7
-
- Shorten my IF formula for work schedule
by thrivepetfood » Mon Oct 28, 2019 8:12 pm
- 1 Replies
- 265 Views
- Last post by keme
Wed Oct 30, 2019 3:49 pm
- Shorten my IF formula for work schedule
-
- [Solved] Segmented rows??
by eleanorb » Tue Oct 29, 2019 11:48 pm
- 3 Replies
- 265 Views
- Last post by eleanorb
Wed Oct 30, 2019 1:04 pm
- [Solved] Segmented rows??
-
- Get several rows of text in first row
by uname » Tue Oct 29, 2019 1:19 am
- 7 Replies
- 448 Views
- Last post by RusselB
Tue Oct 29, 2019 11:19 pm
- Get several rows of text in first row
-
- Change cell background color based on cell value yes/no
by DriesKent » Tue Oct 29, 2019 2:51 pm
- 3 Replies
- 227 Views
- Last post by keme
Tue Oct 29, 2019 4:23 pm
- Change cell background color based on cell value yes/no
-
- [Solved] Deducting formula cells from a column
by cris33 » Mon Oct 28, 2019 9:44 pm
- 2 Replies
- 200 Views
- Last post by cris33
Mon Oct 28, 2019 11:32 pm
- [Solved] Deducting formula cells from a column
-
- [Solved] Is it possible to export data as single lines?
by Daza » Mon Oct 28, 2019 4:01 am - 3 Replies
- 288 Views
- Last post by John_Ha
Mon Oct 28, 2019 11:54 am
- [Solved] Is it possible to export data as single lines?
-
- [Solved] If/Then/Else statement wrong with negative numbers
by kharrisma » Sun Oct 27, 2019 9:21 pm
- 3 Replies
- 304 Views
- Last post by kharrisma
Mon Oct 28, 2019 3:20 am
- [Solved] If/Then/Else statement wrong with negative numbers
-
- [Solved] IF formula not working
by sapobelgas » Sun Oct 27, 2019 6:52 pm - 2 Replies
- 243 Views
- Last post by sapobelgas
Mon Oct 28, 2019 12:04 am
- [Solved] IF formula not working
-
- [Solved] Background Color Alternating Row Fill
by pjoseph » Tue Aug 12, 2008 9:24 pm
- 5 Replies
- 84275 Views
- Last post by cstanford
Sun Oct 27, 2019 11:30 am
- [Solved] Background Color Alternating Row Fill
-
- [Solved] Forgotten Password
1, 2 by brodiemac » Thu Jun 11, 2009 1:48 pm
- 34 Replies
- 78431 Views
- Last post by John_Ha
Sat Oct 26, 2019 12:58 pm
- [Solved] Forgotten Password
-
- Highlighting cells in spreadsheet
by Renai » Fri Oct 25, 2019 10:15 pm - 2 Replies
- 245 Views
- Last post by Zizi64
Sat Oct 26, 2019 8:53 am
- Highlighting cells in spreadsheet
-
- [Solved] Test for 0 then assign a value
by donmat » Fri Oct 25, 2019 9:14 pm - 2 Replies
- 254 Views
- Last post by donmat
Fri Oct 25, 2019 9:31 pm
- [Solved] Test for 0 then assign a value
-
- [Solved] Problem retreving data from external link
by Vancejo » Thu Oct 24, 2019 7:39 pm
- 11 Replies
- 403 Views
- Last post by Hagar Delest
Fri Oct 25, 2019 12:34 pm
- [Solved] Problem retreving data from external link
-
- [Solved] Help Using Index Match
by Ether42 » Thu Oct 24, 2019 9:56 pm
- 6 Replies
- 338 Views
- Last post by Ether42
Thu Oct 24, 2019 11:37 pm
- [Solved] Help Using Index Match
-
- [Solved] Find & Replace text: divide one field in two
by Gpvagianas » Thu Oct 24, 2019 7:18 pm - 2 Replies
- 234 Views
- Last post by Gpvagianas
Thu Oct 24, 2019 9:58 pm
- [Solved] Find & Replace text: divide one field in two
-
- OpenOffice Cal date Formatting MM/DD/YYYY
by mhardy7872 » Wed Oct 23, 2019 11:31 pm - 3 Replies
- 331 Views
- Last post by Villeroy
Thu Oct 24, 2019 4:25 pm
- OpenOffice Cal date Formatting MM/DD/YYYY
-
- Keeping rows groups after sort?
by jon oneill » Thu Oct 24, 2019 11:16 am
- 7 Replies
- 302 Views
- Last post by RoryOF
Thu Oct 24, 2019 1:31 pm
- Keeping rows groups after sort?
-
- [Solved] Calling data from external sources
by SagarT_Ind » Tue Oct 22, 2019 6:46 am - 11 Replies
- 465 Views
- Last post by SagarT_Ind
Thu Oct 24, 2019 5:16 am
- [Solved] Calling data from external sources
-
- [Solved] Conditional Formatting, Macro, VBA, IF !??!
by safetydave » Tue Oct 22, 2019 11:58 pm
- 9 Replies
- 408 Views
- Last post by safetydave
Wed Oct 23, 2019 9:07 pm
- [Solved] Conditional Formatting, Macro, VBA, IF !??!
-
- Color cell background if cell=number?
by raynold3228 » Wed Oct 23, 2019 6:38 pm - 1 Replies
- 232 Views
- Last post by Zizi64
Wed Oct 23, 2019 6:44 pm
- Color cell background if cell=number?
-
- [Solved] IF/THEN for entire columns
by raynold3228 » Tue Oct 22, 2019 12:06 am - 5 Replies
- 361 Views
- Last post by raynold3228
Wed Oct 23, 2019 6:36 pm
- [Solved] IF/THEN for entire columns
-
- Chart Bubble Colors
by KirkWard » Tue Oct 22, 2019 5:53 pm
- 5 Replies
- 314 Views
- Last post by KirkWard
Wed Oct 23, 2019 1:05 pm
- Chart Bubble Colors
-
- [Solved] 2 part header and footer question.
by jackrcook » Mon Oct 21, 2019 9:07 pm - 2 Replies
- 269 Views
- Last post by jackrcook
Wed Oct 23, 2019 3:14 am
- [Solved] 2 part header and footer question.
-
- Dispersing deleted amount among remaining numbers
by Skeller204 » Tue Oct 15, 2019 7:21 pm
- 5 Replies
- 377 Views
- Last post by Lupp
Tue Oct 22, 2019 9:08 pm
- Dispersing deleted amount among remaining numbers
-
- [SOLVED] Creating A Bubble Chart
by KirkWard » Tue Oct 22, 2019 4:55 pm
- 1 Replies
- 205 Views
- Last post by KirkWard
Tue Oct 22, 2019 5:04 pm
- [SOLVED] Creating A Bubble Chart
-
- [Solved] Help with IF() function. Incorrect result.
by Epartsman » Mon Oct 21, 2019 4:21 pm
- 7 Replies
- 337 Views
- Last post by Lupp
Tue Oct 22, 2019 3:40 pm
- [Solved] Help with IF() function. Incorrect result.
-
- [Solved] Calc keeps "correcting" upper case to lower case
by kharrisma » Mon Oct 21, 2019 9:38 pm - 2 Replies
- 220 Views
- Last post by kharrisma
Tue Oct 22, 2019 3:32 pm
- [Solved] Calc keeps "correcting" upper case to lower case
-
- [Solved] Convert email to URL?
by jon oneill » Mon Oct 21, 2019 5:46 pm
- 6 Replies
- 314 Views
- Last post by jon oneill
Tue Oct 22, 2019 9:41 am
- [Solved] Convert email to URL?
Who is online
Users browsing this forum: No registered users and 5 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
|