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

Total redirects: 917444
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 767326

Total redirects: 767326
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 776288

Total redirects: 776288
Calc Tutorials
Tutorials from this forum
Total redirects: 763300

Total redirects: 763300

New Topic

23347 topics

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

133494 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

117914 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
[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

341 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

150 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

260 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

294 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

6656 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

179 Views

Last post by FJCC
Wed Apr 22, 2026 3:53 am
Performance

Last post by Slybones « Tue Apr 21, 2026 8:12 pm

by Slybones » Tue Apr 21, 2026 8:12 pm

0 Replies

224 Views

Last post by Slybones
Tue Apr 21, 2026 8:12 pm
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

322 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

672 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

285 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

381 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

265 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

8946 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

985 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

578 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

1359 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

1603 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

941 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

3987 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

4242 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

4472 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

5963 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

5348 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

5432 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

4590 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

5244 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

4781 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

4765 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

6101 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

6160 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

6170 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

6625 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

6577 Views

Last post by bluepeter
Fri Jan 16, 2026 10:48 pm
[Solved] Fix sheet rows and column headers

Last post by FXP « Mon Jan 12, 2026 11:02 pm
Replies: 2
by FXP » Mon Jan 12, 2026 9:22 pm

2 Replies

6882 Views

Last post by FXP
Mon Jan 12, 2026 11:02 pm
[Solved] MATCH function returns Err:502

Last post by cwolan « Mon Jan 12, 2026 7:45 am
Replies: 2
by luofeiyu » Mon Jan 12, 2026 3:47 am

2 Replies

6364 Views

Last post by cwolan
Mon Jan 12, 2026 7:45 am
[Solved] Unexpected value after repeated increments

Last post by morchat « Sat Jan 10, 2026 10:12 pm
Replies: 8
by clag » Wed Jan 07, 2026 7:22 am

8 Replies

7050 Views

Last post by morchat
Sat Jan 10, 2026 10:12 pm
[Dropped] Crash with formula link to another sheet

Last post by Hagar Delest « Fri Jan 09, 2026 12:23 am
Replies: 3
by clag » Wed Jan 07, 2026 7:58 am

3 Replies

6541 Views

Last post by Hagar Delest
Fri Jan 09, 2026 12:23 am
[Solved] Can only get % formula to work partway

Last post by karolus « Tue Jan 06, 2026 4:54 am
Replies: 2
by Leiif010 » Tue Jan 06, 2026 4:16 am

2 Replies

6067 Views

Last post by karolus
Tue Jan 06, 2026 4:54 am
[Solved] Show leading zeros in numbers as spaces

Last post by clag « Sun Jan 04, 2026 12:57 pm
Replies: 5
by clag » Fri Jan 02, 2026 4:29 pm

5 Replies

6509 Views

Last post by clag
Sun Jan 04, 2026 12:57 pm
[Solved] Conditional format in lottery checker

Last post by karolus « Wed Dec 31, 2025 5:01 am
Replies: 3
by Erwin007 » Tue Dec 30, 2025 5:31 pm

3 Replies

6054 Views

Last post by karolus
Wed Dec 31, 2025 5:01 am
[Solved] Data is not sorting correctly

Last post by Lupp « Sun Dec 28, 2025 6:42 pm
Replies: 13
by php111 » Sun Dec 28, 2025 6:59 am

13 Replies

6241 Views

Last post by Lupp
Sun Dec 28, 2025 6:42 pm
[Solved] Variable Links to Named Array

Last post by Lupp « Thu Dec 25, 2025 2:41 pm
Replies: 6
by Cat101 » Fri Dec 19, 2025 7:58 pm

6 Replies

5987 Views

Last post by Lupp
Thu Dec 25, 2025 2:41 pm
[Solved] Sum of numbers that have a letter in the cell

Last post by Lupp « Wed Dec 17, 2025 2:30 pm
Replies: 2
by awascholl » Tue Dec 16, 2025 5:11 pm

2 Replies

4841 Views

Last post by Lupp
Wed Dec 17, 2025 2:30 pm
OO Calc files open in OO database

Last post by DiGro « Sun Dec 14, 2025 5:39 pm
Replies: 9
by morganmusic » Sat Dec 13, 2025 12:32 am

9 Replies

5815 Views

Last post by DiGro
Sun Dec 14, 2025 5:39 pm
[Dropped] Boolean field purpose

Last post by RoryOF « Fri Dec 12, 2025 11:33 am
Replies: 2
by White Phoenix » Fri Dec 12, 2025 4:20 am

2 Replies

4622 Views

Last post by RoryOF
Fri Dec 12, 2025 11:33 am
Count days between dates, with complex rules

Last post by karolus « Sun Dec 07, 2025 2:54 pm
Replies: 6
by Lovepreet323 » Thu Dec 04, 2025 3:44 pm

6 Replies

5357 Views

Last post by karolus
Sun Dec 07, 2025 2:54 pm
[Solved] Create pivot table with multiple columns

Last post by MrProgrammer « Sun Dec 07, 2025 3:23 am
Replies: 2
by SteveBros » Sun Dec 07, 2025 2:36 am

2 Replies

5217 Views

Last post by MrProgrammer
Sun Dec 07, 2025 3:23 am
[Solved] Partial cell Text find to new creation of new cell

Last post by ke4avb « Sat Dec 06, 2025 12:04 am
Replies: 2
by ke4avb » Fri Dec 05, 2025 4:47 pm

2 Replies

4483 Views

Last post by ke4avb
Sat Dec 06, 2025 12:04 am
[Solved] Determine signed arithmetic difference of two cells

Last post by FJCC « Fri Dec 05, 2025 4:44 pm
Replies: 10
by RMRavik » Thu Dec 04, 2025 5:22 am

10 Replies

5332 Views

Last post by FJCC
Fri Dec 05, 2025 4:44 pm

New Topic

23347 topics

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