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

Total redirects: 923842
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 774454

Total redirects: 774454
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 783473

Total redirects: 783473
Calc Tutorials
Tutorials from this forum
Total redirects: 770512

Total redirects: 770512

New Topic

23347 topics

Page 6 of 467
- Jump to page:
Previous
1
…
4
5
6
7
8
…
467
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

135754 Views

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

Topics

Replies

Views

Last post

[Solved] Simple sum is wrong

Last post by Hagar Delest « Wed Dec 04, 2024 11:02 am
Replies: 6
by linz » Tue Dec 03, 2024 4:48 pm

6 Replies

1967 Views

Last post by Hagar Delest
Wed Dec 04, 2024 11:02 am
[Solved] Help with a percentage and a visible data issue

Last post by Hagar Delest « Tue Dec 03, 2024 9:15 am
Replies: 7
by Barry G » Tue Nov 26, 2024 11:46 pm

7 Replies

2909 Views

Last post by Hagar Delest
Tue Dec 03, 2024 9:15 am
[Solved] How can I add up 1+1?

Last post by robleyd « Fri Nov 29, 2024 2:50 am
Replies: 1
by lhkv.utkgjtkftkuutf » Fri Nov 29, 2024 2:28 am

1 Replies

1262 Views

Last post by robleyd
Fri Nov 29, 2024 2:50 am
[Dropped] Convert PDF to ODS

Last post by RoryOF « Mon Nov 25, 2024 10:59 pm
Replies: 3
by dbuster » Fri Nov 22, 2024 7:37 pm

3 Replies

1924 Views

Last post by RoryOF
Mon Nov 25, 2024 10:59 pm
[Solved] Total amount for each category

Last post by RMRavik « Mon Nov 25, 2024 5:09 pm
Replies: 7
by Mark Bulgaria » Thu Dec 05, 2019 3:14 pm

7 Replies

3359 Views

Last post by RMRavik
Mon Nov 25, 2024 5:09 pm
[Solved] Get max and min of filtered cells

Last post by Hagar Delest « Fri Nov 22, 2024 10:30 pm
Replies: 20
by forgottenBlock » Sun Nov 17, 2024 4:31 pm

20 Replies

5691 Views

Last post by Hagar Delest
Fri Nov 22, 2024 10:30 pm
[Dropped] Don't label each point in a chart

Last post by Lupp « Fri Nov 22, 2024 4:39 pm
Replies: 4
by blakemulder » Fri Nov 22, 2024 1:58 pm

4 Replies

1448 Views

Last post by Lupp
Fri Nov 22, 2024 4:39 pm
[Solved] Lock and grey out cells based on another cell

Last post by Wonderswan « Fri Nov 22, 2024 12:12 pm
Replies: 2
by Wonderswan » Wed Nov 20, 2024 1:59 pm

2 Replies

1421 Views

Last post by Wonderswan
Fri Nov 22, 2024 12:12 pm
[Solved] Store formula result in different cell

Last post by RoryOF « Thu Nov 21, 2024 6:17 pm
Replies: 3
by DWDun » Wed Nov 20, 2024 8:01 pm

3 Replies

1459 Views

Last post by RoryOF
Thu Nov 21, 2024 6:17 pm
[Solved] Show formula result temporarily

Last post by DWDun « Thu Nov 21, 2024 6:02 pm
Replies: 2
by DWDun » Wed Nov 20, 2024 8:22 pm

2 Replies

1266 Views

Last post by DWDun
Thu Nov 21, 2024 6:02 pm
[Solved] Create toolbar buttons for recorded macros

Last post by robleyd « Thu Nov 21, 2024 4:46 pm
Replies: 1
by BillTracey » Thu Nov 21, 2024 4:22 pm

1 Replies

1010 Views

Last post by robleyd
Thu Nov 21, 2024 4:46 pm
[Dropped] Alternate colors on spreadsheet rows

Last post by robleyd « Thu Nov 21, 2024 2:18 am
Replies: 5
by namely » Thu Nov 21, 2024 12:17 am

5 Replies

1564 Views

Last post by robleyd
Thu Nov 21, 2024 2:18 am
[Solved] Sort by date within a period

Last post by cephas « Thu Nov 21, 2024 12:31 am
Replies: 19
by cephas » Tue Nov 19, 2024 6:14 am

19 Replies

3602 Views

Last post by cephas
Thu Nov 21, 2024 12:31 am
[Dropped] Assign value to cell from another cell

Last post by FJCC « Wed Nov 20, 2024 5:03 am
Replies: 1
by rickbking » Wed Nov 20, 2024 4:18 am

1 Replies

872 Views

Last post by FJCC
Wed Nov 20, 2024 5:03 am
[Solved] Calc won't honor any formulae

Last post by kurttappe « Tue Nov 19, 2024 9:08 pm
Replies: 2
by kurttappe » Tue Nov 19, 2024 7:24 pm

2 Replies

1086 Views

Last post by kurttappe
Tue Nov 19, 2024 9:08 pm
[Solved] Generating a name list based on a criterion

Last post by patweb « Tue Nov 19, 2024 7:18 pm
Replies: 2
by patweb » Tue Nov 19, 2024 4:24 pm

2 Replies

1056 Views

Last post by patweb
Tue Nov 19, 2024 7:18 pm
[Solved] Recalculation

Last post by m13m13 « Sat Nov 16, 2024 4:13 am
Replies: 4
by RusselB » Fri Jan 03, 2014 7:57 am

4 Replies

2642 Views

Last post by m13m13
Sat Nov 16, 2024 4:13 am
[Solved] Lost password to disable change recording

Last post by RoryOF « Fri Nov 15, 2024 10:59 pm
Replies: 2
by bamsa » Fri Nov 15, 2024 7:16 pm

2 Replies

1277 Views

Last post by RoryOF
Fri Nov 15, 2024 10:59 pm
[Solved] Big numbers in my date column

Last post by MrProgrammer « Wed Nov 13, 2024 7:14 pm
Replies: 2
by Oohappyuser » Wed Nov 13, 2024 6:57 am

2 Replies

1222 Views

Last post by MrProgrammer
Wed Nov 13, 2024 7:14 pm
[Solved] Determine which group has the specified number

Last post by Lupp « Mon Nov 11, 2024 11:19 pm
Replies: 11
by phofrock » Sun Nov 10, 2024 12:11 am

11 Replies

2784 Views

Last post by Lupp
Mon Nov 11, 2024 11:19 pm
[Solved] Text Centered across multiple cells

Last post by FJCC « Sun Nov 10, 2024 7:35 pm
Replies: 1
by Bookbrowser » Sun Nov 10, 2024 7:10 pm

1 Replies

1015 Views

Last post by FJCC
Sun Nov 10, 2024 7:35 pm
Duplicate sheet formulae in new sheet

Last post by Hagar Delest « Sun Nov 10, 2024 4:35 pm
Replies: 10
by peanutaxis » Sat Nov 09, 2024 9:41 am

10 Replies

2439 Views

Last post by Hagar Delest
Sun Nov 10, 2024 4:35 pm
[Solved] Export cell range to an email

Last post by MrProgrammer « Fri Nov 08, 2024 5:16 pm
Replies: 2
by DavidBoudz » Fri Nov 08, 2024 10:50 am

2 Replies

1466 Views

Last post by MrProgrammer
Fri Nov 08, 2024 5:16 pm
[Solved] Match data and fetch common in third cell

Last post by Lupp « Fri Nov 08, 2024 1:45 pm
Replies: 10
by yuv.370 » Wed Nov 06, 2024 8:31 am

10 Replies

2094 Views

Last post by Lupp
Fri Nov 08, 2024 1:45 pm
[Solved] Add new data to chart

Last post by Meadowlark « Fri Nov 08, 2024 11:27 am
Replies: 7
by Meadowlark » Thu Nov 07, 2024 10:10 am

7 Replies

2062 Views

Last post by Meadowlark
Fri Nov 08, 2024 11:27 am
[Solved] Subtract, but prevent negative result

Last post by robleyd « Fri Nov 08, 2024 1:15 am
Replies: 3
by manicmailman » Fri Nov 08, 2024 12:58 am

3 Replies

1101 Views

Last post by robleyd
Fri Nov 08, 2024 1:15 am
[Dropped] Automatic cash banking formula

Last post by Zizi64 « Wed Nov 06, 2024 6:46 am
Replies: 1
by Absurdius » Tue Nov 05, 2024 3:41 am

1 Replies

849 Views

Last post by Zizi64
Wed Nov 06, 2024 6:46 am
[Solved] Help needed with corrupt CSV file

Last post by MrProgrammer « Mon Nov 04, 2024 8:34 pm
Replies: 6
by Blaz Gindiciosi » Mon Nov 04, 2024 5:52 pm

6 Replies

2284 Views

Last post by MrProgrammer
Mon Nov 04, 2024 8:34 pm
[Solved] Cell displays its formula, not its value

Last post by DWDun « Mon Nov 04, 2024 6:11 pm
Replies: 21
by DWDun » Thu Oct 31, 2024 6:40 pm

21 Replies

2979 Views

Last post by DWDun
Mon Nov 04, 2024 6:11 pm
[Dropped] Keep getting a VALUE message

Last post by floris v « Mon Nov 04, 2024 2:03 pm
Replies: 3
by JSJOBE24 » Fri Nov 01, 2024 11:17 pm

3 Replies

1015 Views

Last post by floris v
Mon Nov 04, 2024 2:03 pm
[Dropped] Err:509 in spreadsheet

Last post by floris v « Mon Nov 04, 2024 1:46 pm
Replies: 1
by avaokernow » Mon Nov 04, 2024 1:02 pm

1 Replies

717 Views

Last post by floris v
Mon Nov 04, 2024 1:46 pm
[Dropped] IFERROR formula from Excel

Last post by karolus « Sun Nov 03, 2024 6:15 pm
Replies: 14
by Mardana » Tue Oct 29, 2024 2:57 am

14 Replies

3592 Views

Last post by karolus
Sun Nov 03, 2024 6:15 pm
[Issue] Accounting format for numbers

Last post by MrProgrammer « Sat Nov 02, 2024 6:45 pm
Replies: 9
by mtntime » Mon Oct 28, 2024 1:05 am

9 Replies

2576 Views

Last post by MrProgrammer
Sat Nov 02, 2024 6:45 pm
Unexpected font size in text copied from Writer

Last post by White Phoenix « Sat Nov 02, 2024 9:08 am
Replies: 16
by White Phoenix » Wed Oct 30, 2024 9:30 am

16 Replies

2639 Views

Last post by White Phoenix
Sat Nov 02, 2024 9:08 am
[Solved] Convert range of zeros and ones to hexadecimal

Last post by cwolan « Sat Nov 02, 2024 8:24 am
Replies: 10
by SteveRob408 » Sun Oct 27, 2024 3:32 am

10 Replies

1930 Views

Last post by cwolan
Sat Nov 02, 2024 8:24 am
[Solved] Copy & paste BIN2HEX result, NOT the equation

Last post by MrProgrammer « Fri Nov 01, 2024 5:34 pm
Replies: 1
by matchbox_man » Fri Nov 01, 2024 4:45 pm

1 Replies

565 Views

Last post by MrProgrammer
Fri Nov 01, 2024 5:34 pm
[Solved] Using multiple IF/AND formulas

Last post by Cub « Fri Nov 01, 2024 5:42 am
Replies: 2
by Cub » Thu Oct 31, 2024 8:07 pm

2 Replies

633 Views

Last post by Cub
Fri Nov 01, 2024 5:42 am
[Solved] Combine text and date in a cell

Last post by Griff1982 « Thu Oct 31, 2024 10:15 pm
Replies: 2
by Griff1982 » Thu Oct 31, 2024 8:24 pm

2 Replies

763 Views

Last post by Griff1982
Thu Oct 31, 2024 10:15 pm
[Solved] Cell display control

Last post by DWDun « Thu Oct 31, 2024 5:13 pm
Replies: 9
by DWDun » Wed Oct 30, 2024 5:16 pm

9 Replies

1749 Views

Last post by DWDun
Thu Oct 31, 2024 5:13 pm
[Solved] Sorted list using MATCH skips duplicates

Last post by Fitch « Wed Oct 30, 2024 11:17 pm
Replies: 5
by Fitch » Mon Oct 28, 2024 8:37 pm

5 Replies

1263 Views

Last post by Fitch
Wed Oct 30, 2024 11:17 pm
[Dropped] How to total multiple time in Calc

Last post by Alex1 « Wed Oct 30, 2024 7:57 pm
Replies: 2
by lavarne04 » Wed Oct 30, 2024 8:27 am

2 Replies

613 Views

Last post by Alex1
Wed Oct 30, 2024 7:57 pm
[Solved] Batch edit of formulas in a column

Last post by jpm2 « Tue Oct 29, 2024 1:12 am
Replies: 4
by jpm2 » Sat Oct 26, 2024 3:34 am

4 Replies

952 Views

Last post by jpm2
Tue Oct 29, 2024 1:12 am
[Solved] String manipulation trial using functions

Last post by Nicholas59 « Sun Oct 27, 2024 4:19 pm
Replies: 7
by Nicholas59 » Sun Oct 27, 2024 9:42 am

7 Replies

1417 Views

Last post by Nicholas59
Sun Oct 27, 2024 4:19 pm
[Solved] Extraneous characters in formulas

Last post by Zizi64 « Sun Oct 27, 2024 7:54 am
Replies: 17
by DWDun » Thu Oct 24, 2024 1:07 am

17 Replies

3212 Views

Last post by Zizi64
Sun Oct 27, 2024 7:54 am
[Solved] Err510

Last post by Alex1 « Fri Oct 25, 2024 10:10 pm
Replies: 2
by DWDun » Fri Oct 25, 2024 7:59 pm

2 Replies

980 Views

Last post by Alex1
Fri Oct 25, 2024 10:10 pm
[Solved] Keyboard shortcut to edit in formula bar

Last post by LastUnicorn « Mon Oct 21, 2024 11:10 am
Replies: 2
by PTALL » Sun Oct 20, 2024 9:14 pm

2 Replies

999 Views

Last post by LastUnicorn
Mon Oct 21, 2024 11:10 am
[Solved] Count visible rows with criteria

Last post by toshie « Fri Oct 18, 2024 6:26 pm
Replies: 4
by toshie » Thu Oct 17, 2024 5:16 pm

4 Replies

1390 Views

Last post by toshie
Fri Oct 18, 2024 6:26 pm
[Solved] Page numbers for Portrait and Landscape

Last post by RoryOF « Thu Oct 17, 2024 10:25 am
Replies: 12
by Richard1001 » Wed Oct 09, 2024 2:46 am

12 Replies

2247 Views

Last post by RoryOF
Thu Oct 17, 2024 10:25 am
[Solved] Cells are empty after Paste Special Transpose

Last post by Alex1 « Thu Oct 17, 2024 1:57 am
Replies: 5
by CrankyEngineer » Mon Oct 14, 2024 11:22 pm

5 Replies

1196 Views

Last post by Alex1
Thu Oct 17, 2024 1:57 am
[Solved] Sort not available in Data menu

Last post by MrProgrammer « Sat Oct 12, 2024 6:29 pm
Replies: 5
by frankkl » Thu Oct 10, 2024 7:12 pm

5 Replies

1487 Views

Last post by MrProgrammer
Sat Oct 12, 2024 6:29 pm

New Topic

23347 topics

Page 6 of 467
- Jump to page:
Previous
1
…
4
5
6
7
8
…
467
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