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: 1150923

Total redirects: 1150923
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 988589

Total redirects: 988589
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 997583

Total redirects: 997583
Calc Tutorials
Tutorials from this forum
Total redirects: 980978

Total redirects: 980978

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

250894 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

150765 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
How to unhide Column A

Last post by FJCC « Sat Oct 10, 2026 5:16 pm
Replies: 1
by HowardJ » Sat Oct 10, 2026 4:48 pm

1 Replies

13 Views

Last post by FJCC
Sat Oct 10, 2026 5:16 pm
[Solved] AndrOpenOffice and OpenOffice (Windows) compatibility

Last post by RoryOF « Fri Sep 11, 2026 3:03 pm
Replies: 4
by Kees1 » Fri Sep 04, 2026 9:15 pm

4 Replies

1650 Views

Last post by RoryOF
Fri Sep 11, 2026 3:03 pm
[Solved] Combine multiple sheets into one

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

7 Replies

1375 Views

Last post by cephas
Sun Sep 06, 2026 5:44 am
[Solved] 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

1539 Views

Last post by MrProgrammer
Tue Aug 25, 2026 10:03 pm
[Solved] Show 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

1675 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

1238 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

1522 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

1828 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

1720 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

25994 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

16748 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

24690 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

14889 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

9083 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

14788 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

2924 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

3316 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

3570 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

4436 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

3363 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

3441 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

4046 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

11608 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

2908 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

3546 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

4523 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

3300 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

3210 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

3054 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

22398 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

4577 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

3496 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

4743 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

4873 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

3502 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

7420 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

8291 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

9292 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

11626 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

10363 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

10800 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

9033 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

9232 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

9086 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

8640 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

10328 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

10181 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

10159 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

10789 Views

Last post by LeroyTennison
Sun Jan 18, 2026 6:27 am

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