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

Total redirects: 778573
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 623190

Total redirects: 623190
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 631713

Total redirects: 631713
Calc Tutorials
Tutorials from this forum
Total redirects: 620024

Total redirects: 620024

New Topic

23330 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

49306 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

112628 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
Add condition to IF

Last post by donnje « Sat Feb 07, 2026 3:21 pm
Replies: 13
by donnje » Sun Feb 01, 2026 7:06 pm

13 Replies

629 Views

Last post by donnje
Sat Feb 07, 2026 3:21 pm
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

528 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

912 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

481 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

821 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

825 Views

Last post by taylor.r113y
Tue Jan 27, 2026 8:37 pm
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

773 Views

Last post by crusader
Tue Jan 27, 2026 12:46 am
LO Calc Focus/Input Mode

Last post by crusader « Mon Jan 26, 2026 6:42 pm
Replies: 1
by crusader » Sun Jan 25, 2026 12:18 am

1 Replies

952 Views

Last post by crusader
Mon Jan 26, 2026 6:42 pm
[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

1959 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

1967 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

1936 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

2388 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

2474 Views

Last post by bluepeter
Fri Jan 16, 2026 10:48 pm
[Dropped] Unexpected references used when copying

Last post by FJCC « Fri Jan 16, 2026 6:47 am
Replies: 1
by Dongatrash » Fri Jan 16, 2026 5:56 am

1 Replies

2434 Views

Last post by FJCC
Fri Jan 16, 2026 6:47 am
[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

2319 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

2189 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

2387 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

2387 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

2218 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

2494 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

2796 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

2649 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

2888 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

2341 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

2651 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

2150 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

2531 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

2503 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

1972 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

2278 Views

Last post by FJCC
Fri Dec 05, 2025 4:44 pm
Keys allocated to Calc macros cleared on update

Last post by MrProgrammer « Wed Dec 03, 2025 11:49 pm
Replies: 4
by Phillip » Tue Nov 25, 2025 5:34 pm

4 Replies

1916 Views

Last post by MrProgrammer
Wed Dec 03, 2025 11:49 pm
[Solved] Set absolute cell reference with F4

Last post by dsmccarron « Wed Nov 26, 2025 11:25 pm
Replies: 6
by dsmccarron » Wed Nov 26, 2025 7:06 am

6 Replies

1821 Views

Last post by dsmccarron
Wed Nov 26, 2025 11:25 pm
[Solved] Print part of a page

Last post by Oskar4U « Wed Nov 26, 2025 6:13 am
Replies: 2
by Oskar4U » Wed Nov 26, 2025 12:54 am

2 Replies

1512 Views

Last post by Oskar4U
Wed Nov 26, 2025 6:13 am
[Dropped] "Find" function crashes AOO

Last post by Bidouille « Mon Nov 24, 2025 4:01 pm
Replies: 5
by Aragon476 » Mon Nov 17, 2025 7:00 pm

5 Replies

1690 Views

Last post by Bidouille
Mon Nov 24, 2025 4:01 pm
[Dropped] ChatGPT wants me to upload *.xlsx

Last post by Hagar Delest « Tue Nov 18, 2025 10:32 pm
Replies: 4
by EasyWrites » Tue Nov 18, 2025 1:13 am

4 Replies

1695 Views

Last post by Hagar Delest
Tue Nov 18, 2025 10:32 pm
[Solved] Sort by date

Last post by MrProgrammer « Tue Nov 18, 2025 4:31 am
Replies: 4
by phire404 » Tue Nov 18, 2025 12:09 am

4 Replies

1663 Views

Last post by MrProgrammer
Tue Nov 18, 2025 4:31 am
[Dropped] Put icons from sidebar on top toolbar

Last post by Alex1 « Wed Nov 05, 2025 10:26 pm
Replies: 9
by NE Oh cat person » Wed Oct 29, 2025 3:34 am

9 Replies

2010 Views

Last post by Alex1
Wed Nov 05, 2025 10:26 pm
[Dropped] If Statement

Last post by floris v « Tue Nov 04, 2025 4:44 pm
Replies: 2
by bmelvin » Tue Nov 04, 2025 4:05 pm

2 Replies

1500 Views

Last post by floris v
Tue Nov 04, 2025 4:44 pm
[Solved] Copy values into a text template

Last post by MrProgrammer « Tue Nov 04, 2025 6:01 am
Replies: 1
by awascholl » Tue Nov 04, 2025 2:50 am

1 Replies

1422 Views

Last post by MrProgrammer
Tue Nov 04, 2025 6:01 am
[Solved] Request for comments: Macros for defined names

Last post by cwolan « Sun Nov 02, 2025 7:06 pm
Replies: 5
by MrProgrammer » Wed Oct 29, 2025 11:59 pm

5 Replies

1708 Views

Last post by cwolan
Sun Nov 02, 2025 7:06 pm
[Solved] Add value from other page indicated from a cell

Last post by Puxo « Sat Nov 01, 2025 11:44 pm
Replies: 2
by Puxo » Sat Nov 01, 2025 12:53 pm

2 Replies

1482 Views

Last post by Puxo
Sat Nov 01, 2025 11:44 pm
[Solved] Cells are very small when opening files

Last post by KevL « Tue Oct 28, 2025 6:28 am
Replies: 2
by KevL » Mon Oct 27, 2025 7:31 am

2 Replies

1478 Views

Last post by KevL
Tue Oct 28, 2025 6:28 am
[Solved] Adjust range in formula when inserting column

Last post by MrProgrammer « Tue Oct 21, 2025 8:02 pm
Replies: 5
by quarkrad » Mon Oct 20, 2025 8:27 pm

5 Replies

2043 Views

Last post by MrProgrammer
Tue Oct 21, 2025 8:02 pm
[Solved] Change color of active cell border

Last post by MFL_2024 « Sat Oct 18, 2025 9:56 pm
Replies: 3
by MFL_2024 » Fri Oct 17, 2025 5:52 pm

3 Replies

1637 Views

Last post by MFL_2024
Sat Oct 18, 2025 9:56 pm
[Solved] Error: Bad Allocation

Last post by Bidouille « Thu Oct 16, 2025 4:03 pm
Replies: 2
by Sonhos » Tue Oct 14, 2025 4:38 pm

2 Replies

1645 Views

Last post by Bidouille
Thu Oct 16, 2025 4:03 pm
[Solved] Calc toolbar search box causes crash

Last post by HansMo « Sat Oct 11, 2025 10:51 pm
Replies: 4
by HansMo » Fri Oct 10, 2025 2:57 am

4 Replies

1700 Views

Last post by HansMo
Sat Oct 11, 2025 10:51 pm
[Solved] 2-digit date conversion inconsistency

Last post by Alex1 « Mon Oct 06, 2025 11:48 am
Replies: 4
by jbilliter » Mon Oct 06, 2025 2:35 am

4 Replies

2117 Views

Last post by Alex1
Mon Oct 06, 2025 11:48 am
[Dropped] Can't add icons to toolbar

Last post by Rizwan Akhtar « Thu Oct 02, 2025 11:13 am
Replies: 2
by NE Oh cat person » Thu Oct 02, 2025 5:27 am

2 Replies

1875 Views

Last post by Rizwan Akhtar
Thu Oct 02, 2025 11:13 am
[Solved] Unexpected result from =SUM((I3:I14)/12)

Last post by Lupp « Mon Sep 29, 2025 6:58 pm
Replies: 9
by Dronz » Sun Sep 28, 2025 5:40 am

9 Replies

2099 Views

Last post by Lupp
Mon Sep 29, 2025 6:58 pm

New Topic

23330 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