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

Total redirects: 1097943
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 929722

Total redirects: 929722
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 937611

Total redirects: 937611
Calc Tutorials
Tutorials from this forum
Total redirects: 922253

Total redirects: 922253

New Topic

23360 topics

Page 24 of 468
- Jump to page:
Previous
1
…
22
23
24
25
26
…
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

227712 Views

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

Topics

Replies

Views

Last post

[Dropped] Formula IF(C1=9;1;C1+1) gives unexpected result

Last post by Hagar Delest « Mon Oct 31, 2022 7:16 pm
Replies: 1
by BrianH » Mon Oct 31, 2022 7:06 pm

1 Replies

450 Views

Last post by Hagar Delest
Mon Oct 31, 2022 7:16 pm
[Solved] Change Background Colour In Certain Cells Only

Last post by MrProgrammer « Sun Oct 30, 2022 5:50 pm
Replies: 1
by Philfy » Sat Oct 29, 2022 9:03 pm

1 Replies

937 Views

Last post by MrProgrammer
Sun Oct 30, 2022 5:50 pm
[Solved] Can't refer the A column with A:A

Last post by MrProgrammer « Sat Oct 29, 2022 9:58 pm
Replies: 3
by luofeiyu » Fri Oct 28, 2022 1:39 pm

3 Replies

819 Views

Last post by MrProgrammer
Sat Oct 29, 2022 9:58 pm
[Solved] Apostrophe before figures

Last post by John_Ha « Sat Oct 29, 2022 7:03 pm
Replies: 8
by Bluecat34 » Sat Oct 29, 2022 4:29 pm

8 Replies

1508 Views

Last post by John_Ha
Sat Oct 29, 2022 7:03 pm
[Solved] Creating graphs with both axes scaled to reflect values

Last post by migimohidarimo « Sat Oct 29, 2022 12:38 am
Replies: 3
by migimohidarimo » Fri Oct 28, 2022 2:52 pm

3 Replies

1358 Views

Last post by migimohidarimo
Sat Oct 29, 2022 12:38 am
[Dropped] Cells that don't save as required

Last post by John_Ha « Fri Oct 28, 2022 3:27 pm
Replies: 4
by Flashvac » Thu Oct 27, 2022 11:38 am

4 Replies

687 Views

Last post by John_Ha
Fri Oct 28, 2022 3:27 pm
[Solved] Naming cells

Last post by Zizi64 « Fri Oct 28, 2022 7:12 am
Replies: 2
by delta5 » Thu Oct 27, 2022 11:32 pm

2 Replies

626 Views

Last post by Zizi64
Fri Oct 28, 2022 7:12 am
[Solved] Loading a spreadsheet is very slow

Last post by MrProgrammer « Thu Oct 27, 2022 8:40 pm
Replies: 12
by KenH1 » Thu Oct 27, 2022 7:06 pm

12 Replies

2933 Views

Last post by MrProgrammer
Thu Oct 27, 2022 8:40 pm
[Dropped] How to mark numbers in cell with BOLD

Last post by koden « Tue Oct 25, 2022 9:07 am
Replies: 6
by koden » Mon Oct 24, 2022 10:06 am

6 Replies

941 Views

Last post by koden
Tue Oct 25, 2022 9:07 am
Date & Times Chart

Last post by JoePoult « Sun Oct 23, 2022 9:31 pm
Replies: 2
by JoePoult » Sun Oct 23, 2022 6:23 pm

2 Replies

558 Views

Last post by JoePoult
Sun Oct 23, 2022 9:31 pm
[Solved] Grey border with buttons to left of spreadsheet columns

Last post by lonepilot « Sun Oct 23, 2022 5:51 am
Replies: 2
by lonepilot » Sun Oct 23, 2022 5:31 am

2 Replies

761 Views

Last post by lonepilot
Sun Oct 23, 2022 5:51 am
[Solved] Centering text in cells not working

Last post by joe.dokes « Sat Oct 22, 2022 3:49 am
Replies: 7
by joe.dokes » Sat Oct 22, 2022 1:02 am

7 Replies

1432 Views

Last post by joe.dokes
Sat Oct 22, 2022 3:49 am
[Solved] Cell formula changed by Paste Special → Comments

Last post by Villeroy « Thu Oct 20, 2022 9:32 pm
Replies: 8
by Alan1951 » Tue Oct 18, 2022 11:03 pm

8 Replies

1166 Views

Last post by Villeroy
Thu Oct 20, 2022 9:32 pm
[Solved] Calc file LOCKED by UNKNOWN USER

Last post by RoryOF « Thu Oct 20, 2022 1:33 pm
Replies: 6
by ralphhosmer » Sat Dec 03, 2016 11:02 pm

6 Replies

2547 Views

Last post by RoryOF
Thu Oct 20, 2022 1:33 pm
Repairing recovered ODS

Last post by Jan_J « Wed Oct 19, 2022 9:26 pm
Replies: 2
by samueltakacs » Wed Oct 19, 2022 11:48 am

2 Replies

841 Views

Last post by Jan_J
Wed Oct 19, 2022 9:26 pm
[Solved] Prevent selection of protected cells [Issue]

Last post by robasp57 « Tue Oct 18, 2022 7:29 pm
Replies: 8
by robasp57 » Tue Oct 18, 2022 3:38 pm

8 Replies

1641 Views

Last post by robasp57
Tue Oct 18, 2022 7:29 pm
[Solved] Export "CSV" in ACH-compliant format

Last post by John_Ha « Mon Oct 17, 2022 11:43 pm
Replies: 5
by Cat101 » Mon Oct 17, 2022 7:29 pm

5 Replies

2350 Views

Last post by John_Ha
Mon Oct 17, 2022 11:43 pm
[Solved] Hide decimal for Whole numbers

Last post by Penny666 « Mon Oct 17, 2022 3:41 pm
Replies: 10
by Penny666 » Fri Oct 14, 2022 11:04 pm

10 Replies

3709 Views

Last post by Penny666
Mon Oct 17, 2022 3:41 pm
[Solved] Calculating probabilities seems to be off in just one copy...

Last post by VictorB « Fri Oct 14, 2022 2:38 pm
Replies: 5
by VictorB » Fri Oct 07, 2022 2:00 pm

5 Replies

1451 Views

Last post by VictorB
Fri Oct 14, 2022 2:38 pm
[Solved] Random integer partition into four cells

Last post by Lupp « Fri Oct 14, 2022 12:37 pm
Replies: 6
by Cruise105 » Wed Oct 12, 2022 4:36 am

6 Replies

1237 Views

Last post by Lupp
Fri Oct 14, 2022 12:37 pm
[Solved] Set cell background colour via toolbar

Last post by cwolan « Fri Oct 14, 2022 12:01 am
Replies: 7
by pmanthony » Thu Oct 13, 2022 7:41 pm

7 Replies

2001 Views

Last post by cwolan
Fri Oct 14, 2022 12:01 am
[Solved] Combine multiple Excel files into one

Last post by iddqd « Thu Oct 13, 2022 10:24 pm
Replies: 12
by iddqd » Sat Oct 08, 2022 9:56 am

12 Replies

6311 Views

Last post by iddqd
Thu Oct 13, 2022 10:24 pm
[Solved] Permanently deactivate AutoCalculate

Last post by Zizi64 « Wed Oct 12, 2022 5:06 pm
Replies: 3
by pepisoyu » Wed Oct 12, 2022 12:48 pm

3 Replies

696 Views

Last post by Zizi64
Wed Oct 12, 2022 5:06 pm
[Solved] Check 2 cells in a row, adding 1 to a total in a new cell

Last post by RGreen19 « Wed Oct 12, 2022 2:27 am
Replies: 2
by RGreen19 » Wed Oct 12, 2022 1:43 am

2 Replies

661 Views

Last post by RGreen19
Wed Oct 12, 2022 2:27 am
[Solved] Deleting columns not working as expected

Last post by Hagar Delest « Tue Oct 11, 2022 9:55 pm
Replies: 11
by toubabdoc » Mon Oct 10, 2022 10:59 pm

11 Replies

2570 Views

Last post by Hagar Delest
Tue Oct 11, 2022 9:55 pm
[Solved] Extension Manager?

Last post by h2vh « Tue Oct 11, 2022 8:43 pm
Replies: 14
by h2vh » Thu Aug 18, 2022 5:34 pm

14 Replies

3078 Views

Last post by h2vh
Tue Oct 11, 2022 8:43 pm
[Solved] How do I assign a value to a cell from another cell?

Last post by F3K Total « Tue Oct 11, 2022 4:39 pm
Replies: 5
by sunora4 » Tue Oct 11, 2022 3:55 am

5 Replies

2170 Views

Last post by F3K Total
Tue Oct 11, 2022 4:39 pm
[Issue] SUMIF with multiple conditions

Last post by robleyd « Tue Oct 11, 2022 4:00 am
Replies: 6
by wojmo » Fri Oct 07, 2022 1:50 pm

6 Replies

2496 Views

Last post by robleyd
Tue Oct 11, 2022 4:00 am
[Solved] Rotate data for a chart

Last post by Laurie G « Sun Oct 09, 2022 5:00 pm
Replies: 17
by Laurie G » Sun Oct 02, 2022 5:12 am

17 Replies

2493 Views

Last post by Laurie G
Sun Oct 09, 2022 5:00 pm
[Solved] Can't label X-Y scatter chart X-axis correctly

Last post by alanack « Sun Oct 09, 2022 2:49 pm
Replies: 10
by alanack » Sat Oct 08, 2022 1:15 pm

10 Replies

1749 Views

Last post by alanack
Sun Oct 09, 2022 2:49 pm
Show cells with misspelled words

Last post by Zizi64 « Fri Oct 07, 2022 11:53 am
Replies: 3
by rgurganus » Mon Oct 03, 2022 7:56 pm

3 Replies

781 Views

Last post by Zizi64
Fri Oct 07, 2022 11:53 am
[Dropped] Automatic line break

Last post by Zizi64 « Fri Oct 07, 2022 10:15 am
Replies: 1
by nisuditi » Thu Oct 06, 2022 1:38 pm

1 Replies

675 Views

Last post by Zizi64
Fri Oct 07, 2022 10:15 am
[Solved] Always show first row when scrolling

Last post by Lupp « Thu Oct 06, 2022 2:40 pm
Replies: 2
by brannsiu » Thu Oct 06, 2022 8:35 am

2 Replies

2523 Views

Last post by Lupp
Thu Oct 06, 2022 2:40 pm
[Solved] Text color conditional format or STYLE()

Last post by FJCC « Wed Oct 05, 2022 9:31 pm
Replies: 1
by wojmo » Wed Oct 05, 2022 9:19 pm

1 Replies

499 Views

Last post by FJCC
Wed Oct 05, 2022 9:31 pm
[Solved] Count of times the email appears

Last post by karolus « Wed Oct 05, 2022 6:49 pm
Replies: 1
by krotkolapka » Wed Oct 05, 2022 5:09 pm

1 Replies

570 Views

Last post by karolus
Wed Oct 05, 2022 6:49 pm
[Solved] Keyboard shortcut to insert rows

Last post by robleyd « Wed Oct 05, 2022 9:10 am
Replies: 4
by brannsiu » Wed Oct 05, 2022 7:10 am

4 Replies

3777 Views

Last post by robleyd
Wed Oct 05, 2022 9:10 am
Skipping empty cells when pasting a row of data

Last post by Lupp « Tue Oct 04, 2022 12:55 am
Replies: 5
by htcmsg » Sat Oct 01, 2022 7:49 pm

5 Replies

906 Views

Last post by Lupp
Tue Oct 04, 2022 12:55 am
[Solved] Cell displays ### instead of number

Last post by RoryOF « Sun Oct 02, 2022 7:44 pm
Replies: 1
by nikolaosaek » Sun Oct 02, 2022 7:08 pm

1 Replies

462 Views

Last post by RoryOF
Sun Oct 02, 2022 7:44 pm
[Solved] Quickly test if there is any data entry in a spreadsheet

Last post by MrProgrammer « Fri Sep 30, 2022 5:13 pm
Replies: 9
by brannsiu » Mon Sep 05, 2022 11:13 am

9 Replies

2435 Views

Last post by MrProgrammer
Fri Sep 30, 2022 5:13 pm
[Dropped] Disable the prompt to update external links

Last post by Lupp « Thu Sep 29, 2022 6:42 pm
Replies: 1
by ascrw2003 » Wed Sep 28, 2022 6:40 pm

1 Replies

965 Views

Last post by Lupp
Thu Sep 29, 2022 6:42 pm
Using 'find' crashes Calc

Last post by Hagar Delest « Thu Sep 29, 2022 1:26 pm
Replies: 10
by Rhyssa6 » Sat Sep 24, 2022 2:28 pm

10 Replies

2526 Views

Last post by Hagar Delest
Thu Sep 29, 2022 1:26 pm
[Solved] Can't terminate compare feature

Last post by Joakim1970 « Wed Sep 28, 2022 6:06 pm
Replies: 3
by Joakim1970 » Sun Sep 25, 2022 6:07 pm

3 Replies

779 Views

Last post by Joakim1970
Wed Sep 28, 2022 6:06 pm
[Dropped] How to hide particular rows?

Last post by Mountaineer « Wed Sep 28, 2022 10:34 am
Replies: 12
by brannsiu » Sat Sep 24, 2022 6:14 pm

12 Replies

2359 Views

Last post by Mountaineer
Wed Sep 28, 2022 10:34 am
[Solved] Phone number formatting

Last post by MrProgrammer « Mon Sep 26, 2022 9:52 pm
Replies: 1
by Jokersloose » Mon Sep 26, 2022 6:35 pm

1 Replies

2248 Views

Last post by MrProgrammer
Mon Sep 26, 2022 9:52 pm
Slow response time when entering values into cells

Last post by basade42 « Mon Sep 26, 2022 8:57 pm

by basade42 » Mon Sep 26, 2022 8:57 pm

0 Replies

1328 Views

Last post by basade42
Mon Sep 26, 2022 8:57 pm
[Solved] How to populate a cell with text dependant on contents of another cell?

Last post by Bones541 « Mon Sep 26, 2022 8:44 am
Replies: 4
by Bones541 » Sun Sep 25, 2022 12:27 pm

4 Replies

816 Views

Last post by Bones541
Mon Sep 26, 2022 8:44 am
[Solved] What is the syntax for the "User Defined" number format

Last post by Villeroy « Sun Sep 25, 2022 8:35 pm
Replies: 8
by CrimsonShroud » Sat Sep 24, 2022 2:35 pm

8 Replies

2088 Views

Last post by Villeroy
Sun Sep 25, 2022 8:35 pm
[Solved] MM/DD/YYYY to YYYY-MM-DD format not working.

Last post by Bones541 « Sun Sep 25, 2022 9:48 am
Replies: 3
by Bones541 » Sun Sep 25, 2022 6:53 am

3 Replies

1692 Views

Last post by Bones541
Sun Sep 25, 2022 9:48 am
[Solved] Change image based on a cell value

Last post by agi « Sat Sep 24, 2022 6:33 pm
Replies: 2
by agi » Fri Sep 23, 2022 7:09 pm

2 Replies

949 Views

Last post by agi
Sat Sep 24, 2022 6:33 pm
[Solved] Remove panel with +Bibliography on left

Last post by L_Ellis « Sat Sep 24, 2022 2:00 pm
Replies: 2
by L_Ellis » Sat Sep 24, 2022 1:22 pm

2 Replies

976 Views

Last post by L_Ellis
Sat Sep 24, 2022 2:00 pm

New Topic

23360 topics

Page 24 of 468
- Jump to page:
Previous
1
…
22
23
24
25
26
…
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