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

Total redirects: 49782
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 52278

Total redirects: 52278
Calc Tutorials
Tutorials from this forum
Total redirects: 49211

Total redirects: 49211

New Topic

22141 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

5648 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

76521 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
Adding up the times

Last post by MrProgrammer « Sat Jun 25, 2022 6:47 pm
Replies: 3
by Bernadine » Mon Jun 20, 2022 3:01 am

3 Replies

129 Views

Last post by MrProgrammer
Sat Jun 25, 2022 6:47 pm
Set cell colors based on dropdown selection

Last post by eeigor « Sat Jun 25, 2022 5:10 pm
Replies: 35
by Noobian » Mon Jun 20, 2022 8:03 pm
1

2
35 Replies

680 Views

Last post by eeigor
Sat Jun 25, 2022 5:10 pm
The operation Search indicates only the cell

Last post by Lupp « Sat Jun 25, 2022 4:45 pm
Replies: 2
by AKle » Sat Jun 25, 2022 1:25 pm

2 Replies

43 Views

Last post by Lupp
Sat Jun 25, 2022 4:45 pm
Weekly Sum Of Trade Results Without A Trade Every Day?

Last post by CapCrockett « Sat Jun 25, 2022 3:07 pm
Replies: 6
by CapCrockett » Fri Jun 24, 2022 11:58 pm

6 Replies

101 Views

Last post by CapCrockett
Sat Jun 25, 2022 3:07 pm
How to drag Formula without mouse on ipad

Last post by Zizi64 « Sat Jun 25, 2022 5:25 am
Replies: 1
by Kaiser » Fri Jun 24, 2022 7:49 pm

1 Replies

46 Views

Last post by Zizi64
Sat Jun 25, 2022 5:25 am
[Solved] CHOOSE function from a table

Last post by Cat101 « Fri Jun 24, 2022 3:23 am
Replies: 8
by Cat101 » Thu Jun 23, 2022 2:32 am

8 Replies

217 Views

Last post by Cat101
Fri Jun 24, 2022 3:23 am
[Solved] Numbers file not fully opening

Last post by UltimateTopTrumps « Thu Jun 23, 2022 3:01 pm
Replies: 2
by UltimateTopTrumps » Thu Jun 23, 2022 1:45 pm

2 Replies

69 Views

Last post by UltimateTopTrumps
Thu Jun 23, 2022 3:01 pm
Sum ignoring non numbers

Last post by robleyd « Thu Jun 23, 2022 1:28 pm
Replies: 1
by pmanthony » Thu Jun 23, 2022 12:46 pm

1 Replies

79 Views

Last post by robleyd
Thu Jun 23, 2022 1:28 pm
How do I find which standard filters are applied?

Last post by WardXmodem « Mon Jun 20, 2022 10:18 pm
Replies: 3
by WardXmodem » Mon Jun 20, 2022 4:34 am

3 Replies

167 Views

Last post by WardXmodem
Mon Jun 20, 2022 10:18 pm
[Solved] Mortgage Calc PMT formula

Last post by Notatechie « Mon Jun 20, 2022 3:14 am
Replies: 2
by Notatechie » Mon Jun 20, 2022 1:30 am

2 Replies

114 Views

Last post by Notatechie
Mon Jun 20, 2022 3:14 am
[Solved] Drop Down List & auto calculations

Last post by Cobbles_Classics « Sun Jun 19, 2022 4:46 pm
Replies: 4
by Cobbles_Classics » Thu Jun 16, 2022 7:33 pm

4 Replies

207 Views

Last post by Cobbles_Classics
Sun Jun 19, 2022 4:46 pm
Starting a business; need to keep accounts; can I use AOO?

Last post by Villeroy « Sun Jun 19, 2022 11:44 am
Replies: 4
by sijarvis » Sun Jun 19, 2022 12:51 am

4 Replies

162 Views

Last post by Villeroy
Sun Jun 19, 2022 11:44 am
[Solved] Retrieve all data if multiple matches; VLOOKUP?

Last post by Redskunk « Sun Jun 19, 2022 3:41 am
Replies: 18
by Redskunk » Thu Jun 16, 2022 4:49 am

18 Replies

669 Views

Last post by Redskunk
Sun Jun 19, 2022 3:41 am
Not everything on the spreadsheet is printed. How to fix

Last post by Sat « Sat Jun 18, 2022 10:08 pm
Replies: 6
by Sat » Tue Jun 07, 2022 5:38 am

6 Replies

431 Views

Last post by Sat
Sat Jun 18, 2022 10:08 pm
[Solved] Highlight entire row if value is between X and Y

Last post by Villeroy « Sat Jun 18, 2022 7:33 pm
Replies: 6
by ListingAndy » Fri Jun 17, 2022 7:50 am

6 Replies

277 Views

Last post by Villeroy
Sat Jun 18, 2022 7:33 pm
[Solved] Change from US date to European date with Calc

Last post by Hagar Delest « Fri Jun 17, 2022 8:32 pm
Replies: 3
by Carlo Quirico » Thu Jun 16, 2022 4:33 pm

3 Replies

218 Views

Last post by Hagar Delest
Fri Jun 17, 2022 8:32 pm
[Solved] Link or amalgamate groups when rows in between

Last post by robbyn « Fri Jun 17, 2022 3:16 am
Replies: 7
by robbyn » Wed Jun 15, 2022 11:39 pm

7 Replies

387 Views

Last post by robbyn
Fri Jun 17, 2022 3:16 am
[Solved] Rounding issues with decimal places

Last post by steverat « Thu Jun 16, 2022 8:17 pm
Replies: 8
by puttboy » Thu May 12, 2022 2:00 am

8 Replies

393 Views

Last post by steverat
Thu Jun 16, 2022 8:17 pm
Can't Open Excel Files

Last post by Bill « Wed Jun 15, 2022 2:56 am
Replies: 5
by ttiwkram » Tue Jun 14, 2022 1:37 am

5 Replies

285 Views

Last post by Bill
Wed Jun 15, 2022 2:56 am
[Solved] Strikethrough invisible

Last post by TacoBrain « Tue Jun 14, 2022 6:38 pm
Replies: 7
by TacoBrain » Sun Jun 12, 2022 11:54 pm

7 Replies

443 Views

Last post by TacoBrain
Tue Jun 14, 2022 6:38 pm
Multiple search and return value of cell from side column

Last post by wchpikus-gmail « Tue Jun 14, 2022 6:26 pm
Replies: 2
by wchpikus-gmail » Tue Jun 14, 2022 8:13 am

2 Replies

206 Views

Last post by wchpikus-gmail
Tue Jun 14, 2022 6:26 pm
[Solved] Randomly select 6.8%, 7.0%, 7.2%, 7.4%, 7.6%, 7.8%, 8.0%

Last post by eng215 « Mon Jun 13, 2022 3:42 pm
Replies: 2
by eng215 » Sun Jun 12, 2022 6:06 pm

2 Replies

263 Views

Last post by eng215
Mon Jun 13, 2022 3:42 pm
[Solved] Strip multiple brackets & text inside

Last post by lucagiai « Mon Jun 13, 2022 9:34 am
Replies: 2
by lucagiai » Mon Jun 06, 2022 1:05 pm

2 Replies

230 Views

Last post by lucagiai
Mon Jun 13, 2022 9:34 am
[Dropped] Why does OpenOffice use 99% of CPU and slow my computer?

Last post by karolus « Sun Jun 12, 2022 3:49 am
Replies: 4
by axelrose » Sat Jun 11, 2022 2:34 pm

4 Replies

272 Views

Last post by karolus
Sun Jun 12, 2022 3:49 am
More Think Or Swim DDE problems

Last post by CrankyEngineer « Thu Jun 09, 2022 6:57 pm
Replies: 3
by CrankyEngineer » Thu Apr 14, 2022 11:34 pm

3 Replies

159 Views

Last post by CrankyEngineer
Thu Jun 09, 2022 6:57 pm
[Solved] Copy and Paste Rows excluding hidden columns

Last post by Zizi64 « Wed Jun 08, 2022 4:30 pm
Replies: 6
by ithepact » Wed Jun 08, 2022 8:28 am

6 Replies

291 Views

Last post by Zizi64
Wed Jun 08, 2022 4:30 pm
[Solved] Organise cell values, by date (month/year) for calculation.

Last post by Cobbles_Classics « Wed Jun 08, 2022 12:27 pm
Replies: 4
by Cobbles_Classics » Tue Jun 07, 2022 7:57 pm

4 Replies

240 Views

Last post by Cobbles_Classics
Wed Jun 08, 2022 12:27 pm
[Dropped] Loops or Repetitive Function

Last post by Lupp « Wed Jun 08, 2022 12:44 am
Replies: 2
by LeonardranoeL » Tue Jun 07, 2022 11:17 pm

2 Replies

196 Views

Last post by Lupp
Wed Jun 08, 2022 12:44 am
Warning: MULTIPLE.OPERATIONS

Last post by Lupp « Tue Jun 07, 2022 9:04 pm
Replies: 2
by Lupp » Tue Jun 07, 2022 1:30 pm

2 Replies

177 Views

Last post by Lupp
Tue Jun 07, 2022 9:04 pm
[Solved] Change Cell Background Colour To A Customised Colour

Last post by Antipodes « Tue Jun 07, 2022 2:24 pm
Replies: 7
by Antipodes » Mon Jun 06, 2022 11:16 am

7 Replies

335 Views

Last post by Antipodes
Tue Jun 07, 2022 2:24 pm
[Dropped] How to automatize selecting rows

Last post by MrProgrammer « Tue Jun 07, 2022 12:02 am
Replies: 1
by bonhart5 » Mon Jun 06, 2022 10:46 pm

1 Replies

198 Views

Last post by MrProgrammer
Tue Jun 07, 2022 12:02 am
Another one with "JRE not found" and nothing works

Last post by Villeroy « Mon Jun 06, 2022 7:31 pm
Replies: 36
by windowshater » Fri Mar 05, 2021 2:59 am
1

2
36 Replies

4368 Views

Last post by Villeroy
Mon Jun 06, 2022 7:31 pm
[Solved] Spread sheet is somehow write protected

Last post by fjwag3 « Sun Jun 05, 2022 5:21 pm
Replies: 5
by fjwag3 » Sun Jun 05, 2022 12:54 am

5 Replies

238 Views

Last post by fjwag3
Sun Jun 05, 2022 5:21 pm
Line chart - how to annotate individual data points?

Last post by dculp « Sun Jun 05, 2022 4:55 am
Replies: 4
by dculp » Fri Jun 03, 2022 3:39 pm

4 Replies

305 Views

Last post by dculp
Sun Jun 05, 2022 4:55 am
Converting COUNTIFS from Excel to Calc

Last post by Villeroy « Sat Jun 04, 2022 12:54 pm
Replies: 8
by thegary » Sun May 29, 2022 11:04 pm

8 Replies

444 Views

Last post by Villeroy
Sat Jun 04, 2022 12:54 pm
[Solved] Remove extra 4 digits from 9 digit ZIP code

Last post by Villeroy « Fri Jun 03, 2022 4:21 pm
Replies: 3
by stuck-stuck » Fri Jun 03, 2022 6:46 am

3 Replies

317 Views

Last post by Villeroy
Fri Jun 03, 2022 4:21 pm
[Dropped] Find and mark duplicates in array at Libre Calc?

Last post by MrProgrammer « Fri Jun 03, 2022 1:32 am
Replies: 1
by jmc777 » Thu Jun 02, 2022 7:46 pm

1 Replies

217 Views

Last post by MrProgrammer
Fri Jun 03, 2022 1:32 am
[Solved] Parse data from text file to OpenOffice

Last post by MrProgrammer « Wed Jun 01, 2022 7:01 pm
Replies: 6
by jayrues » Tue May 31, 2022 1:01 am

6 Replies

407 Views

Last post by MrProgrammer
Wed Jun 01, 2022 7:01 pm
[Solved] Do not sum hidden cells in columns

Last post by robleyd « Wed Jun 01, 2022 1:50 pm
Replies: 4
by restorwoodwindows » Tue May 31, 2022 1:32 am

4 Replies

364 Views

Last post by robleyd
Wed Jun 01, 2022 1:50 pm
[Solved] Err:502 using INDEX() function

Last post by Scarsax2018 « Sun May 29, 2022 6:22 am
Replies: 6
by Scarsax2018 » Sat May 28, 2022 1:55 pm

6 Replies

452 Views

Last post by Scarsax2018
Sun May 29, 2022 6:22 am
[Solved] Remove duplicate text between two cells

Last post by RusselB « Sun May 29, 2022 1:50 am
Replies: 4
by SaintsLair » Sat May 28, 2022 4:45 am

4 Replies

318 Views

Last post by RusselB
Sun May 29, 2022 1:50 am
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

234 Views

Last post by Villeroy
Sat May 28, 2022 11:47 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

364 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

294 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

211 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

272 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

382 Views

Last post by robbyn
Mon May 23, 2022 8:57 pm
[Solved] 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

230 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

173 Views

Last post by SCFrolich
Sun May 22, 2022 11:08 pm

New Topic

22141 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