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

Total redirects: 726682
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 573668

Total redirects: 573668
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 581572

Total redirects: 581572
Calc Tutorials
Tutorials from this forum
Total redirects: 570796

Total redirects: 570796

New Topic

23298 topics

Page 1 of 466
- Jump to page:
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

333579 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

109705 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
Can the sidebar icons be moved to (top) function 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

316 Views

Last post by Alex1
Wed Nov 05, 2025 10:26 pm
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

118 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

91 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

250 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

81 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

157 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

326 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

243 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

230 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

329 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

724 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

552 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

667 Views

Last post by Lupp
Mon Sep 29, 2025 6:58 pm
[Solved] Enter key doesn't do calculation

Last post by Max1950 « Sat Sep 27, 2025 8:46 pm
Replies: 2
by Max1950 » Sat Sep 27, 2025 6:02 pm

2 Replies

354 Views

Last post by Max1950
Sat Sep 27, 2025 8:46 pm
[Dropped] Random blank cell

Last post by FJCC « Sat Sep 27, 2025 3:43 pm
Replies: 1
by cburge » Sat Sep 27, 2025 9:43 am

1 Replies

303 Views

Last post by FJCC
Sat Sep 27, 2025 3:43 pm
[Example] Forecast budgeted revenue/expenses for stock market

Last post by taylor.r113y « Thu Sep 25, 2025 2:37 pm
Replies: 1
by taylor.r113y » Thu Sep 25, 2025 2:27 pm

1 Replies

445 Views

Last post by taylor.r113y
Thu Sep 25, 2025 2:37 pm
[Solved] Set cell's colour based on its value

Last post by KISSMAD « Thu Sep 25, 2025 2:32 pm
Replies: 2
by KISSMAD » Thu Sep 25, 2025 9:34 am

2 Replies

351 Views

Last post by KISSMAD
Thu Sep 25, 2025 2:32 pm
[Solved] Display link as hyperlink, not as text

Last post by Oskar4U « Sun Sep 21, 2025 6:09 am
Replies: 2
by Oskar4U » Sun Sep 21, 2025 3:32 am

2 Replies

741 Views

Last post by Oskar4U
Sun Sep 21, 2025 6:09 am
[Solved] Set default border color of cells

Last post by robleyd « Sat Sep 20, 2025 6:37 pm
Replies: 1
by DylansShoes » Sat Sep 20, 2025 6:29 pm

1 Replies

524 Views

Last post by robleyd
Sat Sep 20, 2025 6:37 pm
[Example] Update soccer football table 2

Last post by Obi « Thu Sep 18, 2025 2:22 am

by Obi » Thu Sep 18, 2025 2:22 am

0 Replies

1090 Views

Last post by Obi
Thu Sep 18, 2025 2:22 am
[Example] Cubic equations and Newton's iteration method

Last post by MrProgrammer « Wed Sep 17, 2025 11:33 pm
Replies: 1
by Lupp » Wed Sep 17, 2025 7:20 pm

1 Replies

637 Views

Last post by MrProgrammer
Wed Sep 17, 2025 11:33 pm
[Example] Cubic equation solver

Last post by MrProgrammer « Sun Sep 14, 2025 6:04 pm

by MrProgrammer » Sun Sep 14, 2025 6:04 pm

0 Replies

1206 Views

Last post by MrProgrammer
Sun Sep 14, 2025 6:04 pm
[Solved] Determine points at end of week

Last post by taylor.r113y « Fri Sep 12, 2025 6:00 am
Replies: 9
by taylor.r113y » Wed Sep 10, 2025 11:23 pm

9 Replies

1416 Views

Last post by taylor.r113y
Fri Sep 12, 2025 6:00 am
[Example] Tetrahedral transform: 6D data to 4D

Last post by Romano « Thu Sep 11, 2025 11:19 am

by Romano » Thu Sep 11, 2025 11:19 am

0 Replies

1017 Views

Last post by Romano
Thu Sep 11, 2025 11:19 am
[Solved+Issue] Change the color of a hyperlink text

Last post by MrProgrammer « Wed Sep 10, 2025 9:31 pm
Replies: 15
by seni » Tue Sep 09, 2025 5:45 pm

15 Replies

1383 Views

Last post by MrProgrammer
Wed Sep 10, 2025 9:31 pm
[Solved] Problem with adding (Again)

Last post by timlab55 « Sun Aug 31, 2025 2:14 pm
Replies: 4
by timlab55 » Sun Aug 31, 2025 5:29 am

4 Replies

1517 Views

Last post by timlab55
Sun Aug 31, 2025 2:14 pm
[Solved] Using Find drop-down causes crashed documents

Last post by Hagar Delest « Fri Aug 29, 2025 8:02 am
Replies: 5
by m13m13 » Thu Aug 28, 2025 9:48 pm

5 Replies

1621 Views

Last post by Hagar Delest
Fri Aug 29, 2025 8:02 am
[Dropped] Default date and time formats

Last post by MrProgrammer « Mon Aug 25, 2025 4:00 pm
Replies: 1
by arjensmit » Mon Aug 25, 2025 12:34 pm

1 Replies

1710 Views

Last post by MrProgrammer
Mon Aug 25, 2025 4:00 pm
[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

2323 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

1662 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

1816 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

1602 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

2172 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

1598 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

1506 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

1475 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

1319 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

1228 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

1916 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

1365 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

1313 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

1257 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

1318 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

1345 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

1892 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

1274 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

1476 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

1548 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

1193 Views

Last post by MrProgrammer
Thu Jul 17, 2025 4:46 pm

New Topic

23298 topics

Page 1 of 466
- Jump to page:
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