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

Total redirects: 695750
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 540957

Total redirects: 540957
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 549349

Total redirects: 549349
Calc Tutorials
Tutorials from this forum
Total redirects: 538928

Total redirects: 538928

New Topic

23239 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

300244 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

107674 Views

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

714 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

394 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

740 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

313 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

311 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

488 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

221 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

387 Views

Last post by Villeroy
Thu May 22, 2025 7:51 pm
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

271 Views

Last post by Zizi64
Thu May 22, 2025 8:12 am
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

505 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

317 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

384 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

280 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

239 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

318 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

282 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

702 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

496 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

416 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

294 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

330 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

394 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

434 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

337 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

603 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

257 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

390 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

698 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

452 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

1373 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

942 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

1668 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

8186 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

1809 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

2319 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

2065 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

2163 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

2492 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

2201 Views

Last post by MrProgrammer
Mon Mar 24, 2025 12:35 am
[Solved] Search for name in multiple sheets

Last post by DiGro « Sun Mar 23, 2025 12:29 pm
Replies: 3
by timlab55 » Sat Mar 22, 2025 5:49 pm

3 Replies

2197 Views

Last post by DiGro
Sun Mar 23, 2025 12:29 pm
[Solved+Issue] Change sheet tab appearance size

Last post by sufferer « Sat Mar 22, 2025 6:44 pm
Replies: 3
by sufferer » Sat Mar 22, 2025 5:01 pm

3 Replies

2168 Views

Last post by sufferer
Sat Mar 22, 2025 6:44 pm
[Solved+Issue] Sheet names are too small

Last post by Hagar Delest « Thu Mar 20, 2025 5:09 pm
Replies: 10
by fad » Wed Mar 19, 2025 5:10 pm

10 Replies

2642 Views

Last post by Hagar Delest
Thu Mar 20, 2025 5:09 pm
[Solved] ODS file corrupted requires help from expert

Last post by cwolan « Mon Mar 17, 2025 5:16 pm
Replies: 10
by jgrona » Mon Mar 17, 2025 11:33 am

10 Replies

2991 Views

Last post by cwolan
Mon Mar 17, 2025 5:16 pm
Reassign spreadsheet templates

Last post by White Phoenix « Mon Mar 17, 2025 12:26 am
Replies: 3
by White Phoenix » Mon Feb 24, 2025 10:20 pm

3 Replies

5049 Views

Last post by White Phoenix
Mon Mar 17, 2025 12:26 am
[Solved] Unexpected text color in cells; can't change

Last post by DWDun « Sat Mar 15, 2025 8:47 pm
Replies: 2
by DWDun » Sat Mar 15, 2025 7:15 pm

2 Replies

2284 Views

Last post by DWDun
Sat Mar 15, 2025 8:47 pm
[Solved] Remove space at beginning/end of cell

Last post by karolus « Fri Mar 14, 2025 10:50 am
Replies: 2
by THEBookMan » Thu Mar 13, 2025 10:16 pm

2 Replies

2341 Views

Last post by karolus
Fri Mar 14, 2025 10:50 am
[Solved] Set character limit for cell

Last post by MrProgrammer « Thu Mar 13, 2025 10:11 pm
Replies: 7
by evets » Sun Nov 27, 2022 12:26 am

7 Replies

5574 Views

Last post by MrProgrammer
Thu Mar 13, 2025 10:11 pm
[Solved] SUMIF not adding based on day of week

Last post by boydfritsch « Thu Mar 13, 2025 7:00 pm
Replies: 5
by boydfritsch » Wed Mar 12, 2025 11:01 pm

5 Replies

2533 Views

Last post by boydfritsch
Thu Mar 13, 2025 7:00 pm
[Solved] Match category name for SUMPRODUCT

Last post by youni « Thu Mar 13, 2025 6:54 pm
Replies: 2
by youni » Thu Mar 13, 2025 1:35 pm

2 Replies

2230 Views

Last post by youni
Thu Mar 13, 2025 6:54 pm

New Topic

23239 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