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

Total redirects: 697194
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 542439

Total redirects: 542439
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 550852

Total redirects: 550852
Calc Tutorials
Tutorials from this forum
Total redirects: 540382

Total redirects: 540382

New Topic

23247 topics

Page 1 of 465
- Jump to page:
1
2
3
4
5
…
465
Next

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.15 released

Last post by robleyd « Sat Dec 23, 2023 3:55 am
Posted in Announcements

by robleyd » Sat Dec 23, 2023 3:55 am » in Announcements

0 Replies

303952 Views

Last post by robleyd
Sat Dec 23, 2023 3:55 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

107819 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
UK VAT making tax digital API

Last post by JasperLeonson « Wed Jul 09, 2025 11:12 am
Replies: 5
by Lupin » Tue Apr 16, 2019 10:41 am

5 Replies

2166 Views

Last post by JasperLeonson
Wed Jul 09, 2025 11:12 am
[Solved] Cell jumps, page shifts

Last post by lexmailman « Sun Jul 06, 2025 5:53 pm
Replies: 2
by lexmailman » Sat Jul 05, 2025 6:31 pm

2 Replies

171 Views

Last post by lexmailman
Sun Jul 06, 2025 5:53 pm
[Solved] Clear cells matching column B

Last post by Hagar Delest « Thu Jul 03, 2025 12:04 pm
Replies: 15
by turbo_mapper » Mon Jun 30, 2025 11:42 am

15 Replies

470 Views

Last post by Hagar Delest
Thu Jul 03, 2025 12:04 pm
Spreadsheet won't allow data to be entered

Last post by MrProgrammer « Wed Jul 02, 2025 11:35 pm
Replies: 2
by patkesl99 » Tue Jul 01, 2025 7:54 pm

2 Replies

258 Views

Last post by MrProgrammer
Wed Jul 02, 2025 11:35 pm
[Solved] Make comment flag more visible

Last post by donnje « Tue Jul 01, 2025 9:07 pm
Replies: 2
by donnje » Tue Jul 01, 2025 7:09 pm

2 Replies

212 Views

Last post by donnje
Tue Jul 01, 2025 9:07 pm
Count of elapsed days between monthly dates

Last post by Zizi64 « Fri Jun 27, 2025 6:04 am
Replies: 3
by wireflight » Thu Jun 26, 2025 9:53 pm

3 Replies

348 Views

Last post by Zizi64
Fri Jun 27, 2025 6:04 am
[Solved] 256 column limit in XLS spreadsheet

Last post by MrProgrammer « Wed Jun 25, 2025 4:30 am
Replies: 9
by KeithOO » Wed Jun 12, 2019 8:02 am

9 Replies

3421 Views

Last post by MrProgrammer
Wed Jun 25, 2025 4:30 am
[Solved] Horizontal line in chart

Last post by cwolan « Sat Jun 21, 2025 6:04 am
Replies: 2
by Stulensmelvin » Fri Jun 20, 2025 9:30 pm

2 Replies

328 Views

Last post by cwolan
Sat Jun 21, 2025 6:04 am
ODS file got corrupted

Last post by John_Ha « Fri Jun 20, 2025 8:44 pm
Replies: 6
by jerc9024 » Fri Jun 20, 2025 6:09 pm

6 Replies

377 Views

Last post by John_Ha
Fri Jun 20, 2025 8:44 pm
[Solved] LO 25.2.3 Page Numbers

Last post by Oskar4U « Wed Jun 18, 2025 4:34 pm
Replies: 7
by Oskar4U » Tue Jun 17, 2025 8:50 pm

7 Replies

374 Views

Last post by Oskar4U
Wed Jun 18, 2025 4:34 pm
[Issue] Picture anchored to cell erratically moves

Last post by cwolan « Sun Jun 15, 2025 7:51 pm
Replies: 20
by giuvi » Mon Jun 02, 2025 9:10 pm

20 Replies

996 Views

Last post by cwolan
Sun Jun 15, 2025 7:51 pm
[Solved] Font Color Change

Last post by tsfrance « Wed Jun 11, 2025 7:49 pm
Replies: 10
by tsfrance » Tue Jun 10, 2025 12:52 am

10 Replies

553 Views

Last post by tsfrance
Wed Jun 11, 2025 7:49 pm
[Solved] Chart for arrival and departure times

Last post by MrProgrammer « Sun Jun 08, 2025 6:06 pm
Replies: 14
by ZManMatt » Tue Jun 03, 2025 10:37 am

14 Replies

871 Views

Last post by MrProgrammer
Sun Jun 08, 2025 6:06 pm
[Solved] Paste special option doesn't appear

Last post by MrProgrammer « Mon Jun 02, 2025 3:22 pm
Replies: 2
by rjww » Sat May 31, 2025 5:48 pm

2 Replies

388 Views

Last post by MrProgrammer
Mon Jun 02, 2025 3:22 pm
[Solved] Spreadsheets won't open in Windows 11

Last post by Alex1 « Wed May 28, 2025 10:21 am
Replies: 5
by macxx1 » Wed May 28, 2025 4:48 am

5 Replies

398 Views

Last post by Alex1
Wed May 28, 2025 10:21 am
"Not all attributes could be read"

Last post by kingfisher « Wed May 28, 2025 10:07 am
Replies: 9
by kingfisher » Sat May 24, 2025 6:50 am

9 Replies

587 Views

Last post by kingfisher
Wed May 28, 2025 10:07 am
[Solved] Eliminate unwanted keys in sort dialog

Last post by John_Ha « Mon May 26, 2025 8:24 pm
Replies: 1
by John_Ha » Mon May 26, 2025 8:14 pm

1 Replies

287 Views

Last post by John_Ha
Mon May 26, 2025 8:24 pm
[Solved] Sum sorted data which will be un-sorted

Last post by Villeroy « Thu May 22, 2025 7:51 pm
Replies: 6
by John_Ha » Wed May 21, 2025 2:58 pm

6 Replies

451 Views

Last post by Villeroy
Thu May 22, 2025 7:51 pm
[Solved] Lots of push buttons in Calc

Last post by Zizi64 « Thu May 22, 2025 8:12 am
Replies: 2
by PooNya » Thu May 22, 2025 5:27 am

2 Replies

339 Views

Last post by Zizi64
Thu May 22, 2025 8:12 am
[Solved] Current date in validity dropdown list

Last post by Alex1 « Wed May 21, 2025 9:30 pm
Replies: 18
by donnje » Tue May 20, 2025 8:48 am

18 Replies

591 Views

Last post by Alex1
Wed May 21, 2025 9:30 pm
[Solved] Search for duplicates in two Calc files

Last post by Alex1 « Wed May 21, 2025 5:08 pm
Replies: 4
by THEBookMan » Tue May 20, 2025 4:46 pm

4 Replies

383 Views

Last post by Alex1
Wed May 21, 2025 5:08 pm
[Solved] Ignore cell value for SUM function

Last post by Jessiebessie « Tue May 20, 2025 10:52 am
Replies: 9
by Jessiebessie » Mon May 19, 2025 9:26 am

9 Replies

462 Views

Last post by Jessiebessie
Tue May 20, 2025 10:52 am
[Solved] Replace all dots with commas for Swedish data

Last post by MrProgrammer « Tue May 20, 2025 2:06 am
Replies: 2
by endian » Mon May 19, 2025 9:49 pm

2 Replies

352 Views

Last post by MrProgrammer
Tue May 20, 2025 2:06 am
[Solved] Corrupted .ods file, V4.1.15, Windows 11

Last post by thebigoo@gmail.com « Tue May 20, 2025 12:32 am

by thebigoo@gmail.com » Tue May 20, 2025 12:32 am

0 Replies

420 Views

Last post by thebigoo@gmail.com
Tue May 20, 2025 12:32 am
[Solved] LibreOffice: Copy in Calc, Paste in Writer

Last post by Alex in Grimsby « Mon May 12, 2025 3:49 pm
Replies: 2
by Alex in Grimsby » Sat May 10, 2025 4:45 pm

2 Replies

372 Views

Last post by Alex in Grimsby
Mon May 12, 2025 3:49 pm
[Solved] Using EDATE in a formula

Last post by cephas « Sun May 11, 2025 11:36 pm
Replies: 2
by cephas » Sat May 10, 2025 11:29 pm

2 Replies

348 Views

Last post by cephas
Sun May 11, 2025 11:36 pm
[Solved] Sort incremented dates

Last post by cephas « Sat May 10, 2025 11:31 pm
Replies: 13
by cephas » Fri May 02, 2025 6:15 am

13 Replies

781 Views

Last post by cephas
Sat May 10, 2025 11:31 pm
[Solved] VLOOKUP returns incorrect data

Last post by Sanman « Tue May 06, 2025 1:13 pm
Replies: 10
by Sanman » Thu May 01, 2025 11:45 am

10 Replies

568 Views

Last post by Sanman
Tue May 06, 2025 1:13 pm
[Solved] Import CSV into spreadsheet

Last post by Villeroy « Mon May 05, 2025 6:48 pm
Replies: 3
by PurebldKING » Fri May 02, 2025 4:47 pm

3 Replies

479 Views

Last post by Villeroy
Mon May 05, 2025 6:48 pm
Scroll Bar Arrows Hidden

Last post by MrProgrammer « Sun May 04, 2025 3:34 pm
Replies: 3
by loneieagle » Sun May 04, 2025 6:42 am

3 Replies

349 Views

Last post by MrProgrammer
Sun May 04, 2025 3:34 pm
[Solved] A2 in VLOOKUP unchanged by copy down

Last post by Sanman « Wed Apr 30, 2025 5:17 am
Replies: 7
by Sanman » Tue Apr 29, 2025 3:11 pm

7 Replies

392 Views

Last post by Sanman
Wed Apr 30, 2025 5:17 am
[Solved] Problem: Calc File won't open after power outage

Last post by RoryOF « Mon Apr 28, 2025 8:49 am
Replies: 7
by Z-Syl » Sun Apr 27, 2025 6:15 pm

7 Replies

472 Views

Last post by RoryOF
Mon Apr 28, 2025 8:49 am
[Solved] Comment size changes

Last post by THEBookMan « Wed Apr 23, 2025 10:28 pm
Replies: 5
by THEBookMan » Tue Apr 22, 2025 9:55 pm

5 Replies

470 Views

Last post by THEBookMan
Wed Apr 23, 2025 10:28 pm
[Solved] Make hidden row indicator more visible

Last post by quarkrad « Sat Apr 19, 2025 8:26 pm
Replies: 2
by quarkrad » Sat Apr 19, 2025 12:08 pm

2 Replies

356 Views

Last post by quarkrad
Sat Apr 19, 2025 8:26 pm
[Solved] Add cells from sheets 2,3,4 on sheet 1

Last post by TomDo « Thu Apr 17, 2025 6:05 am
Replies: 13
by TomDo » Tue Apr 15, 2025 9:44 pm

13 Replies

657 Views

Last post by TomDo
Thu Apr 17, 2025 6:05 am
[Solved] Lockup on Copy

Last post by RoryOF « Sun Apr 13, 2025 10:16 pm
Replies: 1
by DWDun » Sun Apr 13, 2025 10:00 pm

1 Replies

280 Views

Last post by RoryOF
Sun Apr 13, 2025 10:16 pm
[Solved] Single formula not calculating in an otherwise functioning sheet

Last post by MrProgrammer « Thu Apr 10, 2025 3:02 am
Replies: 3
by bc@carfac.ca » Wed Apr 09, 2025 8:14 pm

3 Replies

421 Views

Last post by MrProgrammer
Thu Apr 10, 2025 3:02 am
[Solved] Check if cell is greater than 9, but not equal to x

Last post by PuShErD « Tue Apr 08, 2025 11:16 pm
Replies: 11
by PuShErD » Sun Apr 06, 2025 2:28 pm

11 Replies

744 Views

Last post by PuShErD
Tue Apr 08, 2025 11:16 pm
[Dropped] Sort more than 3 columns

Last post by Lupp « Tue Apr 08, 2025 2:53 pm
Replies: 3
by desdichato » Mon Apr 07, 2025 2:08 am

3 Replies

478 Views

Last post by Lupp
Tue Apr 08, 2025 2:53 pm
[Solved] SUMIF(F52:AQ52;"$";F52:AQ52) is zero

Last post by me231 « Sat Apr 05, 2025 7:37 pm
Replies: 8
by me231 » Fri Apr 04, 2025 9:58 pm

8 Replies

1408 Views

Last post by me231
Sat Apr 05, 2025 7:37 pm
[Dropped] Check Boxes in XLSX not displayed on line / form correctly

Last post by Hagar Delest « Fri Apr 04, 2025 10:05 pm
Replies: 1
by DrJ007 » Fri Apr 04, 2025 7:34 pm

1 Replies

962 Views

Last post by Hagar Delest
Fri Apr 04, 2025 10:05 pm
[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

1691 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

8256 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

1839 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

2345 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

2095 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

2191 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

2521 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

2227 Views

Last post by MrProgrammer
Mon Mar 24, 2025 12:35 am

New Topic

23247 topics

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