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

Total redirects: 924131
Calc Guide for 3.x
OpenOffice.org 3.x Calc Guide - HTML
Total redirects: 774822

Total redirects: 774822
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 783789

Total redirects: 783789
Calc Tutorials
Tutorials from this forum
Total redirects: 770872

Total redirects: 770872

New Topic

23347 topics

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

135897 Views

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

Topics

Replies

Views

Last post

[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

816 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

869 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

985 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

973 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

1101 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

1797 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

1768 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

1481 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

771 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

2491 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

970 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

2536 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

969 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

2134 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

3338 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

1695 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

1009 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

892 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

1330 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

1884 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

1646 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

1224 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

2855 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

1650 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

2425 Views

Last post by MrProgrammer
Tue Sep 10, 2024 7:21 pm
[Solved] Opening password protected Excel 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

1747 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

1687 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

1711 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

3227 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

17560 Views

Last post by Miratopia
Thu Sep 05, 2024 7:53 am
[Solved] Choose cell background dynamically

Last post by Lupp « Tue Sep 03, 2024 4:23 pm
Replies: 4
by Calab » Sun Sep 01, 2024 4:07 pm

4 Replies

2389 Views

Last post by Lupp
Tue Sep 03, 2024 4:23 pm
[Dropped] OO/StarOffice Calc 1.5 .sxc recovery

Last post by MrProgrammer « Mon Sep 02, 2024 4:55 pm
Replies: 3
by eylisian » Wed Jan 30, 2008 10:41 pm

3 Replies

3273 Views

Last post by MrProgrammer
Mon Sep 02, 2024 4:55 pm
[Solved] Spreadsheet to HTML

Last post by Fab2024 « Sun Sep 01, 2024 8:33 pm
Replies: 8
by Fab2024 » Sat Aug 31, 2024 12:43 pm

8 Replies

2250 Views

Last post by Fab2024
Sun Sep 01, 2024 8:33 pm
[Solved] Change cell color, by comparing other cells

Last post by rayroshi « Sun Sep 01, 2024 3:31 am
Replies: 2
by rayroshi » Sat Aug 31, 2024 8:38 pm

2 Replies

1323 Views

Last post by rayroshi
Sun Sep 01, 2024 3:31 am
[Solved] Remove cell borders of entire row

Last post by rayroshi « Sat Aug 31, 2024 5:46 pm
Replies: 5
by rayroshi » Sat Aug 31, 2024 3:55 am

5 Replies

2096 Views

Last post by rayroshi
Sat Aug 31, 2024 5:46 pm
[Solved] Track hours in rolling 28-day interval

Last post by JoshuaCJCohen « Sat Aug 31, 2024 5:25 am
Replies: 14
by JoshuaCJCohen » Sun Aug 25, 2024 5:44 pm

14 Replies

3726 Views

Last post by JoshuaCJCohen
Sat Aug 31, 2024 5:25 am
[Solved] Can't use column label 'Quantity' on other sheets

Last post by swdistro « Fri Aug 30, 2024 10:11 pm
Replies: 9
by swdistro » Thu Aug 29, 2024 4:33 am

9 Replies

2363 Views

Last post by swdistro
Fri Aug 30, 2024 10:11 pm
[Solved] Calculate tax up to wage cap

Last post by awascholl « Fri Aug 30, 2024 7:52 pm
Replies: 4
by awascholl » Fri Aug 30, 2024 5:04 pm

4 Replies

1497 Views

Last post by awascholl
Fri Aug 30, 2024 7:52 pm
[Solved] Unable to display date as DD/MMM

Last post by darkspark222 « Tue Aug 27, 2024 3:33 pm
Replies: 5
by darkspark222 » Mon Aug 26, 2024 4:25 pm

5 Replies

2064 Views

Last post by darkspark222
Tue Aug 27, 2024 3:33 pm
[Solved] Return smallest number, but never more than 35

Last post by MrProgrammer « Sat Aug 24, 2024 9:00 pm
Replies: 1
by JerryCaldwell » Sat Aug 24, 2024 7:57 pm

1 Replies

1462 Views

Last post by MrProgrammer
Sat Aug 24, 2024 9:00 pm
[Solved] Switch Excel power user to Calc

Last post by newstrings « Sat Aug 24, 2024 6:33 pm
Replies: 5
by newstrings » Fri Aug 23, 2024 9:42 pm

5 Replies

3029 Views

Last post by newstrings
Sat Aug 24, 2024 6:33 pm
[Solved] Find & Replace feature not working

Last post by procadman « Sat Aug 24, 2024 9:35 am
Replies: 11
by DavidAshman » Tue May 31, 2016 4:31 pm

11 Replies

6398 Views

Last post by procadman
Sat Aug 24, 2024 9:35 am
[Solved] Unusual margin / header I can't get rid of

Last post by BoxGods « Sat Aug 24, 2024 7:21 am
Replies: 2
by BoxGods » Fri Aug 23, 2024 9:32 pm

2 Replies

1478 Views

Last post by BoxGods
Sat Aug 24, 2024 7:21 am
[Solved] Maximum table size for DGET?

Last post by SCFrolich « Thu Aug 22, 2024 3:50 am
Replies: 2
by SCFrolich » Tue Aug 20, 2024 6:24 am

2 Replies

1703 Views

Last post by SCFrolich
Thu Aug 22, 2024 3:50 am
Town and villages to GEO_Data coordinates

Last post by Villeroy « Wed Aug 21, 2024 9:00 pm
Replies: 4
by riva » Wed Aug 21, 2024 2:51 pm

4 Replies

2056 Views

Last post by Villeroy
Wed Aug 21, 2024 9:00 pm
[Solved] Create report using start and end dates

Last post by Alex1 « Mon Aug 19, 2024 6:56 pm
Replies: 2
by adventurehouse » Mon Aug 19, 2024 4:54 pm

2 Replies

1620 Views

Last post by Alex1
Mon Aug 19, 2024 6:56 pm
[Solved] VLOOKUP finds incorrect match

Last post by adventurehouse « Mon Aug 19, 2024 4:44 pm
Replies: 4
by adventurehouse » Mon Aug 19, 2024 3:21 pm

4 Replies

1725 Views

Last post by adventurehouse
Mon Aug 19, 2024 4:44 pm
[Solved] Arrow keys move page, not cell

Last post by tangoviking « Sun Aug 18, 2024 8:48 pm
Replies: 4
by tangoviking » Sun Aug 18, 2024 8:15 pm

4 Replies

2250 Views

Last post by tangoviking
Sun Aug 18, 2024 8:48 pm
[Solved] Sum for Timecodes

Last post by MrProgrammer « Fri Aug 16, 2024 6:13 pm
Replies: 1
by RussvA » Fri Aug 16, 2024 12:18 pm

1 Replies

1704 Views

Last post by MrProgrammer
Fri Aug 16, 2024 6:13 pm
[Solved] LastCellValue function from Quattro Pro

Last post by Zizi64 « Thu Aug 15, 2024 8:02 am
Replies: 4
by rgtr » Wed Aug 14, 2024 1:57 pm

4 Replies

2271 Views

Last post by Zizi64
Thu Aug 15, 2024 8:02 am

New Topic

23347 topics

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