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

Total redirects: 378680
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 284342

Total redirects: 284342
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 292442

Total redirects: 292442
Calc Tutorials
Tutorials from this forum
Total redirects: 285219

Total redirects: 285219

New Topic

23115 topics

Page 1 of 463
- Jump to page:
1
2
3
4
5
…
463
Next

Announcements

Replies

Views

Last post

Using a Gmail address for the forum account: workaround

Last post by floris v « Sun Apr 28, 2024 11:55 pm
Posted in Site Feedback
Replies: 1
by Hagar Delest » Tue Apr 23, 2024 11:13 am » in Site Feedback

1 Replies

109598 Views

Last post by floris v
Sun Apr 28, 2024 11:55 pm
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

144652 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

98794 Views

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

332 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

1352 Views

Last post by cephas
Thu Nov 21, 2024 12:31 am
Get max and min of filtered cells

Last post by Hagar Delest « Wed Nov 20, 2024 10:21 pm
Replies: 13
by forgottenBlock » Sun Nov 17, 2024 4:31 pm

13 Replies

846 Views

Last post by Hagar Delest
Wed Nov 20, 2024 10:21 pm
Show formula result temporarily

Last post by FJCC « Wed Nov 20, 2024 8:55 pm
Replies: 1
by DWDun » Wed Nov 20, 2024 8:22 pm

1 Replies

96 Views

Last post by FJCC
Wed Nov 20, 2024 8:55 pm
Store formula result in different cell

Last post by FJCC « Wed Nov 20, 2024 8:45 pm
Replies: 1
by DWDun » Wed Nov 20, 2024 8:01 pm

1 Replies

92 Views

Last post by FJCC
Wed Nov 20, 2024 8:45 pm
Lock and grey out cells based on another cell

Last post by FJCC « Wed Nov 20, 2024 4:55 pm
Replies: 1
by Wonderswan » Wed Nov 20, 2024 1:59 pm

1 Replies

94 Views

Last post by FJCC
Wed Nov 20, 2024 4:55 pm
How do I assign a value to a 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

140 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

184 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

188 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

1453 Views

Last post by m13m13
Sat Nov 16, 2024 4:13 am
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

410 Views

Last post by RoryOF
Fri Nov 15, 2024 10:59 pm
[Dropped] 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

372 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

1362 Views

Last post by Lupp
Mon Nov 11, 2024 11:19 pm
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

406 Views

Last post by FJCC
Sun Nov 10, 2024 7:35 pm
No way to copy sheet formulae - absolutely ridiculous.

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

1360 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

524 Views

Last post by MrProgrammer
Fri Nov 08, 2024 5:16 pm
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

1040 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

598 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

482 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

269 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

663 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

1320 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

389 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

172 Views

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

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

15 Replies

1463 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

1002 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

889 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

957 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

206 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

325 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

357 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

1109 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

646 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

293 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

543 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

707 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

1467 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

341 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

533 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

626 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

1310 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

774 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

916 Views

Last post by MrProgrammer
Sat Oct 12, 2024 6:29 pm
[Solved] Counting column with "NO$"

Last post by Cat101 « Wed Oct 09, 2024 8:42 pm
Replies: 3
by Cat101 » Wed Oct 09, 2024 4:15 am

3 Replies

526 Views

Last post by Cat101
Wed Oct 09, 2024 8:42 pm
[Solved] New, Modify or Delete not working for Styles

Last post by Bal « Mon Oct 07, 2024 10:27 pm
Replies: 3
by Bal » Mon Oct 07, 2024 5:25 pm

3 Replies

521 Views

Last post by Bal
Mon Oct 07, 2024 10:27 pm
[Solved] Format reports from Calc

Last post by bigMama « Fri Oct 04, 2024 9:40 pm
Replies: 2
by bigMama » Thu Oct 03, 2024 10:56 pm

2 Replies

650 Views

Last post by bigMama
Fri Oct 04, 2024 9:40 pm
[Solved] Convert text string from CSV to date

Last post by MrProgrammer « Thu Oct 03, 2024 1:02 am
Replies: 1
by S.Franklin » Wed Oct 02, 2024 11:50 pm

1 Replies

628 Views

Last post by MrProgrammer
Thu Oct 03, 2024 1:02 am
[Solved] Automatically sort data

Last post by MrProgrammer « Mon Sep 30, 2024 8:32 pm
Replies: 1
by Pinkmen » Mon Sep 30, 2024 8:08 pm

1 Replies

774 Views

Last post by MrProgrammer
Mon Sep 30, 2024 8:32 pm
[Solved] Use two formulas in one cell

Last post by Pinkmen « Mon Sep 30, 2024 8:05 pm
Replies: 5
by Pinkmen » Fri Sep 20, 2024 9:56 pm

5 Replies

1079 Views

Last post by Pinkmen
Mon Sep 30, 2024 8:05 pm

New Topic

23115 topics

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