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

Total redirects: 49795
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 52292

Total redirects: 52292
Calc Tutorials
Tutorials from this forum
Total redirects: 49226

Total redirects: 49226

New Topic

22142 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

5982 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

76558 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
[Solved] Weekly Sum Of Trade Results Without A Trade Every Day?

Last post by Hagar Delest « Tue Jun 28, 2022 8:54 am
Replies: 9
by CapCrockett » Fri Jun 24, 2022 11:58 pm

9 Replies

204 Views

Last post by Hagar Delest
Tue Jun 28, 2022 8:54 am
Calc not working since upgrade

Last post by John_Ha « Mon Jun 27, 2022 11:10 am
Replies: 2
by WolvercoteJohn » Sun Jun 26, 2022 10:32 pm

2 Replies

87 Views

Last post by John_Ha
Mon Jun 27, 2022 11:10 am
The operation Search indicates only the cell

Last post by Hagar Delest « Sun Jun 26, 2022 6:02 pm
Replies: 8
by AKle » Sat Jun 25, 2022 1:25 pm

8 Replies

171 Views

Last post by Hagar Delest
Sun Jun 26, 2022 6:02 pm
Adding up the times

Last post by MrProgrammer « Sun Jun 26, 2022 4:57 pm
Replies: 10
by Bernadine » Mon Jun 20, 2022 3:01 am

10 Replies

268 Views

Last post by MrProgrammer
Sun Jun 26, 2022 4:57 pm
[Solved] Set cell colors based on dropdown selection

Last post by Noobian « Sun Jun 26, 2022 3:29 pm
Replies: 39
by Noobian » Mon Jun 20, 2022 8:03 pm
1

2
39 Replies

961 Views

Last post by Noobian
Sun Jun 26, 2022 3:29 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

73 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

286 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

109 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

106 Views

Last post by robleyd
Thu Jun 23, 2022 1:28 pm
[Solved] Determine which 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

182 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

124 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

237 Views

Last post by Cobbles_Classics
Sun Jun 19, 2022 4:46 pm
[Solved] Need to keep business 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

171 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: 17
by Redskunk » Thu Jun 16, 2022 4:49 am

17 Replies

682 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: 5
by Sat » Tue Jun 07, 2022 5:38 am

5 Replies

434 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

329 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

248 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

412 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

397 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

294 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

444 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

211 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

266 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

232 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

294 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

245 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

197 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

337 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

199 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

4385 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

239 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

312 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

448 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

366 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

319 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

238 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

296 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

212 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

273 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

383 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

234 Views

Last post by John_Ha
Mon May 23, 2022 4:18 pm

New Topic

22142 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