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

Total redirects: 1097822
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 929591

Total redirects: 929591
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 937497

Total redirects: 937497
Calc Tutorials
Tutorials from this forum
Total redirects: 922131

Total redirects: 922131

New Topic

23360 topics

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

227684 Views

Last post by robleyd
Thu Nov 13, 2025 3:27 am

Topics

Replies

Views

Last post

[Solved] Limit rows and columns in a spread sheet

Last post by MrProgrammer « Sat Aug 23, 2025 12:01 am
Replies: 4
by DeziDoodle » Sun Jan 31, 2021 3:35 am

4 Replies

3090 Views

Last post by MrProgrammer
Sat Aug 23, 2025 12:01 am
[Solved] Convert multi-line data in cell to single line

Last post by Analise01 « Wed Aug 20, 2025 9:10 am
Replies: 4
by Analise01 » Sat Aug 16, 2025 3:47 pm

4 Replies

2516 Views

Last post by Analise01
Wed Aug 20, 2025 9:10 am
[Solved] Format Paintbrush in Calc

Last post by MrProgrammer « Mon Aug 18, 2025 9:10 pm
Replies: 5
by m13m13 » Sun Aug 17, 2025 6:26 pm

5 Replies

3167 Views

Last post by MrProgrammer
Mon Aug 18, 2025 9:10 pm
[Solved] Calc not printing selected sheets

Last post by lklaasen « Sun Aug 17, 2025 7:05 pm
Replies: 2
by lklaasen » Sun Aug 17, 2025 7:17 am

2 Replies

2257 Views

Last post by lklaasen
Sun Aug 17, 2025 7:05 pm
[Solved] Search for multiple values

Last post by RussvA « Fri Aug 15, 2025 1:53 pm
Replies: 9
by RussvA » Fri Aug 08, 2025 2:52 pm

9 Replies

3493 Views

Last post by RussvA
Fri Aug 15, 2025 1:53 pm
[Solved] Numbers not recognized as numeric

Last post by webmanoffesto « Thu Aug 14, 2025 7:42 pm
Replies: 4
by webmanoffesto » Thu Aug 14, 2025 3:38 am

4 Replies

2441 Views

Last post by webmanoffesto
Thu Aug 14, 2025 7:42 pm
[Solved] Save as 97-2003 Excel file

Last post by ellis03 « Thu Aug 14, 2025 12:24 am
Replies: 2
by ellis03 » Sun Aug 10, 2025 10:12 pm

2 Replies

2043 Views

Last post by ellis03
Thu Aug 14, 2025 12:24 am
[Solved] Can't get SUM to work between 3 tables in Writer

Last post by Zincht « Tue Aug 12, 2025 3:55 pm
Replies: 2
by Zincht » Mon Aug 11, 2025 5:07 am

2 Replies

2013 Views

Last post by Zincht
Tue Aug 12, 2025 3:55 pm
[Solved] Insert timestamp date in a string

Last post by cwr02 « Mon Aug 11, 2025 7:25 pm
Replies: 2
by cwr02 » Mon Aug 11, 2025 5:45 pm

2 Replies

1806 Views

Last post by cwr02
Mon Aug 11, 2025 7:25 pm
[Solved] Count column C where column D = "A"?

Last post by Kirjava « Sat Aug 09, 2025 5:59 pm
Replies: 2
by Kirjava » Sat Aug 09, 2025 5:20 pm

2 Replies

1679 Views

Last post by Kirjava
Sat Aug 09, 2025 5:59 pm
[Solved] Determine the colour I chose in a cell

Last post by nj2k25 « Wed Aug 06, 2025 12:50 am
Replies: 5
by nj2k25 » Mon Aug 04, 2025 11:14 pm

5 Replies

3618 Views

Last post by nj2k25
Wed Aug 06, 2025 12:50 am
[Dropped] Won't print all OpenOffice programs

Last post by Hagar Delest « Mon Aug 04, 2025 7:57 am
Replies: 1
by johnnyd@87 » Mon Aug 04, 2025 7:05 am

1 Replies

1962 Views

Last post by Hagar Delest
Mon Aug 04, 2025 7:57 am
[Solved] I'm getting zeros in blank cells when I print

Last post by Marscaleb « Sat Aug 02, 2025 11:04 pm
Replies: 3
by Marscaleb » Sat Aug 02, 2025 8:13 pm

3 Replies

1978 Views

Last post by Marscaleb
Sat Aug 02, 2025 11:04 pm
[Solved] Search a range and return the row's key

Last post by MrProgrammer « Tue Jul 29, 2025 8:00 pm
Replies: 1
by angelsoft » Tue Jul 29, 2025 6:58 pm

1 Replies

1759 Views

Last post by MrProgrammer
Tue Jul 29, 2025 8:00 pm
[Solved] Excel Flash Fill feature

Last post by wurty « Fri Jul 25, 2025 10:12 pm
Replies: 2
by wurty » Fri Jul 25, 2025 9:09 pm

2 Replies

1751 Views

Last post by wurty
Fri Jul 25, 2025 10:12 pm
Sort by text color

Last post by Alex1 « Fri Jul 25, 2025 8:54 am
Replies: 3
by m13m13 » Thu Jul 24, 2025 10:29 pm

3 Replies

1760 Views

Last post by Alex1
Fri Jul 25, 2025 8:54 am
DATE column sorts as text

Last post by MrProgrammer « Fri Jul 25, 2025 3:50 am
Replies: 11
by THEBookMan » Wed Jul 23, 2025 4:40 pm

11 Replies

2927 Views

Last post by MrProgrammer
Fri Jul 25, 2025 3:50 am
[Solved] Apply formula to entire sheet

Last post by MrProgrammer « Tue Jul 22, 2025 3:35 am
Replies: 1
by xorg » Tue Jul 22, 2025 1:54 am

1 Replies

1502 Views

Last post by MrProgrammer
Tue Jul 22, 2025 3:35 am
[Example] Soccer football table

Last post by MrProgrammer « Sun Jul 20, 2025 10:46 pm
Replies: 4
by Obi » Sun Jul 20, 2025 4:13 am

4 Replies

2000 Views

Last post by MrProgrammer
Sun Jul 20, 2025 10:46 pm
[Solved] Can't rename sheet or delete sheet

Last post by MrProgrammer « Thu Jul 17, 2025 8:51 pm
Replies: 8
by dandavis » Mon Jul 14, 2025 10:26 pm

8 Replies

2085 Views

Last post by MrProgrammer
Thu Jul 17, 2025 8:51 pm
[Solved] Create running tally

Last post by MrProgrammer « Thu Jul 17, 2025 4:46 pm
Replies: 1
by ncheckland@gmail.com » Thu Jul 17, 2025 3:52 pm

1 Replies

1390 Views

Last post by MrProgrammer
Thu Jul 17, 2025 4:46 pm
[Solved] Lost 500 rows

Last post by THEBookMan « Mon Jul 14, 2025 2:45 pm
Replies: 2
by THEBookMan » Sun Jul 13, 2025 5:08 pm

2 Replies

1979 Views

Last post by THEBookMan
Mon Jul 14, 2025 2:45 pm
[Solved] Single letters shown as spelling mistake

Last post by jimbokea2 « Mon Jul 14, 2025 2:57 am
Replies: 2
by jimbokea2 » Mon Jul 14, 2025 12:26 am

2 Replies

1415 Views

Last post by jimbokea2
Mon Jul 14, 2025 2:57 am
[Solved] Unable to get COUNTIF to work

Last post by dobrphi « Sun Jul 13, 2025 3:10 am
Replies: 2
by dobrphi » Sat Jul 12, 2025 11:44 pm

2 Replies

1497 Views

Last post by dobrphi
Sun Jul 13, 2025 3:10 am
UK VAT making tax digital API

Last post by Lupp « Fri Jul 11, 2025 9:03 pm
Replies: 7
by Lupin » Tue Apr 16, 2019 10:41 am

7 Replies

4006 Views

Last post by Lupp
Fri Jul 11, 2025 9:03 pm
[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

1494 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

3674 Views

Last post by Hagar Delest
Thu Jul 03, 2025 12:04 pm
[Dropped] 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

1449 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

1445 Views

Last post by donnje
Tue Jul 01, 2025 9:07 pm
[Dropped] 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

2009 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

5382 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

1575 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

1997 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

2056 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

4129 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

2443 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

3594 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

1516 Views

Last post by MrProgrammer
Mon Jun 02, 2025 3:22 pm
CashRegister and Advanced Filter files

Last post by steverat « Wed May 28, 2025 7:41 pm
Replies: 2
by steverat » Wed Apr 23, 2025 9:05 pm

2 Replies

2332 Views

Last post by steverat
Wed May 28, 2025 7:41 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

1699 Views

Last post by Alex1
Wed May 28, 2025 10:21 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

1417 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

2416 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

1266 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

3177 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

1481 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

2010 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

1050 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

30684 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

1016 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

966 Views

Last post by cephas
Sun May 11, 2025 11:36 pm

New Topic

23360 topics

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