Apache OpenOffice Community Forum - Calc - (View forum)

Calc

Forum

Topics

Posts

Last post

Calc Guide for 4.x
Apache OpenOffice 4.x User Guides - PDF chapters (DEC-2022)
Total redirects: 710445

Total redirects: 710445
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 555886

Total redirects: 555886
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 564342

Total redirects: 564342
Calc Tutorials
Tutorials from this forum
Total redirects: 553638

Total redirects: 553638

New Topic

23275 topics

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

317610 Views

Last post by robleyd
Sat Dec 23, 2023 3:55 am

Topics

Replies

Views

Last post

[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

887 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

689 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

1671 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

605 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

563 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

929 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

724 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

652 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

471 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

555 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

615 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

612 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

484 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

840 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

377 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

542 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

925 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

588 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

1540 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

1048 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

1769 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

8516 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

1917 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

2400 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

2115 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

2226 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

2572 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

2264 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

2247 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

2227 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

2725 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

3053 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

5103 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

2331 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

2403 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

6550 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

2577 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

2267 Views

Last post by youni
Thu Mar 13, 2025 6:54 pm
[Solved] Convert function result to cell formula

Last post by Gonzo714 « Mon Mar 10, 2025 7:43 pm
Replies: 2
by Gonzo714 » Mon Mar 10, 2025 6:51 pm

2 Replies

2085 Views

Last post by Gonzo714
Mon Mar 10, 2025 7:43 pm
[Solved] Err:508 in Excel lookup formula

Last post by BulletBS « Mon Mar 10, 2025 12:12 am
Replies: 2
by BulletBS » Sun Mar 09, 2025 6:28 pm

2 Replies

2156 Views

Last post by BulletBS
Mon Mar 10, 2025 12:12 am
[Solved] If formula returns error show empty cell

Last post by Lupp « Fri Mar 07, 2025 6:30 pm
Replies: 4
by Bushido222 » Wed Feb 19, 2025 3:18 am

4 Replies

5350 Views

Last post by Lupp
Fri Mar 07, 2025 6:30 pm
[Solved] Which character set to use for document recovery?

Last post by RoryOF « Fri Mar 07, 2025 12:31 pm
Replies: 3
by PontiacKiller » Fri Mar 07, 2025 12:09 am

3 Replies

2219 Views

Last post by RoryOF
Fri Mar 07, 2025 12:31 pm
[Solved] Keep column headers visible at top

Last post by Oskar4U « Thu Mar 06, 2025 5:48 pm
Replies: 2
by Oskar4U » Thu Mar 06, 2025 1:47 pm

2 Replies

1950 Views

Last post by Oskar4U
Thu Mar 06, 2025 5:48 pm
[Solved] Change column headings, currently A, B, C, …

Last post by robleyd « Thu Mar 06, 2025 8:35 am
Replies: 3
by ray5450 » Thu Mar 06, 2025 7:05 am

3 Replies

2105 Views

Last post by robleyd
Thu Mar 06, 2025 8:35 am
[Solved] Sum column D if column E is empty

Last post by morganmusic « Mon Mar 03, 2025 8:55 pm
Replies: 5
by morganmusic » Sun Mar 02, 2025 10:03 pm

5 Replies

2241 Views

Last post by morganmusic
Mon Mar 03, 2025 8:55 pm
Comments on Natural Sort topic 112556

Last post by Lupp « Mon Mar 03, 2025 8:37 pm
Replies: 4
by Lupp » Mon Mar 03, 2025 3:36 pm

4 Replies

2157 Views

Last post by Lupp
Mon Mar 03, 2025 8:37 pm
[Solved] Calculated % in one cell <> identical % Etered in another cell

Last post by DWDun « Sun Mar 02, 2025 8:24 pm
Replies: 5
by DWDun » Sun Mar 02, 2025 12:13 am

5 Replies

2644 Views

Last post by DWDun
Sun Mar 02, 2025 8:24 pm
[Solved] Multiple statistics in status bar: SUM and COUNT

Last post by FRR « Sun Mar 02, 2025 12:20 pm
Replies: 2
by FRR » Sun Mar 02, 2025 11:31 am

2 Replies

2082 Views

Last post by FRR
Sun Mar 02, 2025 12:20 pm
[Solved] Text and formula with space in same cell

Last post by bryan.hoffmann « Fri Feb 28, 2025 3:49 pm
Replies: 19
by Kenmc » Sun Jun 28, 2015 10:09 pm

19 Replies

10917 Views

Last post by bryan.hoffmann
Fri Feb 28, 2025 3:49 pm
[Solved] Astronomy binary star chart

Last post by MrProgrammer « Thu Feb 27, 2025 5:11 pm
Replies: 9
by marty-0750 » Tue Feb 25, 2025 2:10 pm

9 Replies

4488 Views

Last post by MrProgrammer
Thu Feb 27, 2025 5:11 pm

New Topic

23275 topics

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