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

Total redirects: 710445
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 555886

Total redirects: 555886
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 564342

Total redirects: 564342
Calc Tutorials
Tutorials from this forum
Total redirects: 553638

Total redirects: 553638

New Topic

23275 topics

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

317610 Views

Last post by robleyd
Sat Dec 23, 2023 3:55 am

Topics

Replies

Views

Last post

[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

637 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

2520 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

2262 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

2122 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

1684 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

466 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

525 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

650 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

1509 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

1038 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

553 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

840 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

1040 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

2509 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

608 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

861 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

1011 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

1818 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

1044 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

1335 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

687 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

738 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

889 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

888 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

992 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

1617 Views

Last post by Pinkmen
Mon Sep 30, 2024 8:05 pm
[Solved] Stop the data scrolling past frozen heading

Last post by Nellap « Sun Sep 29, 2024 3:25 am
Replies: 6
by Nellap » Sat Sep 28, 2024 8:06 am

6 Replies

1374 Views

Last post by Nellap
Sun Sep 29, 2024 3:25 am
[Solved] Forced recalculation

Last post by DWDun « Sat Sep 28, 2024 8:15 pm
Replies: 4
by DWDun » Fri Sep 27, 2024 6:40 pm

4 Replies

1286 Views

Last post by DWDun
Sat Sep 28, 2024 8:15 pm
[Dropped] Check separate columns for values

Last post by Lupp « Fri Sep 27, 2024 5:13 pm
Replies: 1
by Lt2210 » Fri Sep 27, 2024 4:10 pm

1 Replies

694 Views

Last post by Lupp
Fri Sep 27, 2024 5:13 pm
[Solved] Adding data from 2 months

Last post by Villeroy « Thu Sep 26, 2024 7:51 pm
Replies: 7
by Pinkmen » Tue Sep 24, 2024 7:17 am

7 Replies

2183 Views

Last post by Villeroy
Thu Sep 26, 2024 7:51 pm
[Solved] Autofilter headers disappear

Last post by Pinkmen « Thu Sep 26, 2024 5:44 pm
Replies: 3
by Pinkmen » Wed Sep 25, 2024 10:03 pm

3 Replies

855 Views

Last post by Pinkmen
Thu Sep 26, 2024 5:44 pm
[Solved] Add or subtract values in additional column

Last post by hbombgolf « Thu Sep 26, 2024 12:42 pm
Replies: 17
by hbombgolf » Tue Sep 24, 2024 3:48 pm

17 Replies

2065 Views

Last post by hbombgolf
Thu Sep 26, 2024 12:42 pm
[Solved] Negate column of numbers (positive to negative)

Last post by Pinkmen « Wed Sep 25, 2024 6:15 pm
Replies: 2
by Pinkmen » Mon Sep 23, 2024 2:16 am

2 Replies

833 Views

Last post by Pinkmen
Wed Sep 25, 2024 6:15 pm
[Solved] Prevent formula result from changing

Last post by Nellap « Mon Sep 23, 2024 6:12 am
Replies: 9
by Nellap » Sat Sep 21, 2024 8:43 am

9 Replies

1826 Views

Last post by Nellap
Mon Sep 23, 2024 6:12 am
[Solved] Multiple issues with number formatting

Last post by OnyxTiger « Sat Sep 21, 2024 10:45 pm
Replies: 8
by OnyxTiger » Mon Sep 16, 2024 8:43 am

8 Replies

2919 Views

Last post by OnyxTiger
Sat Sep 21, 2024 10:45 pm
[Solved] Sort in alphabetic order

Last post by Alex1 « Sat Sep 21, 2024 7:46 pm
Replies: 3
by namely » Sat Sep 21, 2024 2:01 am

3 Replies

1477 Views

Last post by Alex1
Sat Sep 21, 2024 7:46 pm
[Solved] Multiple names vertically in one cell

Last post by revshowers « Sat Sep 21, 2024 3:43 pm
Replies: 2
by revshowers » Wed Sep 18, 2024 8:12 pm

2 Replies

906 Views

Last post by revshowers
Sat Sep 21, 2024 3:43 pm
[Solved] Two separate functions in a cell

Last post by Pinkmen « Fri Sep 20, 2024 9:12 pm
Replies: 2
by Pinkmen » Fri Sep 20, 2024 5:58 pm

2 Replies

795 Views

Last post by Pinkmen
Fri Sep 20, 2024 9:12 pm
[Solved] Add year to cells with month/day

Last post by Lupp « Thu Sep 19, 2024 1:15 pm
Replies: 3
by awascholl » Thu Sep 19, 2024 12:10 am

3 Replies

1136 Views

Last post by Lupp
Thu Sep 19, 2024 1:15 pm
Merge certain content from different rows

Last post by MrProgrammer « Mon Sep 16, 2024 9:36 pm
Replies: 4
by swdistro » Fri Aug 30, 2024 10:50 pm

4 Replies

1623 Views

Last post by MrProgrammer
Mon Sep 16, 2024 9:36 pm
[Solved] Perform table lookup using alias for key

Last post by MrProgrammer « Sun Sep 15, 2024 5:07 pm
Replies: 1
by youni » Sun Sep 15, 2024 9:39 am

1 Replies

1565 Views

Last post by MrProgrammer
Sun Sep 15, 2024 5:07 pm
[Solved] Hyperlink from .ODS to cell in another .ODS

Last post by Dave_CDD « Sat Sep 14, 2024 8:20 pm
Replies: 3
by Dave_CDD » Sat Sep 14, 2024 11:08 am

3 Replies

1108 Views

Last post by Dave_CDD
Sat Sep 14, 2024 8:20 pm
[Solved] Update multiple files without opening them

Last post by Villeroy « Fri Sep 13, 2024 4:40 pm
Replies: 7
by MKZ Industries » Thu Sep 12, 2024 2:13 pm

7 Replies

2349 Views

Last post by Villeroy
Fri Sep 13, 2024 4:40 pm
[Solved] Count text values in multiple sheets

Last post by Johnhk631 « Thu Sep 12, 2024 3:48 pm
Replies: 6
by Johnhk631 » Wed Sep 11, 2024 1:44 am

6 Replies

1418 Views

Last post by Johnhk631
Thu Sep 12, 2024 3:48 pm
[Solved] Rank using 3 columns

Last post by MrProgrammer « Tue Sep 10, 2024 7:21 pm
Replies: 8
by idris » Sun Sep 08, 2024 10:18 am

8 Replies

2125 Views

Last post by MrProgrammer
Tue Sep 10, 2024 7:21 pm
[Solved] Opening password protected spreadsheet

Last post by LastUnicorn « Sun Sep 08, 2024 12:54 pm
Replies: 3
by DelBee » Sat Sep 07, 2024 8:22 pm

3 Replies

1601 Views

Last post by LastUnicorn
Sun Sep 08, 2024 12:54 pm
[Solved] Number format icon for Comma 0

Last post by MrProgrammer « Sat Sep 07, 2024 6:47 pm
Replies: 7
by Notso » Thu Sep 05, 2024 1:23 pm

7 Replies

1515 Views

Last post by MrProgrammer
Sat Sep 07, 2024 6:47 pm
[Solved] Change selection criteria in SUMPRODUCT table

Last post by MrProgrammer « Fri Sep 06, 2024 4:56 pm
Replies: 5
by Pinkmen » Fri Sep 06, 2024 4:29 am

5 Replies

1549 Views

Last post by MrProgrammer
Fri Sep 06, 2024 4:56 pm
[Solved] Err:512 after pasting Excel formula

Last post by Jaguar57 « Thu Sep 05, 2024 11:52 pm
Replies: 15
by Jaguar57 » Thu Sep 05, 2024 6:05 am

15 Replies

2525 Views

Last post by Jaguar57
Thu Sep 05, 2024 11:52 pm
[Solved] Split merged cell in half, horizontally or vertically

Last post by Miratopia « Thu Sep 05, 2024 7:53 am
Replies: 9
by Chris_Devl » Wed Sep 07, 2016 7:33 pm

9 Replies

17245 Views

Last post by Miratopia
Thu Sep 05, 2024 7:53 am

New Topic

23275 topics

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