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

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

Total redirects: 929722
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 937611

Total redirects: 937611
Calc Tutorials
Tutorials from this forum
Total redirects: 922253

Total redirects: 922253

New Topic

23360 topics

Page 23 of 468
- Jump to page:
Previous
1
…
21
22
23
24
25
…
468
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

227712 Views

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

Topics

Replies

Views

Last post

[Solved] Highlighting numbers (single value)

Last post by mikrodoctor « Tue Nov 29, 2022 4:58 am
Replies: 2
by mikrodoctor » Mon Nov 28, 2022 3:32 pm

2 Replies

912 Views

Last post by mikrodoctor
Tue Nov 29, 2022 4:58 am
[Solved] Reduce prices when increasing quantity

Last post by MrProgrammer « Mon Nov 28, 2022 8:56 pm
Replies: 6
by robbc » Sun Nov 27, 2022 4:12 pm

6 Replies

1394 Views

Last post by MrProgrammer
Mon Nov 28, 2022 8:56 pm
[Solved] Clickable jpg in Calc that opens full size

Last post by Hagar Delest « Sat Nov 26, 2022 12:24 pm
Replies: 11
by Petibonix » Thu Nov 24, 2022 6:37 pm

11 Replies

1487 Views

Last post by Hagar Delest
Sat Nov 26, 2022 12:24 pm
[Solved] #VALUE error in sub-total and total when text is entered

Last post by pkan « Fri Nov 25, 2022 8:15 pm
Replies: 11
by pkan » Fri Nov 25, 2022 11:05 am

11 Replies

1730 Views

Last post by pkan
Fri Nov 25, 2022 8:15 pm
[Solved] Nested IF function fails: IF(I3<90,I3>85;"B1";IF(…))

Last post by John_Ha « Fri Nov 25, 2022 6:32 pm
Replies: 2
by TGFxMUIGOKU » Fri Nov 25, 2022 4:28 pm

2 Replies

713 Views

Last post by John_Ha
Fri Nov 25, 2022 6:32 pm
[Solved] Basic function nested cell reference gives #VALUE!

Last post by pkan « Fri Nov 25, 2022 10:51 am
Replies: 12
by renbo » Fri Sep 16, 2022 5:44 pm

12 Replies

1946 Views

Last post by pkan
Fri Nov 25, 2022 10:51 am
Formula to Import Earnings Date

Last post by Villeroy « Thu Nov 24, 2022 9:34 pm
Replies: 5
by crusader » Wed Nov 23, 2022 10:51 pm

5 Replies

2020 Views

Last post by Villeroy
Thu Nov 24, 2022 9:34 pm
[Solved] Compare cells having continuously changing values (a text, number)

Last post by Binu « Wed Nov 23, 2022 7:41 pm
Replies: 7
by Binu » Wed Nov 23, 2022 5:40 pm

7 Replies

1254 Views

Last post by Binu
Wed Nov 23, 2022 7:41 pm
[Solved] Disable AutoInput for specific columns

Last post by barbzh « Tue Nov 22, 2022 2:35 am
Replies: 10
by barbzh » Sat Nov 19, 2022 2:24 am

10 Replies

1468 Views

Last post by barbzh
Tue Nov 22, 2022 2:35 am
[Solved] CSV import corrupted

Last post by Bird on the Hand « Mon Nov 21, 2022 2:09 pm
Replies: 3
by Bird on the Hand » Mon Nov 21, 2022 11:18 am

3 Replies

901 Views

Last post by Bird on the Hand
Mon Nov 21, 2022 2:09 pm
[Solved] Count number occurrences in a list

Last post by Villeroy « Mon Nov 21, 2022 11:26 am
Replies: 6
by jmn » Sun Nov 20, 2022 7:46 am

6 Replies

2817 Views

Last post by Villeroy
Mon Nov 21, 2022 11:26 am
[Solved] Remove apostrophes from CSV import

Last post by axelrose « Sun Nov 20, 2022 6:56 am
Replies: 5
by axelrose » Sat Nov 19, 2022 3:59 am

5 Replies

1953 Views

Last post by axelrose
Sun Nov 20, 2022 6:56 am
Calc uses 99% of CPU, lags it and all programs??

Last post by Zizi64 « Sat Nov 19, 2022 10:08 am
Replies: 12
by axelrose » Sun Aug 28, 2022 10:48 am

12 Replies

2030 Views

Last post by Zizi64
Sat Nov 19, 2022 10:08 am
[Solved] After hiding a row, not being able to show it up again

Last post by robleyd « Sat Nov 19, 2022 6:01 am
Replies: 1
by brannsiu » Sat Nov 19, 2022 5:50 am

1 Replies

529 Views

Last post by robleyd
Sat Nov 19, 2022 6:01 am
[Solved] Copy cell value from a spreadsheet into another

Last post by MrProgrammer « Fri Nov 18, 2022 6:12 pm
Replies: 29
by Ulin » Wed Nov 16, 2022 6:54 am

29 Replies

4960 Views

Last post by MrProgrammer
Fri Nov 18, 2022 6:12 pm
[Solved] Search for name match in another file

Last post by MrProgrammer « Fri Nov 18, 2022 4:50 pm
Replies: 2
by dentopolis » Fri Nov 18, 2022 1:46 pm

2 Replies

685 Views

Last post by MrProgrammer
Fri Nov 18, 2022 4:50 pm
[Solved] TEXT function to create date

Last post by Lupp « Thu Nov 17, 2022 1:07 pm
Replies: 5
by Nocton » Tue Nov 15, 2022 5:14 pm

5 Replies

1435 Views

Last post by Lupp
Thu Nov 17, 2022 1:07 pm
[Solved] Hyperlink works but greyed out

Last post by chvs911 « Wed Nov 16, 2022 3:13 pm
Replies: 4
by chvs911 » Wed Nov 16, 2022 2:18 pm

4 Replies

901 Views

Last post by chvs911
Wed Nov 16, 2022 3:13 pm
[Solved] Remove extra 4 digits from 9 digit ZIP code

Last post by karolus « Tue Nov 15, 2022 8:17 pm
Replies: 5
by stuck-stuck » Fri Jun 03, 2022 6:46 am

5 Replies

3480 Views

Last post by karolus
Tue Nov 15, 2022 8:17 pm
[Solved] Insert Cut Rows/Columns and preserve cell references

Last post by Villeroy « Tue Nov 15, 2022 7:21 pm
Replies: 4
by mylescdavis » Tue Nov 15, 2022 1:20 pm

4 Replies

1462 Views

Last post by Villeroy
Tue Nov 15, 2022 7:21 pm
[Solved] Get the value of Col:B if its Col:A value is consistent

Last post by MrProgrammer « Tue Nov 15, 2022 4:17 pm
Replies: 6
by raykt » Mon Oct 31, 2022 1:30 pm

6 Replies

1056 Views

Last post by MrProgrammer
Tue Nov 15, 2022 4:17 pm
[Solved] Avoid #DIV/0! in calculations

Last post by bilgri « Mon Nov 14, 2022 10:59 pm
Replies: 18
by bilgri » Fri Nov 11, 2022 5:18 pm

18 Replies

3087 Views

Last post by bilgri
Mon Nov 14, 2022 10:59 pm
What is the fastest way to make this operation?

Last post by Villeroy « Mon Nov 14, 2022 10:16 pm
Replies: 5
by Thefilozof32 » Sun Nov 13, 2022 7:27 pm

5 Replies

861 Views

Last post by Villeroy
Mon Nov 14, 2022 10:16 pm
[Solved] I've set links in error but can't find them

Last post by Philfy « Mon Nov 14, 2022 9:25 pm
Replies: 2
by Philfy » Mon Nov 14, 2022 7:30 pm

2 Replies

452 Views

Last post by Philfy
Mon Nov 14, 2022 9:25 pm
[Solved] Cross referencing from MAX result

Last post by Blondie88 « Sun Nov 13, 2022 1:25 pm
Replies: 2
by Blondie88 » Sat Nov 12, 2022 7:35 pm

2 Replies

432 Views

Last post by Blondie88
Sun Nov 13, 2022 1:25 pm
[Solved] Text alignment within drawn shapes

Last post by icd99 « Sat Nov 12, 2022 9:28 pm
Replies: 2
by icd99 » Sat Nov 12, 2022 2:18 pm

2 Replies

588 Views

Last post by icd99
Sat Nov 12, 2022 9:28 pm
[Solved] Paste contents to every 3rd cell?

Last post by John_Ha « Fri Nov 11, 2022 7:52 pm
Replies: 3
by sainty88 » Fri Nov 11, 2022 3:10 pm

3 Replies

716 Views

Last post by John_Ha
Fri Nov 11, 2022 7:52 pm
[Solved] Copy if less than

Last post by karolus « Fri Nov 11, 2022 1:28 am
Replies: 1
by quarkrad » Fri Nov 11, 2022 12:13 am

1 Replies

522 Views

Last post by karolus
Fri Nov 11, 2022 1:28 am
[Solved] Unable to insert sheet

Last post by Zizi64 « Thu Nov 10, 2022 7:06 pm
Replies: 7
by 23191713 » Thu Nov 10, 2022 4:35 pm

7 Replies

2598 Views

Last post by Zizi64
Thu Nov 10, 2022 7:06 pm
[Solved] Get 2nd smallest distinct value in list

Last post by MrProgrammer « Thu Nov 10, 2022 4:05 pm
Replies: 1
by goku90504 » Thu Nov 10, 2022 3:04 pm

1 Replies

1195 Views

Last post by MrProgrammer
Thu Nov 10, 2022 4:05 pm
[Solved] Autocorrect text to use bold font

Last post by MrProgrammer « Wed Nov 09, 2022 8:13 pm
Replies: 8
by Philfy » Fri Nov 04, 2022 12:24 pm

8 Replies

1703 Views

Last post by MrProgrammer
Wed Nov 09, 2022 8:13 pm
[Solved] Find specific text in string and return text (or not)

Last post by Kube1989 « Wed Nov 09, 2022 2:13 pm
Replies: 5
by Kube1989 » Tue Nov 08, 2022 5:39 pm

5 Replies

1666 Views

Last post by Kube1989
Wed Nov 09, 2022 2:13 pm
[Solved] Converting Time into Time range

Last post by Lupp « Tue Nov 08, 2022 11:26 pm
Replies: 7
by Binu » Tue Nov 08, 2022 5:00 pm

7 Replies

906 Views

Last post by Lupp
Tue Nov 08, 2022 11:26 pm
[Solved] Average of last 10 entries skipping blank cells

Last post by Mavans « Tue Nov 08, 2022 5:10 pm
Replies: 5
by Mavans » Wed Nov 02, 2022 3:13 pm

5 Replies

1190 Views

Last post by Mavans
Tue Nov 08, 2022 5:10 pm
Calc crashes on copy/paste

Last post by John_Ha « Mon Nov 07, 2022 9:43 pm
Replies: 5
by Bob Brines » Thu Nov 03, 2022 10:46 pm

5 Replies

5219 Views

Last post by John_Ha
Mon Nov 07, 2022 9:43 pm
[Dropped] Is OpenOffice so slow?

Last post by John_Ha « Fri Nov 04, 2022 6:23 pm
Replies: 2
by luofeiyu » Fri Nov 04, 2022 4:05 pm

2 Replies

753 Views

Last post by John_Ha
Fri Nov 04, 2022 6:23 pm
[Solved] Is it possible to make the cross-line bolder?

Last post by Bill « Fri Nov 04, 2022 4:57 pm
Replies: 7
by brannsiu » Fri Nov 04, 2022 11:46 am

7 Replies

1314 Views

Last post by Bill
Fri Nov 04, 2022 4:57 pm
[Solved] Macro that does what Ctrl-Z does?

Last post by Zizi64 « Fri Nov 04, 2022 9:16 am
Replies: 10
by joe.dokes » Tue Nov 01, 2022 3:39 am

10 Replies

2151 Views

Last post by Zizi64
Fri Nov 04, 2022 9:16 am
[Solved] Compare 2 data sets (columns,text), and display list of exact matches

Last post by researchbear22 « Thu Nov 03, 2022 7:55 pm
Replies: 4
by researchbear22 » Wed Nov 02, 2022 9:51 pm

4 Replies

823 Views

Last post by researchbear22
Thu Nov 03, 2022 7:55 pm
[Solved] Calc how to restart from the begining

Last post by Osmario « Thu Nov 03, 2022 6:42 pm
Replies: 8
by Osmario » Thu Nov 03, 2022 3:03 am

8 Replies

1125 Views

Last post by Osmario
Thu Nov 03, 2022 6:42 pm
[Solved] White ? in Black Diamond

Last post by Zizi64 « Thu Nov 03, 2022 1:21 pm
Replies: 2
by Philfy » Thu Nov 03, 2022 12:30 pm

2 Replies

680 Views

Last post by Zizi64
Thu Nov 03, 2022 1:21 pm
[Solved] Feature to search for dates

Last post by Zizi64 « Thu Nov 03, 2022 7:27 am
Replies: 4
by dodoopen » Wed Nov 02, 2022 11:50 pm

4 Replies

1408 Views

Last post by Zizi64
Thu Nov 03, 2022 7:27 am
Alert in response to value in cell

Last post by Zizi64 « Wed Nov 02, 2022 10:47 pm
Replies: 13
by istephen » Tue Nov 01, 2022 5:09 am

13 Replies

1812 Views

Last post by Zizi64
Wed Nov 02, 2022 10:47 pm
[Solved] Ideas for formatting a table with multiple headers

Last post by ListingAndy « Wed Nov 02, 2022 8:23 pm
Replies: 17
by ListingAndy » Tue Nov 01, 2022 5:13 pm

17 Replies

2682 Views

Last post by ListingAndy
Wed Nov 02, 2022 8:23 pm
[Solved] Cell displaying ### or 44676 when content is edited

Last post by Villeroy « Tue Nov 01, 2022 9:13 pm
Replies: 3
by Redbudtree » Tue Nov 01, 2022 4:34 pm

3 Replies

766 Views

Last post by Villeroy
Tue Nov 01, 2022 9:13 pm
[Solved] Row limitation in OpenOffice

Last post by Zizi64 « Tue Nov 01, 2022 4:03 pm
Replies: 2
by luofeiyu » Tue Nov 01, 2022 12:30 pm

2 Replies

1219 Views

Last post by Zizi64
Tue Nov 01, 2022 4:03 pm
[Solved] Why the base date is 1899-12-30 instead of 1899-12-31?

Last post by Villeroy « Tue Nov 01, 2022 3:47 pm
Replies: 3
by luofeiyu » Tue Nov 01, 2022 1:35 pm

3 Replies

10569 Views

Last post by Villeroy
Tue Nov 01, 2022 3:47 pm
[Solved] Convert NOW() into UNIX timestamp

Last post by karolus « Tue Nov 01, 2022 11:51 am
Replies: 3
by luofeiyu » Tue Nov 01, 2022 9:56 am

3 Replies

1708 Views

Last post by karolus
Tue Nov 01, 2022 11:51 am
[Solved] Why no output for CURDATE function in OpenOffice?

Last post by Zizi64 « Tue Nov 01, 2022 10:56 am
Replies: 1
by luofeiyu » Tue Nov 01, 2022 10:02 am

1 Replies

551 Views

Last post by Zizi64
Tue Nov 01, 2022 10:56 am
[Solved] Determine the year's quarter for a date

Last post by Bpgasguy « Tue Nov 01, 2022 1:43 am
Replies: 4
by Bpgasguy » Mon Oct 31, 2022 10:31 pm

4 Replies

1036 Views

Last post by Bpgasguy
Tue Nov 01, 2022 1:43 am

New Topic

23360 topics

Page 23 of 468
- Jump to page:
Previous
1
…
21
22
23
24
25
…
468
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