Apache OpenOffice Community Forum - Calc

Calc

Forum

Topics

Posts

Last post

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

Total redirects: 1088449
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 920221

Total redirects: 920221
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 927994

Total redirects: 927994
Calc Tutorials
Tutorials from this forum
Total redirects: 912724

Total redirects: 912724

New Topic

23361 topics

Page 1 of 468
- Jump to page:
1
2
3
4
5
…
468
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

223375 Views

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

Topics

Replies

Views

Last post

Templates: a dedicated repository in the OpenOffice web site

Last post by Villeroy « Sun Jul 20, 2014 2:25 pm
Replies: 6
by Hagar Delest » Sun Feb 01, 2009 12:25 am

6 Replies

149097 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
[Solved] Combining multiple sheets into one sheet

Last post by cephas « Sun Sep 06, 2026 5:44 am
Replies: 7
by cephas » Fri Sep 04, 2026 4:59 am

7 Replies

144 Views

Last post by cephas
Sun Sep 06, 2026 5:44 am
AndrOpenOffice and OpenOffice (Windows) compatibility

Last post by RoryOF « Fri Sep 04, 2026 10:12 pm
Replies: 1
by Kees1 » Fri Sep 04, 2026 9:15 pm

1 Replies

53 Views

Last post by RoryOF
Fri Sep 04, 2026 10:12 pm
Print list of cell addresses and values/formulas

Last post by MrProgrammer « Tue Aug 25, 2026 10:03 pm
Replies: 2
by Phoenix1151 » Wed Aug 19, 2026 12:01 am

2 Replies

552 Views

Last post by MrProgrammer
Tue Aug 25, 2026 10:03 pm
Is there a way to show a number as a fixed fraction?

Last post by Lupp « Tue Aug 25, 2026 7:45 pm
Replies: 9
by Kirjava » Mon Aug 24, 2026 2:20 pm

9 Replies

503 Views

Last post by Lupp
Tue Aug 25, 2026 7:45 pm
[Solved] Perform table lookup

Last post by MrProgrammer « Wed Aug 19, 2026 12:19 am
Replies: 2
by Phoenix1151 » Tue Aug 18, 2026 8:23 pm

2 Replies

273 Views

Last post by MrProgrammer
Wed Aug 19, 2026 12:19 am
[Solved] Load different files in separate sheets

Last post by Phoenix1151 « Tue Aug 18, 2026 10:29 pm
Replies: 5
by Phoenix1151 » Sat Aug 15, 2026 11:15 pm

5 Replies

413 Views

Last post by Phoenix1151
Tue Aug 18, 2026 10:29 pm
[Example] Free Combobox and Multi List Box files

Last post by Bidouille « Fri Jul 17, 2026 10:12 am
Replies: 1
by steverat » Thu Jul 16, 2026 5:21 pm

1 Replies

871 Views

Last post by Bidouille
Fri Jul 17, 2026 10:12 am
[Dropped] OpenOffice lost how it works

Last post by MrProgrammer « Wed Jul 15, 2026 8:39 pm
Replies: 1
by Jimatsea » Tue Jul 14, 2026 6:36 am

1 Replies

715 Views

Last post by MrProgrammer
Wed Jul 15, 2026 8:39 pm
Enter data in a hidden sheet

Last post by dreamquartz « Wed Jun 24, 2026 6:29 am
Replies: 2
by dreamquartz » Mon Jun 22, 2026 7:42 pm

2 Replies

24806 Views

Last post by dreamquartz
Wed Jun 24, 2026 6:29 am
Base Record to Calc Question

Last post by dreamquartz « Mon Jun 22, 2026 5:18 pm
Replies: 4
by dreamquartz » Sun May 24, 2026 11:38 pm

4 Replies

15471 Views

Last post by dreamquartz
Mon Jun 22, 2026 5:18 pm
[Dropped] Count cells highlighted in red color

Last post by Alex1 « Mon Jun 22, 2026 2:20 am
Replies: 3
by katintn » Fri Jun 19, 2026 10:37 pm

3 Replies

23550 Views

Last post by Alex1
Mon Jun 22, 2026 2:20 am
[Solved] Match any non-zero number

Last post by MrProgrammer « Wed Jun 17, 2026 5:31 pm
Replies: 3
by chris129 » Wed Jun 17, 2026 1:52 am

3 Replies

13797 Views

Last post by MrProgrammer
Wed Jun 17, 2026 5:31 pm
Text Import dialog shown when opening file

Last post by robleyd « Sun Jun 14, 2026 11:28 am
Replies: 1
by gruzdenkoa » Sun Jun 14, 2026 10:35 am

1 Replies

8067 Views

Last post by robleyd
Sun Jun 14, 2026 11:28 am
[Solved] Regular Expression matched value replacement

Last post by Jan_J « Wed Jun 10, 2026 3:04 pm
Replies: 6
by Phillip » Tue Jun 09, 2026 1:39 pm

6 Replies

13599 Views

Last post by Jan_J
Wed Jun 10, 2026 3:04 pm
[Solved] Sheet tabs disappeared

Last post by MrProgrammer « Thu May 28, 2026 4:28 pm
Replies: 1
by djarvis52 » Thu May 28, 2026 2:57 pm

1 Replies

1984 Views

Last post by MrProgrammer
Thu May 28, 2026 4:28 pm
[Solved] #N/A from VLOOKUP in first row

Last post by endbrown « Thu May 21, 2026 11:59 am
Replies: 5
by endbrown » Mon May 18, 2026 1:08 pm

5 Replies

2416 Views

Last post by endbrown
Thu May 21, 2026 11:59 am
[Solved] Page setup for multiple sheets

Last post by Dongatrash « Mon May 11, 2026 4:34 am
Replies: 2
by Dongatrash » Fri May 08, 2026 5:27 am

2 Replies

2859 Views

Last post by Dongatrash
Mon May 11, 2026 4:34 am
[Solved] Thicker lines in chart legend

Last post by Kees1 « Tue May 05, 2026 10:53 am
Replies: 5
by Kees1 » Fri Apr 17, 2026 3:19 pm

5 Replies

3432 Views

Last post by Kees1
Tue May 05, 2026 10:53 am
[Solved] Language problem using Text Import

Last post by karolus « Fri May 01, 2026 11:52 am
Replies: 2
by de7ert.eagle » Fri May 01, 2026 8:41 am

2 Replies

2625 Views

Last post by karolus
Fri May 01, 2026 11:52 am
[Solved] Password-protected Calc files stopped opening

Last post by MrProgrammer « Mon Apr 27, 2026 3:35 pm
Replies: 2
by isbo » Wed Apr 22, 2026 10:08 am

2 Replies

2696 Views

Last post by MrProgrammer
Mon Apr 27, 2026 3:35 pm
[Solved] Save formatting for section/page A1 to H12

Last post by greypoet « Fri Apr 24, 2026 12:01 am
Replies: 3
by greypoet » Thu Apr 23, 2026 2:44 am

3 Replies

3290 Views

Last post by greypoet
Fri Apr 24, 2026 12:01 am
[Solved] Unexpected references used when copying

Last post by Dongatrash « Thu Apr 23, 2026 5:32 am
Replies: 3
by Dongatrash » Fri Jan 16, 2026 5:56 am

3 Replies

10518 Views

Last post by Dongatrash
Thu Apr 23, 2026 5:32 am
[Solved] Use reference, not fixed date, in formula

Last post by FJCC « Wed Apr 22, 2026 3:53 am
Replies: 1
by awascholl » Tue Apr 21, 2026 7:32 pm

1 Replies

2242 Views

Last post by FJCC
Wed Apr 22, 2026 3:53 am
Data displayed to left of spreadsheet

Last post by Hagar Delest « Sat Apr 18, 2026 11:11 am
Replies: 3
by orgopenoffice1 » Tue Apr 14, 2026 7:27 pm

3 Replies

2832 Views

Last post by Hagar Delest
Sat Apr 18, 2026 11:11 am
[Solved] Summary sheet via Pivot Table

Last post by Villeroy « Tue Mar 31, 2026 12:02 am
Replies: 8
by Cat101 » Sat Mar 21, 2026 3:38 am

8 Replies

3607 Views

Last post by Villeroy
Tue Mar 31, 2026 12:02 am
[Solved] Scrolling issue in Calc

Last post by MrProgrammer « Wed Mar 25, 2026 9:36 pm
Replies: 1
by PencilGal » Wed Mar 25, 2026 5:44 pm

1 Replies

2593 Views

Last post by MrProgrammer
Wed Mar 25, 2026 9:36 pm
[Solved] Count of cells with numbers

Last post by katintn « Wed Mar 25, 2026 5:02 pm
Replies: 2
by katintn » Wed Mar 18, 2026 10:06 pm

2 Replies

2511 Views

Last post by katintn
Wed Mar 25, 2026 5:02 pm
[Solved] Paste Special: Unformatted not shown

Last post by m13m13 « Mon Mar 23, 2026 5:11 am
Replies: 2
by m13m13 » Mon Mar 23, 2026 1:22 am

2 Replies

2356 Views

Last post by m13m13
Mon Mar 23, 2026 5:11 am
[Issue] LO Calc Focus/Input Mode

Last post by crusader « Wed Mar 18, 2026 12:53 am
Replies: 28
by crusader » Sun Jan 25, 2026 12:18 am

28 Replies

20034 Views

Last post by crusader
Wed Mar 18, 2026 12:53 am
[Solved] Date 3/4/26 becomes ¾/26

Last post by Mhilinski1 « Thu Mar 12, 2026 11:23 pm
Replies: 15
by Mhilinski1 » Sat Mar 07, 2026 4:54 pm

15 Replies

3538 Views

Last post by Mhilinski1
Thu Mar 12, 2026 11:23 pm
[Dropped] Average formula stopped working

Last post by robleyd « Sat Mar 07, 2026 12:42 am
Replies: 2
by katintn » Fri Mar 06, 2026 11:36 pm

2 Replies

2767 Views

Last post by robleyd
Sat Mar 07, 2026 12:42 am
[Solved] Determine Nth day-of-week for month

Last post by morchat « Fri Mar 06, 2026 10:46 pm
Replies: 6
by taylor.r113y » Sun Mar 01, 2026 11:20 am

6 Replies

3861 Views

Last post by morchat
Fri Mar 06, 2026 10:46 pm
[Solved] Sum time by department and date

Last post by Cat101 « Fri Mar 06, 2026 2:52 am
Replies: 9
by Cat101 » Sat Feb 28, 2026 6:39 am

9 Replies

3954 Views

Last post by Cat101
Fri Mar 06, 2026 2:52 am
[Solved] AutoFilter extends Data Range

Last post by morchat « Tue Mar 03, 2026 11:00 pm
Replies: 1
by Phillip » Tue Mar 03, 2026 7:53 pm

1 Replies

2827 Views

Last post by morchat
Tue Mar 03, 2026 11:00 pm
[Solved] Position middle vs bottom of row

Last post by Zizi64 « Wed Feb 18, 2026 8:53 am
Replies: 4
by Oskar4U » Wed Feb 18, 2026 1:50 am

4 Replies

6587 Views

Last post by Zizi64
Wed Feb 18, 2026 8:53 am
[Solved] Extra cells outside the normal cells

Last post by orgopenoffice1 « Sat Feb 14, 2026 6:51 pm
Replies: 11
by orgopenoffice1 » Fri Feb 13, 2026 8:27 pm

11 Replies

6961 Views

Last post by orgopenoffice1
Sat Feb 14, 2026 6:51 pm
[Solved] Vector too long problem

Last post by MrProgrammer « Sun Feb 08, 2026 5:07 pm
Replies: 3
by dthorne333 » Sun Feb 08, 2026 3:09 pm

3 Replies

7974 Views

Last post by MrProgrammer
Sun Feb 08, 2026 5:07 pm
[Solved] Add condition to IF

Last post by donnje « Sat Feb 07, 2026 6:47 pm
Replies: 15
by donnje » Sun Feb 01, 2026 7:06 pm

15 Replies

10064 Views

Last post by donnje
Sat Feb 07, 2026 6:47 pm
[Solved] Formula to subtract A1-A2, with conditions

Last post by Alex1 « Sat Feb 07, 2026 11:49 am
Replies: 10
by donnje » Sun Feb 01, 2026 7:08 pm

10 Replies

9126 Views

Last post by Alex1
Sat Feb 07, 2026 11:49 am
[Solved] SUMIFS formula gives Err:508

Last post by morchat « Tue Feb 03, 2026 11:17 pm
Replies: 7
by __John_L. » Tue Jan 27, 2026 3:59 am

7 Replies

9571 Views

Last post by morchat
Tue Feb 03, 2026 11:17 pm
[Solved] Convert numbers to negative, red

Last post by robleyd « Mon Feb 02, 2026 1:13 pm
Replies: 4
by Oohappyuser » Mon Feb 02, 2026 6:26 am

4 Replies

7969 Views

Last post by robleyd
Mon Feb 02, 2026 1:13 pm
[Dropped] File will not open

Last post by RoryOF « Wed Jan 28, 2026 11:11 am
Replies: 2
by ghia589 » Wed Jan 28, 2026 2:12 am

2 Replies

8297 Views

Last post by RoryOF
Wed Jan 28, 2026 11:11 am
[Solved] Total days in a Schengen country ONLY

Last post by taylor.r113y « Tue Jan 27, 2026 8:37 pm
Replies: 5
by taylor.r113y » Sun Jan 25, 2026 6:47 pm

5 Replies

8072 Views

Last post by taylor.r113y
Tue Jan 27, 2026 8:37 pm
[Solved] Calc freezes (not responding)

Last post by crusader « Tue Jan 27, 2026 12:46 am
Replies: 1
by geoffq » Sun Jan 25, 2026 1:30 pm

1 Replies

7714 Views

Last post by crusader
Tue Jan 27, 2026 12:46 am
[Dropped] Spreadsheet printing problems

Last post by Hagar Delest « Tue Jan 20, 2026 4:47 pm
Replies: 1
by Gumption » Tue Jan 20, 2026 4:09 pm

1 Replies

9347 Views

Last post by Hagar Delest
Tue Jan 20, 2026 4:47 pm
[Solved] SMPTE calculations in OpenOffice

Last post by MrProgrammer « Mon Jan 19, 2026 5:13 pm
Replies: 1
by glimmer » Mon Jan 19, 2026 2:03 pm

1 Replies

9254 Views

Last post by MrProgrammer
Mon Jan 19, 2026 5:13 pm
[Solved] N/A error with dropdown list and VLOOKUP

Last post by CannedMan « Mon Jan 19, 2026 2:17 pm
Replies: 2
by CannedMan » Mon Jan 19, 2026 12:38 am

2 Replies

9211 Views

Last post by CannedMan
Mon Jan 19, 2026 2:17 pm
Sort List conflict, a…z versus A…Z

Last post by LeroyTennison « Sun Jan 18, 2026 6:27 am
Replies: 4
by LeroyTennison » Sat Jan 17, 2026 7:53 am

4 Replies

9753 Views

Last post by LeroyTennison
Sun Jan 18, 2026 6:27 am
[Solved] Windows 11 background fill

Last post by bluepeter « Fri Jan 16, 2026 10:48 pm
Replies: 2
by bluepeter » Fri Jan 16, 2026 1:18 am

2 Replies

9466 Views

Last post by bluepeter
Fri Jan 16, 2026 10:48 pm

New Topic

23361 topics

Page 1 of 468
- Jump to page:
1
2
3
4
5
…
468
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