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

Total redirects: 51119
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 53840

Total redirects: 53840
Calc Tutorials
Tutorials from this forum
Total redirects: 50601

Total redirects: 50601

New Topic

22271 topics

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

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.13 released

Last post by robleyd « Sun Jul 24, 2022 1:05 pm
Posted in Announcements

by robleyd » Sun Jul 24, 2022 1:05 pm » in Announcements

0 Replies

6269 Views

Last post by robleyd
Sun Jul 24, 2022 1:05 pm

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

77855 Views

Last post by Villeroy
Sun Jul 20, 2014 2:25 pm
Disable the prompt to update external links

Last post by Lupp « Thu Sep 29, 2022 6:42 pm
Replies: 1
by ascrw2003 » Wed Sep 28, 2022 6:40 pm

1 Replies

61 Views

Last post by Lupp
Thu Sep 29, 2022 6:42 pm
[Solved] Using 'find' crashes Calc

Last post by Hagar Delest « Thu Sep 29, 2022 1:26 pm
Replies: 10
by Rhyssa6 » Sat Sep 24, 2022 2:28 pm

10 Replies

195 Views

Last post by Hagar Delest
Thu Sep 29, 2022 1:26 pm
[Solved] Can't terminate compare feature

Last post by Joakim1970 « Wed Sep 28, 2022 6:06 pm
Replies: 3
by Joakim1970 » Sun Sep 25, 2022 6:07 pm

3 Replies

106 Views

Last post by Joakim1970
Wed Sep 28, 2022 6:06 pm
How to hide particular rows?

Last post by Mountaineer « Wed Sep 28, 2022 10:34 am
Replies: 12
by brannsiu » Sat Sep 24, 2022 6:14 pm

12 Replies

271 Views

Last post by Mountaineer
Wed Sep 28, 2022 10:34 am
Phone Number Formatting?

Last post by MrProgrammer « Mon Sep 26, 2022 9:52 pm
Replies: 1
by Jokersloose » Mon Sep 26, 2022 6:35 pm

1 Replies

107 Views

Last post by MrProgrammer
Mon Sep 26, 2022 9:52 pm
Slow response time when entering values into cells

Last post by basade42 « Mon Sep 26, 2022 8:57 pm

by basade42 » Mon Sep 26, 2022 8:57 pm

0 Replies

51 Views

Last post by basade42
Mon Sep 26, 2022 8:57 pm
[Solved] How to populate a cell with text dependant on contents of another cell?

Last post by Bones541 « Mon Sep 26, 2022 8:44 am
Replies: 4
by Bones541 » Sun Sep 25, 2022 12:27 pm

4 Replies

125 Views

Last post by Bones541
Mon Sep 26, 2022 8:44 am
[Solved] What is the syntax for the "User Defined" number format

Last post by Villeroy « Sun Sep 25, 2022 8:35 pm
Replies: 8
by CrimsonShroud » Sat Sep 24, 2022 2:35 pm

8 Replies

181 Views

Last post by Villeroy
Sun Sep 25, 2022 8:35 pm
[Solved] MM/DD/YYYY to YYYY-MM-DD format not working.

Last post by Bones541 « Sun Sep 25, 2022 9:48 am
Replies: 3
by Bones541 » Sun Sep 25, 2022 6:53 am

3 Replies

112 Views

Last post by Bones541
Sun Sep 25, 2022 9:48 am
[Solved] Change image based on a cell value

Last post by agi « Sat Sep 24, 2022 6:33 pm
Replies: 2
by agi » Fri Sep 23, 2022 7:09 pm

2 Replies

115 Views

Last post by agi
Sat Sep 24, 2022 6:33 pm
[Solved] Fixing a dropped phone in Open Office Calculator

Last post by L_Ellis « Sat Sep 24, 2022 2:00 pm
Replies: 2
by L_Ellis » Sat Sep 24, 2022 1:22 pm

2 Replies

80 Views

Last post by L_Ellis
Sat Sep 24, 2022 2:00 pm
[Solved] Importing number from website

Last post by osesteven « Thu Sep 22, 2022 5:37 pm
Replies: 2
by osesteven » Thu Sep 22, 2022 3:27 pm

2 Replies

154 Views

Last post by osesteven
Thu Sep 22, 2022 5:37 pm
[Solved] Prevent Paste from changing cell format (Text → Number)

Last post by John_Ha « Tue Sep 20, 2022 3:52 pm
Replies: 3
by Malka » Tue Sep 20, 2022 3:11 pm

3 Replies

169 Views

Last post by John_Ha
Tue Sep 20, 2022 3:52 pm
[Solved] Basic function nested cell reference gives #VALUE!

Last post by renbo « Mon Sep 19, 2022 7:47 pm
Replies: 11
by renbo » Fri Sep 16, 2022 5:44 pm

11 Replies

374 Views

Last post by renbo
Mon Sep 19, 2022 7:47 pm
[Solved] Highlight a single cell, if the value is equal to list of numbers

Last post by ishara « Mon Sep 19, 2022 6:59 pm
Replies: 2
by ishara » Mon Sep 19, 2022 3:06 pm

2 Replies

117 Views

Last post by ishara
Mon Sep 19, 2022 6:59 pm
[Solved] Highlight a single cell every 4 days

Last post by ishara « Mon Sep 19, 2022 6:56 pm
Replies: 2
by ishara » Mon Sep 19, 2022 3:12 pm

2 Replies

114 Views

Last post by ishara
Mon Sep 19, 2022 6:56 pm
[Solved] Creating filenames with formulae

Last post by MrProgrammer « Mon Sep 19, 2022 4:06 pm
Replies: 1
by Madmongoose » Mon Sep 19, 2022 1:20 pm

1 Replies

106 Views

Last post by MrProgrammer
Mon Sep 19, 2022 4:06 pm
Hundredths of hours

Last post by Villeroy « Sun Sep 18, 2022 6:47 pm
Replies: 3
by mxdog » Sat Sep 17, 2022 3:34 pm

3 Replies

201 Views

Last post by Villeroy
Sun Sep 18, 2022 6:47 pm
[Solved] Setting a randomly selected cell's background color

Last post by mconant « Sun Sep 18, 2022 12:17 am
Replies: 6
by mconant » Fri Sep 16, 2022 10:50 pm

6 Replies

233 Views

Last post by mconant
Sun Sep 18, 2022 12:17 am
[Dropped] Formula stops working for months 10 thru 12

Last post by karolus « Thu Sep 15, 2022 7:16 pm
Replies: 2
by jstack » Thu Sep 15, 2022 2:05 pm

2 Replies

185 Views

Last post by karolus
Thu Sep 15, 2022 7:16 pm
[Solved] Set default language for spell check

Last post by Villeroy « Thu Sep 15, 2022 11:44 am
Replies: 7
by Nocton » Wed Sep 14, 2022 3:51 pm

7 Replies

247 Views

Last post by Villeroy
Thu Sep 15, 2022 11:44 am
[Solved] Quickly test if there is any data entry in a spreadsheet

Last post by brannsiu « Tue Sep 13, 2022 7:07 am
Replies: 6
by brannsiu » Mon Sep 05, 2022 11:13 am

6 Replies

336 Views

Last post by brannsiu
Tue Sep 13, 2022 7:07 am
Transforming telephone numbers in Calc

Last post by Lupp « Mon Sep 12, 2022 10:35 pm
Replies: 1
by LeSellers » Mon Sep 12, 2022 9:57 pm

1 Replies

134 Views

Last post by Lupp
Mon Sep 12, 2022 10:35 pm
[Solved] When I type 10-02 into a cell it looks like this: ####

Last post by mitkroy « Sun Sep 11, 2022 8:04 pm
Replies: 5
by mitkroy » Sun Sep 11, 2022 7:07 pm

5 Replies

188 Views

Last post by mitkroy
Sun Sep 11, 2022 8:04 pm
[Solved] Multiple Find and Replace Based On List of Values

Last post by FJCC « Fri Sep 09, 2022 1:33 am
Replies: 3
by kevin_itgz » Thu Sep 08, 2022 10:36 pm

3 Replies

185 Views

Last post by FJCC
Fri Sep 09, 2022 1:33 am
[Solved] Copy same cell from each sheet to summary column

Last post by Zizi64 « Thu Sep 08, 2022 2:12 pm
Replies: 7
by Philfy » Wed Sep 07, 2022 10:16 pm

7 Replies

258 Views

Last post by Zizi64
Thu Sep 08, 2022 2:12 pm
[Dropped] Total time elapsed, excluding gaps

Last post by Villeroy « Tue Sep 06, 2022 3:31 pm
Replies: 5
by JoePoult » Mon Sep 05, 2022 7:35 pm

5 Replies

247 Views

Last post by Villeroy
Tue Sep 06, 2022 3:31 pm
[Solved] 1.73 interpreted as date in Turkish locale

Last post by UnklDonald418 « Tue Sep 06, 2022 1:54 am
Replies: 3
by mtnylmz » Mon Sep 05, 2022 10:10 pm

3 Replies

207 Views

Last post by UnklDonald418
Tue Sep 06, 2022 1:54 am
[Solved] Insert character from Kanchan font

Last post by Bill « Sun Sep 04, 2022 10:15 pm
Replies: 3
by a928 » Sun Sep 04, 2022 4:21 pm

3 Replies

201 Views

Last post by Bill
Sun Sep 04, 2022 10:15 pm
[Solved] Add actions for command buttons

Last post by Zizi64 « Sun Sep 04, 2022 1:53 pm
Replies: 1
by Martin199 » Sun Sep 04, 2022 12:33 pm

1 Replies

127 Views

Last post by Zizi64
Sun Sep 04, 2022 1:53 pm
[Solved] Sort using column letters instead of column labels

Last post by mtnylmz « Sun Sep 04, 2022 3:44 am
Replies: 2
by mtnylmz » Sat Sep 03, 2022 8:45 pm

2 Replies

214 Views

Last post by mtnylmz
Sun Sep 04, 2022 3:44 am
[Solved] Some protection settings lost on re-open

Last post by RoryOF « Sat Sep 03, 2022 11:23 am
Replies: 3
by csang » Fri Sep 02, 2022 10:42 am

3 Replies

149 Views

Last post by RoryOF
Sat Sep 03, 2022 11:23 am
[Issue] Permanently disable the status bar

Last post by Villeroy « Fri Sep 02, 2022 11:15 am
Replies: 6
by kennedypiano » Wed Aug 31, 2022 11:14 pm

6 Replies

277 Views

Last post by Villeroy
Fri Sep 02, 2022 11:15 am
[Solved] Set value X in column if another column contains Y

Last post by MrProgrammer « Thu Sep 01, 2022 4:56 pm
Replies: 5
by progtesting » Wed Aug 31, 2022 2:04 pm

5 Replies

276 Views

Last post by MrProgrammer
Thu Sep 01, 2022 4:56 pm
[Solved] Keep conditional formatting when pasting data in column

Last post by amb005 « Thu Sep 01, 2022 1:24 pm
Replies: 2
by amb005 » Wed Aug 24, 2022 3:21 pm

2 Replies

174 Views

Last post by amb005
Thu Sep 01, 2022 1:24 pm
[Solved] Add condition on column B

Last post by Cat101 « Thu Sep 01, 2022 1:17 am
Replies: 2
by Cat101 » Mon Aug 15, 2022 10:22 pm

2 Replies

178 Views

Last post by Cat101
Thu Sep 01, 2022 1:17 am
[Solved] VLOOKUP search array increments when copying formula

Last post by Hagar Delest « Wed Aug 31, 2022 8:22 am
Replies: 1
by Urbanfarmervb » Wed Aug 31, 2022 7:54 am

1 Replies

126 Views

Last post by Hagar Delest
Wed Aug 31, 2022 8:22 am
[Solved] Format doesn't show negative numbers in red

Last post by garryll77 « Tue Aug 30, 2022 11:44 pm
Replies: 5
by garryll77 » Tue Aug 30, 2022 1:03 am

5 Replies

205 Views

Last post by garryll77
Tue Aug 30, 2022 11:44 pm
Random Bold appearing when editing cells

Last post by Lupp « Tue Aug 30, 2022 8:48 pm
Replies: 4
by Simon B » Sun Aug 28, 2022 4:26 pm

4 Replies

237 Views

Last post by Lupp
Tue Aug 30, 2022 8:48 pm
[Solved] Disable automatic capitalization change

Last post by MrProgrammer « Tue Aug 30, 2022 4:15 pm
Replies: 3
by brannsiu » Tue Aug 16, 2022 2:26 am

3 Replies

221 Views

Last post by MrProgrammer
Tue Aug 30, 2022 4:15 pm
[Dropped] Calc uses 99% of CPU, lags it and all programs??

Last post by John_Ha « Tue Aug 30, 2022 10:51 am
Replies: 8
by axelrose » Sun Aug 28, 2022 10:48 am

8 Replies

261 Views

Last post by John_Ha
Tue Aug 30, 2022 10:51 am
[Solved] Shortcut for coming to the at the end of a file?

Last post by robleyd « Tue Aug 30, 2022 1:36 am
Replies: 4
by mtnylmz » Mon Aug 29, 2022 6:17 pm

4 Replies

209 Views

Last post by robleyd
Tue Aug 30, 2022 1:36 am
[Solved] Sort with more than 3 columns as criteria

Last post by Zizi64 « Sun Aug 28, 2022 5:15 pm
Replies: 6
by mtnylmz » Sun Aug 28, 2022 11:05 am

6 Replies

264 Views

Last post by Zizi64
Sun Aug 28, 2022 5:15 pm
[Dropped] Why does OpenOffice use 99% of CPU and slow my computer?

Last post by axelrose « Sun Aug 28, 2022 10:36 am
Replies: 5
by axelrose » Sat Jun 11, 2022 2:34 pm

5 Replies

433 Views

Last post by axelrose
Sun Aug 28, 2022 10:36 am
[Solved] Is there a way to secure a CALC file from changes

Last post by koden « Sun Aug 28, 2022 9:15 am
Replies: 2
by koden » Sun Aug 28, 2022 12:26 am

2 Replies

151 Views

Last post by koden
Sun Aug 28, 2022 9:15 am
[Dropped] Calc charts not updating with new data

Last post by Lupp « Sat Aug 27, 2022 10:40 am
Replies: 8
by ra-loffice » Mon Apr 25, 2022 4:04 pm

8 Replies

1119 Views

Last post by Lupp
Sat Aug 27, 2022 10:40 am
[Dropped] Not printing all cells

Last post by Zizi64 « Fri Aug 26, 2022 6:33 am
Replies: 1
by gm7272 » Fri Aug 26, 2022 1:24 am

1 Replies

101 Views

Last post by Zizi64
Fri Aug 26, 2022 6:33 am
[Solved] Each unique value in column to be listed with no duplicate?

Last post by amb005 « Fri Aug 26, 2022 1:55 am
Replies: 12
by amb005 » Thu Aug 25, 2022 4:59 am

12 Replies

417 Views

Last post by amb005
Fri Aug 26, 2022 1:55 am
[Solved] Formula to identify if a date is 2nd or 4th Thursday

Last post by Lupp « Thu Aug 25, 2022 11:37 pm
Replies: 4
by jstack » Thu Aug 25, 2022 2:16 pm

4 Replies

228 Views

Last post by Lupp
Thu Aug 25, 2022 11:37 pm

New Topic

22271 topics

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