Apache OpenOffice Community Forum - Calc

Calc

Forum

Topics

Posts

Last post

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

Total redirects: 49616
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 52077

Total redirects: 52077
Calc Tutorials
Tutorials from this forum
Total redirects: 49013

Total redirects: 49013

New Topic

22105 topics

Page 1 of 443
- Jump to page:
1
2
3
4
5
…
443
Next

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.12 released

Last post by robleyd « Thu May 05, 2022 2:15 am
Posted in Announcements

by robleyd » Thu May 05, 2022 2:15 am » in Announcements

0 Replies

2159 Views

Last post by robleyd
Thu May 05, 2022 2:15 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

76081 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
Err:502 using INDEX() function

Last post by Villeroy « Sat May 28, 2022 6:42 pm
Replies: 5
by Scarsax2018 » Sat May 28, 2022 1:55 pm

5 Replies

87 Views

Last post by Villeroy
Sat May 28, 2022 6:42 pm
Problem importing / downloading data from webpages

Last post by Villeroy « Sat May 28, 2022 11:47 am
Replies: 1
by ra-loffice » Sat May 28, 2022 5:20 am

1 Replies

60 Views

Last post by Villeroy
Sat May 28, 2022 11:47 am
[Solved] Remove duplicate text between two cells

Last post by karolus « Sat May 28, 2022 8:53 am
Replies: 3
by SaintsLair » Sat May 28, 2022 4:45 am

3 Replies

74 Views

Last post by karolus
Sat May 28, 2022 8:53 am
[Solved] Extract data from date sequenced files

Last post by DaveStone « Thu May 26, 2022 4:59 pm
Replies: 4
by DaveStone » Thu May 26, 2022 11:32 am

4 Replies

159 Views

Last post by DaveStone
Thu May 26, 2022 4:59 pm
[Solved] Turning first column into header

Last post by LoganVer « Thu May 26, 2022 3:54 pm
Replies: 2
by LoganVer » Wed May 25, 2022 4:56 pm

2 Replies

165 Views

Last post by LoganVer
Thu May 26, 2022 3:54 pm
[Solved] Calculation Cell Displays ###

Last post by 3ME « Wed May 25, 2022 4:22 pm
Replies: 2
by 3ME » Tue May 24, 2022 11:42 pm

2 Replies

106 Views

Last post by 3ME
Wed May 25, 2022 4:22 pm
[Solved] Auto numbering of rows in spreadsheet

Last post by rhenschel@cfl.rr.com « Wed May 25, 2022 5:05 am
Replies: 5
by rhenschel@cfl.rr.com » Wed May 25, 2022 2:16 am

5 Replies

129 Views

Last post by rhenschel@cfl.rr.com
Wed May 25, 2022 5:05 am
SEARCH function returns #VALUE!

Last post by robbyn « Mon May 23, 2022 8:57 pm
Replies: 5
by robbyn » Mon May 23, 2022 12:26 am

5 Replies

224 Views

Last post by robbyn
Mon May 23, 2022 8:57 pm
Compare two csv and fill e-mail adresses

Last post by John_Ha « Mon May 23, 2022 4:18 pm
Replies: 2
by womke » Mon May 23, 2022 1:21 pm

2 Replies

124 Views

Last post by John_Ha
Mon May 23, 2022 4:18 pm
Formatting from varying lists

Last post by SCFrolich « Sun May 22, 2022 11:08 pm
Replies: 2
by SCFrolich » Sun May 22, 2022 6:49 pm

2 Replies

110 Views

Last post by SCFrolich
Sun May 22, 2022 11:08 pm
[Solved] Some general settings issues in Calc

Last post by tixmascot « Sat May 21, 2022 6:19 pm
Replies: 4
by tixmascot » Sat May 21, 2022 5:59 pm

4 Replies

129 Views

Last post by tixmascot
Sat May 21, 2022 6:19 pm
Accounting template help

Last post by RoryOF « Fri May 20, 2022 11:21 am
Replies: 5
by Thotenvin » Thu May 19, 2022 5:16 am

5 Replies

236 Views

Last post by RoryOF
Fri May 20, 2022 11:21 am
[Solved] Calc feature to merge category values

Last post by John_Ha « Fri May 20, 2022 2:31 am
Replies: 3
by eowarion » Thu May 19, 2022 11:44 pm

3 Replies

139 Views

Last post by John_Ha
Fri May 20, 2022 2:31 am
[Solved] Copy "magic" formula to return unique values

Last post by JohnSUN-Pensioner « Thu May 19, 2022 9:57 am
Replies: 1
by Twidget » Thu May 19, 2022 9:49 am

1 Replies

86 Views

Last post by JohnSUN-Pensioner
Thu May 19, 2022 9:57 am
[Solved] Range name for multiple cells

Last post by MrProgrammer « Wed May 18, 2022 5:43 pm
Replies: 1
by winchell » Wed May 18, 2022 9:27 am

1 Replies

154 Views

Last post by MrProgrammer
Wed May 18, 2022 5:43 pm
[Solved] Add "Normal Range" to graph of lab results?

Last post by keme « Wed May 18, 2022 2:45 pm
Replies: 1
by TsuDhoNimh » Wed May 18, 2022 2:01 pm

1 Replies

88 Views

Last post by keme
Wed May 18, 2022 2:45 pm
[Solved] Counting all instances of a word amongst multiple ranges

Last post by karolus « Tue May 17, 2022 10:00 am
Replies: 3
by AaZ » Mon May 16, 2022 7:07 pm

3 Replies

225 Views

Last post by karolus
Tue May 17, 2022 10:00 am
[Solved] Rearrange data from columns to rows

Last post by robleyd « Tue May 17, 2022 2:35 am
Replies: 8
by jmc777 » Mon May 16, 2022 9:14 pm

8 Replies

284 Views

Last post by robleyd
Tue May 17, 2022 2:35 am
[Solved] COUNTIFS Multiple Criteria

Last post by Cat101 « Tue May 17, 2022 12:32 am
Replies: 14
by Cat101 » Thu May 12, 2022 1:59 am

14 Replies

550 Views

Last post by Cat101
Tue May 17, 2022 12:32 am
[Solved] Calc crashes after "No Fill" chosen

Last post by officeuser1138 « Mon May 16, 2022 5:33 pm
Replies: 3
by officeuser1138 » Sat May 14, 2022 7:12 pm

3 Replies

219 Views

Last post by officeuser1138
Mon May 16, 2022 5:33 pm
[Solved] Formula with fixed reference to a cell

Last post by FJCC « Mon May 16, 2022 4:34 pm
Replies: 1
by H.G. SPENCER » Mon May 16, 2022 4:06 pm

1 Replies

114 Views

Last post by FJCC
Mon May 16, 2022 4:34 pm
[Solved] Combining text and formula

Last post by Bob22 « Sun May 15, 2022 2:46 pm
Replies: 2
by Bob22 » Sat May 14, 2022 9:40 pm

2 Replies

141 Views

Last post by Bob22
Sun May 15, 2022 2:46 pm
[Solved] Calendar for Staff Vacations

Last post by Cat101 « Sat May 14, 2022 5:04 am
Replies: 20
by Cat101 » Fri Jan 07, 2022 5:14 am

20 Replies

1952 Views

Last post by Cat101
Sat May 14, 2022 5:04 am
[Solved] Using Data > Filter > Standard Filter [More Options] Copy feature

Last post by Hagar Delest « Fri May 13, 2022 9:38 pm
Replies: 13
by Cat101 » Thu May 12, 2022 2:58 am

13 Replies

474 Views

Last post by Hagar Delest
Fri May 13, 2022 9:38 pm
[Solved] Skip formula columns during data entry

Last post by dkz1964 « Fri May 13, 2022 8:45 pm
Replies: 3
by dkz1964 » Thu May 12, 2022 10:25 pm

3 Replies

192 Views

Last post by dkz1964
Fri May 13, 2022 8:45 pm
Calc Locks Up Every Time I Try to Save File

Last post by Hagar Delest « Fri May 13, 2022 9:33 am
Replies: 4
by rdevarona » Thu May 12, 2022 2:57 am

4 Replies

203 Views

Last post by Hagar Delest
Fri May 13, 2022 9:33 am
[Solved] Rounding issues with decimal places

Last post by puttboy « Fri May 13, 2022 1:27 am
Replies: 6
by puttboy » Thu May 12, 2022 2:00 am

6 Replies

273 Views

Last post by puttboy
Fri May 13, 2022 1:27 am
[Solved] Err:508 on import of Excel "structured references"

Last post by MrProgrammer « Wed May 11, 2022 6:56 pm
Replies: 8
by bobtabla » Tue May 10, 2022 4:48 pm

8 Replies

435 Views

Last post by MrProgrammer
Wed May 11, 2022 6:56 pm
Custom function not recognized by Calc

Last post by Zizi64 « Wed May 11, 2022 7:59 am
Replies: 5
by Kadence » Tue May 10, 2022 6:49 pm

5 Replies

257 Views

Last post by Zizi64
Wed May 11, 2022 7:59 am
[Dropped] Message: /Average 128 does not exist

Last post by MrProgrammer « Mon May 09, 2022 4:20 pm
Replies: 2
by KansasPapaOf12 » Mon May 09, 2022 6:33 am

2 Replies

234 Views

Last post by MrProgrammer
Mon May 09, 2022 4:20 pm
Opening TSV files in a speadsheet in OpenOffice.org

Last post by Villeroy « Sun May 08, 2022 2:54 pm
Replies: 9
by Bogdan Petrenko » Fri Apr 18, 2008 5:10 pm

9 Replies

10608 Views

Last post by Villeroy
Sun May 08, 2022 2:54 pm
[Solved] Set different default font for new spreadsheets

Last post by bob.c@crownfield.com « Fri May 06, 2022 6:02 am
Replies: 10
by bob.c@crownfield.com » Fri Apr 29, 2022 11:36 pm

10 Replies

894 Views

Last post by bob.c@crownfield.com
Fri May 06, 2022 6:02 am
[Dropped] Pulling from list

Last post by smith68 « Fri May 06, 2022 3:08 am
Replies: 4
by smith68 » Mon May 02, 2022 4:14 pm

4 Replies

495 Views

Last post by smith68
Fri May 06, 2022 3:08 am
[Solved] Combining data from two sheets

Last post by Villeroy « Thu May 05, 2022 6:04 pm
Replies: 8
by dan@silvermans.co.uk » Thu May 05, 2022 11:52 am

8 Replies

376 Views

Last post by Villeroy
Thu May 05, 2022 6:04 pm
[Solved] Multiple search criteria for cross table layout

Last post by Phen « Tue May 03, 2022 4:08 pm
Replies: 2
by Phen » Tue May 03, 2022 10:46 am

2 Replies

331 Views

Last post by Phen
Tue May 03, 2022 4:08 pm
[Dropped] Duplicate sheet Print Area Issue

Last post by RusselB « Tue May 03, 2022 12:46 am
Replies: 1
by dranem » Mon May 02, 2022 2:24 pm

1 Replies

306 Views

Last post by RusselB
Tue May 03, 2022 12:46 am
[Solved] Change formulae when naming cell

Last post by mwaffle90 « Sun May 01, 2022 4:46 pm
Replies: 2
by mwaffle90 » Sun May 01, 2022 4:20 pm

2 Replies

329 Views

Last post by mwaffle90
Sun May 01, 2022 4:46 pm
[Solved] Multiple formulas / priority / override?

Last post by FJCC « Fri Apr 29, 2022 4:03 am
Replies: 10
by swdistro » Sun Apr 24, 2022 5:51 pm

10 Replies

1039 Views

Last post by FJCC
Fri Apr 29, 2022 4:03 am
[Solved] Protecting a subset of cells

Last post by keme « Thu Apr 28, 2022 8:34 am
Replies: 10
by Generet » Tue Apr 26, 2022 12:54 am

10 Replies

1171 Views

Last post by keme
Thu Apr 28, 2022 8:34 am
[Solved] Not Responding on save

Last post by AccessShell « Thu Apr 28, 2022 12:04 am
Replies: 7
by AccessShell » Wed Apr 27, 2022 5:18 pm

7 Replies

517 Views

Last post by AccessShell
Thu Apr 28, 2022 12:04 am
[Solved] VLOOKUP returns #N/A

Last post by Cat101 « Wed Apr 27, 2022 12:10 am
Replies: 2
by Cat101 » Tue Apr 26, 2022 4:57 am

2 Replies

555 Views

Last post by Cat101
Wed Apr 27, 2022 12:10 am
[Dropped] Calc charts not updating with new data

Last post by John_Ha « Tue Apr 26, 2022 11:01 am
Replies: 6
by ra-loffice » Mon Apr 25, 2022 4:04 pm

6 Replies

764 Views

Last post by John_Ha
Tue Apr 26, 2022 11:01 am
[Dropped] Create live mirrored tables editable both ways

Last post by MrProgrammer « Mon Apr 25, 2022 11:09 pm
Replies: 2
by idris.cheikh » Sun Apr 24, 2022 10:59 pm

2 Replies

634 Views

Last post by MrProgrammer
Mon Apr 25, 2022 11:09 pm
[Solved] Preserve cell reference when formula is copied

Last post by camada « Mon Apr 25, 2022 6:27 pm
Replies: 2
by camada » Mon Apr 25, 2022 5:03 pm

2 Replies

491 Views

Last post by camada
Mon Apr 25, 2022 6:27 pm
[Solved] Determine if two time intervals overlap

Last post by idris.cheikh « Sun Apr 24, 2022 9:54 pm
Replies: 2
by idris.cheikh » Thu Apr 14, 2022 1:39 am

2 Replies

683 Views

Last post by idris.cheikh
Sun Apr 24, 2022 9:54 pm
[Solved] Record macro to modify chart dataseries

Last post by AccessShell « Sat Apr 23, 2022 2:40 pm
Replies: 4
by AccessShell » Fri Apr 22, 2022 10:36 pm

4 Replies

732 Views

Last post by AccessShell
Sat Apr 23, 2022 2:40 pm
[Solved] Date 3/4 it appears as a tiny number ¾

Last post by Zizi64 « Sat Apr 23, 2022 6:28 am
Replies: 4
by Debo » Fri Apr 22, 2022 9:58 pm

4 Replies

679 Views

Last post by Zizi64
Sat Apr 23, 2022 6:28 am
Why won’t AO Office Pro handle a locked Calc Worksheet?

Last post by sveld « Fri Apr 22, 2022 6:42 pm
Replies: 6
by alf50 » Sun Apr 17, 2022 5:45 am

6 Replies

901 Views

Last post by sveld
Fri Apr 22, 2022 6:42 pm
[Solved] Average of time entries

Last post by MrProgrammer « Tue Apr 19, 2022 4:59 pm
Replies: 1
by malk415 » Tue Apr 19, 2022 4:12 am

1 Replies

464 Views

Last post by MrProgrammer
Tue Apr 19, 2022 4:59 pm

New Topic

22105 topics

Page 1 of 443
- Jump to page:
1
2
3
4
5
…
443
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