Apache OpenOffice Community Forum - Calc - (View forum)

Calc

Forum

Topics

Posts

Last post

Calc Guide for 4.x
Apache OpenOffice 4.x User Guides - PDF chapters (DEC-2022)
Total redirects: 923270

Total redirects: 923270
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 773822

Total redirects: 773822
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 782858

Total redirects: 782858
Calc Tutorials
Tutorials from this forum
Total redirects: 769861

Total redirects: 769861

New Topic

23347 topics

Page 4 of 467
- Jump to page:
Previous
1
2
3
4
5
6
…
467
Next

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.16 Released

Last post by robleyd « Thu Nov 13, 2025 3:27 am
Posted in Announcements
Replies: 1
by LastUnicorn » Tue Nov 11, 2025 12:36 pm » in Announcements

1 Replies

135448 Views

Last post by robleyd
Thu Nov 13, 2025 3:27 am

Topics

Replies

Views

Last post

[Solved] Printer page settings for EACH sheet

Last post by MrProgrammer « Mon Mar 31, 2025 7:30 pm
Replies: 1
by mxdog » Mon Mar 31, 2025 6:56 pm

1 Replies

2115 Views

Last post by MrProgrammer
Mon Mar 31, 2025 7:30 pm
[Solved] Filter data to find patterns

Last post by minxabroad « Sat Mar 29, 2025 4:45 pm
Replies: 30
by minxabroad » Wed Mar 26, 2025 7:16 pm
1

2
30 Replies

11534 Views

Last post by minxabroad
Sat Mar 29, 2025 4:45 pm
[Dropped] Print 2 pages per sheet in LibreOffice

Last post by Zizi64 « Fri Mar 28, 2025 7:51 am
Replies: 1
by whaler » Fri Mar 28, 2025 2:44 am

1 Replies

2082 Views

Last post by Zizi64
Fri Mar 28, 2025 7:51 am
[Dropped] Make cell borders heavier

Last post by MrProgrammer « Thu Mar 27, 2025 3:54 pm
Replies: 4
by DavidMWright » Wed Mar 26, 2025 12:19 am

4 Replies

2580 Views

Last post by MrProgrammer
Thu Mar 27, 2025 3:54 pm
[Solved] Make a column immune to scrolling

Last post by CacheRAM « Tue Mar 25, 2025 1:05 pm
Replies: 2
by CacheRAM » Tue Mar 25, 2025 12:29 pm

2 Replies

2311 Views

Last post by CacheRAM
Tue Mar 25, 2025 1:05 pm
[Solved] Unencrypt .xls document

Last post by RoryOF « Tue Mar 25, 2025 11:51 am
Replies: 2
by 3ME » Tue Mar 25, 2025 12:52 am

2 Replies

2440 Views

Last post by RoryOF
Tue Mar 25, 2025 11:51 am
[Solved] Hyperlink not working

Last post by Tucson77 « Tue Mar 25, 2025 9:42 am
Replies: 8
by Tucson77 » Sat Mar 22, 2025 5:15 pm

8 Replies

3085 Views

Last post by Tucson77
Tue Mar 25, 2025 9:42 am
[Solved] Show chart but not data cells

Last post by MrProgrammer « Mon Mar 24, 2025 12:35 am
Replies: 2
by sracing » Sun Mar 23, 2025 7:02 pm

2 Replies

2534 Views

Last post by MrProgrammer
Mon Mar 24, 2025 12:35 am
[Solved] Search for name in multiple sheets

Last post by DiGro « Sun Mar 23, 2025 12:29 pm
Replies: 3
by timlab55 » Sat Mar 22, 2025 5:49 pm

3 Replies

2560 Views

Last post by DiGro
Sun Mar 23, 2025 12:29 pm
[Solved+Issue] Change sheet tab appearance size

Last post by sufferer « Sat Mar 22, 2025 6:44 pm
Replies: 3
by sufferer » Sat Mar 22, 2025 5:01 pm

3 Replies

2596 Views

Last post by sufferer
Sat Mar 22, 2025 6:44 pm
[Solved+Issue] Sheet names are too small

Last post by Hagar Delest « Thu Mar 20, 2025 5:09 pm
Replies: 10
by fad » Wed Mar 19, 2025 5:10 pm

10 Replies

3533 Views

Last post by Hagar Delest
Thu Mar 20, 2025 5:09 pm
[Solved] ODS file corrupted requires help from expert

Last post by cwolan « Mon Mar 17, 2025 5:16 pm
Replies: 10
by jgrona » Mon Mar 17, 2025 11:33 am

10 Replies

3568 Views

Last post by cwolan
Mon Mar 17, 2025 5:16 pm
Reassign spreadsheet templates

Last post by White Phoenix « Mon Mar 17, 2025 12:26 am
Replies: 3
by White Phoenix » Mon Feb 24, 2025 10:20 pm

3 Replies

5509 Views

Last post by White Phoenix
Mon Mar 17, 2025 12:26 am
[Solved] Unexpected text color in cells; can't change

Last post by DWDun « Sat Mar 15, 2025 8:47 pm
Replies: 2
by DWDun » Sat Mar 15, 2025 7:15 pm

2 Replies

2590 Views

Last post by DWDun
Sat Mar 15, 2025 8:47 pm
[Solved] Remove space at beginning/end of cell

Last post by karolus « Fri Mar 14, 2025 10:50 am
Replies: 2
by THEBookMan » Thu Mar 13, 2025 10:16 pm

2 Replies

2786 Views

Last post by karolus
Fri Mar 14, 2025 10:50 am
[Solved] Set character limit for cell

Last post by MrProgrammer « Thu Mar 13, 2025 10:11 pm
Replies: 7
by evets » Sun Nov 27, 2022 12:26 am

7 Replies

8040 Views

Last post by MrProgrammer
Thu Mar 13, 2025 10:11 pm
[Solved] SUMIF not adding based on day of week

Last post by boydfritsch « Thu Mar 13, 2025 7:00 pm
Replies: 5
by boydfritsch » Wed Mar 12, 2025 11:01 pm

5 Replies

2962 Views

Last post by boydfritsch
Thu Mar 13, 2025 7:00 pm
[Solved] Match category name for SUMPRODUCT

Last post by youni « Thu Mar 13, 2025 6:54 pm
Replies: 2
by youni » Thu Mar 13, 2025 1:35 pm

2 Replies

2493 Views

Last post by youni
Thu Mar 13, 2025 6:54 pm
[Solved] Convert function result to cell formula

Last post by Gonzo714 « Mon Mar 10, 2025 7:43 pm
Replies: 2
by Gonzo714 » Mon Mar 10, 2025 6:51 pm

2 Replies

2362 Views

Last post by Gonzo714
Mon Mar 10, 2025 7:43 pm
[Solved] Err:508 in Excel lookup formula

Last post by BulletBS « Mon Mar 10, 2025 12:12 am
Replies: 2
by BulletBS » Sun Mar 09, 2025 6:28 pm

2 Replies

2378 Views

Last post by BulletBS
Mon Mar 10, 2025 12:12 am
[Solved] If formula returns error show empty cell

Last post by Lupp « Fri Mar 07, 2025 6:30 pm
Replies: 4
by Bushido222 » Wed Feb 19, 2025 3:18 am

4 Replies

5828 Views

Last post by Lupp
Fri Mar 07, 2025 6:30 pm
[Solved] Which character set to use for document recovery?

Last post by RoryOF « Fri Mar 07, 2025 12:31 pm
Replies: 3
by PontiacKiller » Fri Mar 07, 2025 12:09 am

3 Replies

2453 Views

Last post by RoryOF
Fri Mar 07, 2025 12:31 pm
[Solved] Keep column headers visible at top

Last post by Oskar4U « Thu Mar 06, 2025 5:48 pm
Replies: 2
by Oskar4U » Thu Mar 06, 2025 1:47 pm

2 Replies

2125 Views

Last post by Oskar4U
Thu Mar 06, 2025 5:48 pm
[Solved] Change column headings, currently A, B, C, …

Last post by robleyd « Thu Mar 06, 2025 8:35 am
Replies: 3
by ray5450 » Thu Mar 06, 2025 7:05 am

3 Replies

2366 Views

Last post by robleyd
Thu Mar 06, 2025 8:35 am
[Solved] Sum column D if column E is empty

Last post by morganmusic « Mon Mar 03, 2025 8:55 pm
Replies: 5
by morganmusic » Sun Mar 02, 2025 10:03 pm

5 Replies

2634 Views

Last post by morganmusic
Mon Mar 03, 2025 8:55 pm
Comments on Natural Sort topic 112556

Last post by Lupp « Mon Mar 03, 2025 8:37 pm
Replies: 4
by Lupp » Mon Mar 03, 2025 3:36 pm

4 Replies

2321 Views

Last post by Lupp
Mon Mar 03, 2025 8:37 pm
[Solved] Calculated % in one cell <> identical % Etered in another cell

Last post by DWDun « Sun Mar 02, 2025 8:24 pm
Replies: 5
by DWDun » Sun Mar 02, 2025 12:13 am

5 Replies

2905 Views

Last post by DWDun
Sun Mar 02, 2025 8:24 pm
[Solved] Multiple statistics in status bar: SUM and COUNT

Last post by FRR « Sun Mar 02, 2025 12:20 pm
Replies: 2
by FRR » Sun Mar 02, 2025 11:31 am

2 Replies

2249 Views

Last post by FRR
Sun Mar 02, 2025 12:20 pm
[Solved] Text and formula with space in same cell

Last post by bryan.hoffmann « Fri Feb 28, 2025 3:49 pm
Replies: 19
by Kenmc » Sun Jun 28, 2015 10:09 pm

19 Replies

12047 Views

Last post by bryan.hoffmann
Fri Feb 28, 2025 3:49 pm
[Solved] Astronomy binary star chart

Last post by MrProgrammer « Thu Feb 27, 2025 5:11 pm
Replies: 9
by marty-0750 » Tue Feb 25, 2025 2:10 pm

9 Replies

4875 Views

Last post by MrProgrammer
Thu Feb 27, 2025 5:11 pm
[Solved] File size shrank from 2MB to 1.1MB

Last post by robleyd « Wed Feb 26, 2025 12:17 pm
Replies: 5
by Rarefoil » Mon Feb 24, 2025 6:44 am

5 Replies

5216 Views

Last post by robleyd
Wed Feb 26, 2025 12:17 pm
[Solved] Copy data from sheet to sheet

Last post by terenceM « Tue Feb 25, 2025 5:13 pm
Replies: 4
by terenceM » Sun Feb 23, 2025 8:43 pm

4 Replies

4739 Views

Last post by terenceM
Tue Feb 25, 2025 5:13 pm
[Solved] Unable to open Excel XLSX file

Last post by Bidouille « Tue Feb 25, 2025 9:23 am
Replies: 5
by geio48kv6 » Mon Feb 24, 2025 3:49 am

5 Replies

5217 Views

Last post by Bidouille
Tue Feb 25, 2025 9:23 am
[Solved] IF function result differs from Excel

Last post by Oskar4U « Mon Feb 24, 2025 10:34 am
Replies: 7
by Oskar4U » Sun Feb 23, 2025 11:41 am

7 Replies

5121 Views

Last post by Oskar4U
Mon Feb 24, 2025 10:34 am
[Solved] Sort text1 through text19 correctly

Last post by Lupp « Thu Feb 20, 2025 12:48 pm
Replies: 6
by procadman » Wed Feb 19, 2025 5:17 am

6 Replies

4687 Views

Last post by Lupp
Thu Feb 20, 2025 12:48 pm
[Solved] Printout doesn't include last rows

Last post by johnewbie « Mon Feb 17, 2025 10:49 pm
Replies: 4
by johnewbie » Mon Feb 17, 2025 8:19 pm

4 Replies

3658 Views

Last post by johnewbie
Mon Feb 17, 2025 10:49 pm
[Solved] MIN/MAX/AVERAGE/MEDIAN of binary numbers

Last post by PAB « Mon Feb 17, 2025 12:17 pm
Replies: 10
by PAB » Sun Feb 16, 2025 2:55 am

10 Replies

4810 Views

Last post by PAB
Mon Feb 17, 2025 12:17 pm
Only run macro on manually edited fields

Last post by Bidouille « Sun Feb 16, 2025 8:04 pm
Replies: 5
by David_L » Wed Feb 12, 2025 4:59 am

5 Replies

4165 Views

Last post by Bidouille
Sun Feb 16, 2025 8:04 pm
[Solved] SUMIF doesn't count rows with X

Last post by MarkinPA « Wed Feb 12, 2025 2:01 am
Replies: 3
by MarkinPA » Tue Feb 11, 2025 11:08 pm

3 Replies

3752 Views

Last post by MarkinPA
Wed Feb 12, 2025 2:01 am
[Solved] Different bar colors for positive/negative numbers

Last post by Lupp « Mon Feb 10, 2025 1:42 pm
Replies: 4
by Lt2210 » Sat Feb 08, 2025 1:31 am

4 Replies

4479 Views

Last post by Lupp
Mon Feb 10, 2025 1:42 pm
[Dropped] Count how often a list element occurs

Last post by MrProgrammer « Sun Feb 09, 2025 8:04 pm
Replies: 1
by OliSwamp » Sun Feb 09, 2025 7:35 pm

1 Replies

3369 Views

Last post by MrProgrammer
Sun Feb 09, 2025 8:04 pm
[Dropped] Hidden characters when merging cells

Last post by robleyd « Sat Feb 08, 2025 12:01 am
Replies: 7
by cjtheme » Fri Feb 07, 2025 10:21 am

7 Replies

5067 Views

Last post by robleyd
Sat Feb 08, 2025 12:01 am
[Solved] Convert text to date

Last post by Peter81 « Fri Feb 07, 2025 6:43 pm
Replies: 5
by jgriffs@comcast.net » Sun Jun 23, 2019 3:39 am

5 Replies

11143 Views

Last post by Peter81
Fri Feb 07, 2025 6:43 pm
[Solved] Unexpected SUMIF results

Last post by MrProgrammer « Fri Feb 07, 2025 4:10 am
Replies: 5
by arch_na » Thu Feb 06, 2025 6:53 pm

5 Replies

5277 Views

Last post by MrProgrammer
Fri Feb 07, 2025 4:10 am
[Solved] Create Pie Charts from survey results

Last post by kabing « Thu Feb 06, 2025 10:30 pm
Replies: 2
by kabing » Wed Jan 29, 2025 7:18 pm

2 Replies

8193 Views

Last post by kabing
Thu Feb 06, 2025 10:30 pm
[Solved] Calc not printing specific sheets from book

Last post by rwscid « Thu Feb 06, 2025 1:10 am
Replies: 3
by rwscid » Wed Feb 05, 2025 5:53 pm

3 Replies

5431 Views

Last post by rwscid
Thu Feb 06, 2025 1:10 am
[Solved] Get value from lookup table

Last post by Josh Brenjan « Wed Feb 05, 2025 11:57 pm
Replies: 2
by Josh Brenjan » Wed Feb 05, 2025 4:22 pm

2 Replies

5213 Views

Last post by Josh Brenjan
Wed Feb 05, 2025 11:57 pm
[Solved] Increment Columns

Last post by Alex1 « Wed Feb 05, 2025 5:21 pm
Replies: 5
by BAC94 » Sun Dec 17, 2017 9:40 pm

5 Replies

6875 Views

Last post by Alex1
Wed Feb 05, 2025 5:21 pm
[Solved] Set background color of row based on dropdown

Last post by Alex1 « Wed Feb 05, 2025 3:00 pm
Replies: 1
by SushiBear » Mon Feb 03, 2025 5:07 pm

1 Replies

6047 Views

Last post by Alex1
Wed Feb 05, 2025 3:00 pm
[Solved] Convert CSV with Credit/Debit to signed numbers

Last post by Hagar Delest « Sun Feb 02, 2025 5:04 pm
Replies: 2
by AndrewB1 » Sun Feb 02, 2025 3:51 pm

2 Replies

5347 Views

Last post by Hagar Delest
Sun Feb 02, 2025 5:04 pm

New Topic

23347 topics

Page 4 of 467
- Jump to page:
Previous
1
2
3
4
5
6
…
467
Next

Return to Board Index

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