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

Total redirects: 929077
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 780515

Total redirects: 780515
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 789475

Total redirects: 789475
Calc Tutorials
Tutorials from this forum
Total redirects: 776270

Total redirects: 776270

New Topic

23348 topics

Page 9 of 467
- Jump to page:
Previous
1
…
7
8
9
10
11
…
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

137478 Views

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

Topics

Replies

Views

Last post

[Solved] Remove periods in string before @

Last post by robleyd « Wed Jun 19, 2024 12:53 pm
Replies: 3
by OPfan8 » Wed Jun 19, 2024 8:32 am

3 Replies

2850 Views

Last post by robleyd
Wed Jun 19, 2024 12:53 pm
[Solved] Unexpected result for SUM with multiplication

Last post by MrProgrammer « Sat Jun 15, 2024 10:06 pm
Replies: 9
by peanutaxis » Sat Jun 15, 2024 7:23 am

9 Replies

4235 Views

Last post by MrProgrammer
Sat Jun 15, 2024 10:06 pm
[Solved] Auto number only selected cells

Last post by MrProgrammer « Thu Jun 13, 2024 4:24 pm
Replies: 2
by pmascaros2 » Thu Jun 13, 2024 10:57 am

2 Replies

2883 Views

Last post by MrProgrammer
Thu Jun 13, 2024 4:24 pm
[Solved] Add data series to an existing chart

Last post by Kees1 « Fri Jun 07, 2024 9:59 am
Replies: 5
by Kees1 » Wed May 29, 2024 11:12 am

5 Replies

3744 Views

Last post by Kees1
Fri Jun 07, 2024 9:59 am
[Solved] Copy command causes Calc to freeze

Last post by LastUnicorn « Thu Jun 06, 2024 7:15 pm
Replies: 2
by JackField » Thu Jun 06, 2024 6:21 pm

2 Replies

3218 Views

Last post by LastUnicorn
Thu Jun 06, 2024 7:15 pm
[Dropped] Data extraction from Calc sheets

Last post by MrProgrammer « Thu Jun 06, 2024 5:20 am
Replies: 3
by DrdotHouse » Wed Jun 05, 2024 6:16 pm

3 Replies

2545 Views

Last post by MrProgrammer
Thu Jun 06, 2024 5:20 am
[Solved] Copy only alphabetic characters from cell

Last post by Lupp « Tue Jun 04, 2024 12:03 am
Replies: 4
by TheOldThug » Sun Jun 02, 2024 5:16 pm

4 Replies

2775 Views

Last post by Lupp
Tue Jun 04, 2024 12:03 am
[Solved] Use button to increment a cell

Last post by MrProgrammer « Fri May 31, 2024 7:34 pm
Replies: 4
by Dupakos » Thu May 30, 2024 11:10 am

4 Replies

2895 Views

Last post by MrProgrammer
Fri May 31, 2024 7:34 pm
[Solved] Crash when using the Find toolbar

Last post by MrProgrammer « Fri May 31, 2024 2:45 am
Replies: 4
by tixmascot » Thu May 30, 2024 9:18 pm

4 Replies

3154 Views

Last post by MrProgrammer
Fri May 31, 2024 2:45 am
[Solved] Use literal " in a FIND function parameter

Last post by RianMonnahan « Thu May 30, 2024 8:05 pm
Replies: 4
by RianMonnahan » Thu May 30, 2024 2:07 pm

4 Replies

2695 Views

Last post by RianMonnahan
Thu May 30, 2024 8:05 pm
Password protected won't let me in with my password!

Last post by Hagar Delest « Wed May 29, 2024 8:03 am
Replies: 1
by kittymama » Wed May 29, 2024 7:27 am

1 Replies

2089 Views

Last post by Hagar Delest
Wed May 29, 2024 8:03 am
[Solved] Sum largest 7 of 12 values

Last post by Snewsh « Fri May 24, 2024 11:26 am
Replies: 2
by Snewsh » Wed May 22, 2024 2:18 pm

2 Replies

2578 Views

Last post by Snewsh
Fri May 24, 2024 11:26 am
Saved document is "covered with X's"

Last post by chft8597 « Thu May 23, 2024 4:16 pm
Replies: 3
by chft8597 » Wed May 22, 2024 10:48 pm

3 Replies

2338 Views

Last post by chft8597
Thu May 23, 2024 4:16 pm
[Solved] Add whole years to a given date

Last post by okjhum « Wed May 22, 2024 3:46 pm
Replies: 8
by okjhum » Sat Feb 04, 2017 1:21 pm

8 Replies

8239 Views

Last post by okjhum
Wed May 22, 2024 3:46 pm
[Dropped] Retrieve multiple unique values from list

Last post by Lupp « Wed May 22, 2024 2:20 pm
Replies: 3
by Dig818 » Wed May 22, 2024 2:52 am

3 Replies

2224 Views

Last post by Lupp
Wed May 22, 2024 2:20 pm
[Solved] Concatenate column content into single cell

Last post by Lupp « Wed May 22, 2024 1:51 am
Replies: 7
by sura » Sat Dec 04, 2021 3:37 am

7 Replies

3862 Views

Last post by Lupp
Wed May 22, 2024 1:51 am
[Issue] Update Links prompts during open

Last post by Bidouille « Tue May 21, 2024 10:10 am
Replies: 16
by trcjt.ca » Mon May 20, 2024 2:32 am

16 Replies

4278 Views

Last post by Bidouille
Tue May 21, 2024 10:10 am
[Solved] Reference to VLOOKUP in another file

Last post by Alex1 « Mon May 20, 2024 9:37 pm
Replies: 7
by MrMerlin » Sun May 19, 2024 2:37 pm

7 Replies

2412 Views

Last post by Alex1
Mon May 20, 2024 9:37 pm
[Solved] Set conditional format for each row

Last post by oof123 « Sun May 19, 2024 11:38 pm
Replies: 2
by oof123 » Sun May 19, 2024 10:11 pm

2 Replies

2854 Views

Last post by oof123
Sun May 19, 2024 11:38 pm
[Solved] Populate game data with a list

Last post by MrProgrammer « Sun May 19, 2024 7:07 pm
Replies: 3
by ssnewbie » Fri May 17, 2024 9:12 am

3 Replies

4322 Views

Last post by MrProgrammer
Sun May 19, 2024 7:07 pm
[Solved] Unexpected result from VLOOKUP

Last post by Binu « Sun May 19, 2024 6:09 pm
Replies: 4
by Binu » Sun May 19, 2024 4:16 pm

4 Replies

1946 Views

Last post by Binu
Sun May 19, 2024 6:09 pm
[Solved] Use wildcard (asterisk) with SUMIF

Last post by iddqd « Sat May 18, 2024 11:42 am
Replies: 6
by iddqd » Mon May 13, 2024 2:47 pm

6 Replies

2546 Views

Last post by iddqd
Sat May 18, 2024 11:42 am
File is empty after electric black-out

Last post by robleyd « Fri May 17, 2024 1:16 am
Replies: 2
by billpag » Thu May 16, 2024 7:16 pm

2 Replies

1805 Views

Last post by robleyd
Fri May 17, 2024 1:16 am
[Solved] Columns A and B disappeared

Last post by lordalford « Thu May 16, 2024 10:40 am
Replies: 4
by lordalford » Thu May 16, 2024 10:22 am

4 Replies

1971 Views

Last post by lordalford
Thu May 16, 2024 10:40 am
[Solved] Error 504 in MATCH & OFFSET formula

Last post by Cat101 « Thu May 16, 2024 7:09 am
Replies: 7
by Cat101 » Sat May 11, 2024 6:07 am

7 Replies

2887 Views

Last post by Cat101
Thu May 16, 2024 7:09 am
[Solved] WEEKNUM + text

Last post by MrProgrammer « Tue May 14, 2024 4:33 pm
Replies: 6
by amDEwolff » Sun May 12, 2024 2:55 pm

6 Replies

2758 Views

Last post by MrProgrammer
Tue May 14, 2024 4:33 pm
[Issue] CSV import converts Carriage Return to Line Feed

Last post by Bidouille « Mon May 13, 2024 3:54 pm
Replies: 8
by Monster » Thu Jun 01, 2023 12:03 pm

8 Replies

3541 Views

Last post by Bidouille
Mon May 13, 2024 3:54 pm
[Solved] Remove pivot table filter

Last post by MrProgrammer « Sun May 12, 2024 4:04 pm
Replies: 1
by ericjj » Sat May 11, 2024 10:06 pm

1 Replies

1654 Views

Last post by MrProgrammer
Sun May 12, 2024 4:04 pm
[Solved] Increase rankings in RPG with experience points

Last post by Rydviking « Sat May 11, 2024 11:07 pm
Replies: 12
by Rydviking » Tue May 07, 2024 10:57 pm

12 Replies

2635 Views

Last post by Rydviking
Sat May 11, 2024 11:07 pm
[Solved] Find date in column

Last post by Cat101 « Sat May 11, 2024 5:16 am
Replies: 5
by Cat101 » Thu May 09, 2024 1:48 am

5 Replies

1842 Views

Last post by Cat101
Sat May 11, 2024 5:16 am
[Solved] Set default date format to ISO 8601 YYYY-MM-DD

Last post by Villeroy « Sat May 11, 2024 12:32 am
Replies: 3
by fishnuke » Wed Mar 29, 2017 5:48 pm

3 Replies

5790 Views

Last post by Villeroy
Sat May 11, 2024 12:32 am
[Solved] Error on cut feature

Last post by Zizi64 « Wed May 08, 2024 6:43 am
Replies: 2
by shbug01 » Tue May 07, 2024 7:24 pm

2 Replies

1311 Views

Last post by Zizi64
Wed May 08, 2024 6:43 am
Forced to save spreadsheet after copy down

Last post by Hagar Delest « Tue May 07, 2024 7:52 am
Replies: 1
by rdmg56v » Tue May 07, 2024 7:01 am

1 Replies

1058 Views

Last post by Hagar Delest
Tue May 07, 2024 7:52 am
Group sheets by type

Last post by Lupp « Mon May 06, 2024 10:46 pm
Replies: 6
by Robitron » Fri May 03, 2024 2:44 pm

6 Replies

1977 Views

Last post by Lupp
Mon May 06, 2024 10:46 pm
[Solved] Count of A1<B1 or A2<B2 or A3<B3 ...

Last post by MrProgrammer « Mon May 06, 2024 8:22 pm
Replies: 5
by Rhed » Mon May 06, 2024 8:55 am

5 Replies

1466 Views

Last post by MrProgrammer
Mon May 06, 2024 8:22 pm
[Solved] Calculate a period as years, months, and days

Last post by okjhum « Mon May 06, 2024 4:50 pm
Replies: 37
by Juanchio88 » Thu Jan 26, 2017 6:56 pm
1

2
37 Replies

20860 Views

Last post by okjhum
Mon May 06, 2024 4:50 pm
[Solved] Keep background color settings

Last post by karolus « Sun May 05, 2024 7:15 am
Replies: 3
by cindyowe » Sun Feb 21, 2021 4:18 am

3 Replies

1662 Views

Last post by karolus
Sun May 05, 2024 7:15 am
[Solved] Document recovery EVERY time!

Last post by radios « Fri May 03, 2024 11:52 am
Replies: 5
by PeterJS » Sun Apr 14, 2013 11:13 pm

5 Replies

3596 Views

Last post by radios
Fri May 03, 2024 11:52 am
[Solved] Determine running batting average

Last post by MrProgrammer « Thu May 02, 2024 12:18 am
Replies: 5
by Stonehenge » Wed May 01, 2024 12:12 pm

5 Replies

1555 Views

Last post by MrProgrammer
Thu May 02, 2024 12:18 am
[Solved] Budget with recurring income/expenses

Last post by MrProgrammer « Tue Apr 30, 2024 3:52 am
Replies: 3
by PixelComposer » Mon Apr 29, 2024 6:23 pm

3 Replies

1472 Views

Last post by MrProgrammer
Tue Apr 30, 2024 3:52 am
[Dropped] Some borders do not print

Last post by Bill « Mon Apr 29, 2024 10:11 pm
Replies: 17
by tapceo » Wed Apr 24, 2024 1:18 am

17 Replies

4706 Views

Last post by Bill
Mon Apr 29, 2024 10:11 pm
[Solved] Conditional format: Value = {value of cell above}

Last post by FJCC « Sat Apr 27, 2024 3:27 am
Replies: 1
by Calab » Sat Apr 27, 2024 2:55 am

1 Replies

1086 Views

Last post by FJCC
Sat Apr 27, 2024 3:27 am
[Solved] Determine last cell on sheet with value

Last post by MrProgrammer « Thu Apr 25, 2024 6:02 pm
Replies: 7
by me231 » Tue Apr 02, 2024 5:28 pm

7 Replies

2383 Views

Last post by MrProgrammer
Thu Apr 25, 2024 6:02 pm
[Solved] Precision as shown

Last post by TheOldThug « Thu Apr 25, 2024 3:09 pm
Replies: 4
by TheOldThug » Thu Apr 25, 2024 4:47 am

4 Replies

1266 Views

Last post by TheOldThug
Thu Apr 25, 2024 3:09 pm
[Solved] Set default font and size

Last post by Tucson77 « Mon Apr 22, 2024 11:39 am
Replies: 5
by Tucson77 » Wed Apr 17, 2024 3:24 pm

5 Replies

2161 Views

Last post by Tucson77
Mon Apr 22, 2024 11:39 am
[Solved] No Windows menu; can't use Freeze

Last post by Mountaineer « Thu Apr 18, 2024 9:14 am
Replies: 8
by coachdaniel52 » Wed Apr 17, 2024 3:26 pm

8 Replies

1989 Views

Last post by Mountaineer
Thu Apr 18, 2024 9:14 am
[Solved] Dropdown list and images

Last post by MrProgrammer « Sun Apr 14, 2024 6:14 pm
Replies: 1
by lonel » Fri Apr 12, 2024 9:50 pm

1 Replies

990 Views

Last post by MrProgrammer
Sun Apr 14, 2024 6:14 pm
[Solved] Use value from cell as text in a different cell

Last post by dervish_mcdroid « Sat Apr 13, 2024 6:03 pm
Replies: 2
by dervish_mcdroid » Sat Apr 13, 2024 3:40 pm

2 Replies

812 Views

Last post by dervish_mcdroid
Sat Apr 13, 2024 6:03 pm
[Solved] Extract numbers from alphanumeric text

Last post by Lupp « Sat Apr 13, 2024 1:42 pm
Replies: 27
by slsleng » Thu Apr 26, 2012 5:27 am

27 Replies

103121 Views

Last post by Lupp
Sat Apr 13, 2024 1:42 pm
[Solved] Fill down, from another sheet's across cells

Last post by Dongatrash « Sat Apr 13, 2024 8:18 am
Replies: 6
by Dongatrash » Fri Apr 12, 2024 9:45 am

6 Replies

1156 Views

Last post by Dongatrash
Sat Apr 13, 2024 8:18 am

New Topic

23348 topics

Page 9 of 467
- Jump to page:
Previous
1
…
7
8
9
10
11
…
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