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

Total redirects: 381249
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 284594

Total redirects: 284594
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 292679

Total redirects: 292679
Calc Tutorials
Tutorials from this forum
Total redirects: 285467

Total redirects: 285467

New Topic

23119 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

110689 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

145279 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

98867 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
[Solved] Total expenditure (Amount) for each of the category

Last post by Zizi64 « Sun Nov 24, 2024 9:32 pm
Replies: 6
by Mark Bulgaria » Thu Dec 05, 2019 3:14 pm

6 Replies

1663 Views

Last post by Zizi64
Sun Nov 24, 2024 9:32 pm
[Solved] Autoinput Suggestion 'Masked'

Last post by LastUnicorn « Sat Nov 23, 2024 9:05 pm
Replies: 7
by LastUnicorn » Fri Nov 22, 2024 5:44 pm

7 Replies

706 Views

Last post by LastUnicorn
Sat Nov 23, 2024 9:05 pm
Convert PDF to ODS

Last post by Hagar Delest « Fri Nov 22, 2024 10:37 pm
Replies: 1
by dbuster » Fri Nov 22, 2024 7:37 pm

1 Replies

284 Views

Last post by Hagar Delest
Fri Nov 22, 2024 10:37 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

1648 Views

Last post by Hagar Delest
Fri Nov 22, 2024 10:30 pm
I need a simple chart but.....

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

4 Replies

262 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

195 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

354 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

250 Views

Last post by DWDun
Thu Nov 21, 2024 6:02 pm
Adding buttons and macros to Calc

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

1 Replies

136 Views

Last post by robleyd
Thu Nov 21, 2024 4:46 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

463 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

1482 Views

Last post by cephas
Thu Nov 21, 2024 12:31 am
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

185 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

232 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

236 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

1508 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

448 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

404 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

1417 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

438 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

1420 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

555 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

1106 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

636 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

512 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

304 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

695 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

1361 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

412 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

200 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

1516 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

1039 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

923 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

983 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

230 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

349 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

380 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

1128 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

683 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

318 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

568 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

732 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

1508 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

362 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

557 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

664 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

1352 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

793 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

949 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

540 Views

Last post by Cat101
Wed Oct 09, 2024 8:42 pm

New Topic

23119 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