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

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

Total redirects: 775676
Calc Functions
Extended Help on the Calc functions - HTML
Total redirects: 784575

Total redirects: 784575
Calc Tutorials
Tutorials from this forum
Total redirects: 771723

Total redirects: 771723

New Topic

23347 topics

Page 8 of 467
- Jump to page:
Previous
1
…
6
7
8
9
10
…
467
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

136095 Views

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

Topics

Replies

Views

Last post

Import data from Google calendar to edit an invoice

Last post by dekart « Thu Aug 15, 2024 3:20 am
Replies: 6
by dekart » Mon Aug 05, 2024 4:28 am

6 Replies

2785 Views

Last post by dekart
Thu Aug 15, 2024 3:20 am
[Solved] Highlight entire rows of weekend days

Last post by taylorr113y93 « Sun Aug 11, 2024 5:31 pm
Replies: 3
by taylorr113y93 » Sun Aug 11, 2024 4:48 pm

3 Replies

1956 Views

Last post by taylorr113y93
Sun Aug 11, 2024 5:31 pm
[Solved] Complex XSLT filter

Last post by mikekaganski « Sat Aug 10, 2024 12:20 pm
Replies: 11
by AP Jager » Sat Nov 08, 2008 6:35 pm

11 Replies

21525 Views

Last post by mikekaganski
Sat Aug 10, 2024 12:20 pm
[Solved] Return text unless value is positive

Last post by MrProgrammer « Fri Aug 09, 2024 11:38 pm
Replies: 12
by Griff » Thu Aug 08, 2024 6:53 pm

12 Replies

3636 Views

Last post by MrProgrammer
Fri Aug 09, 2024 11:38 pm
[Dropped] Return three integers from two arguments

Last post by Lupp « Fri Aug 09, 2024 7:53 pm
Replies: 2
by DWDun » Fri Aug 09, 2024 12:07 am

2 Replies

1872 Views

Last post by Lupp
Fri Aug 09, 2024 7:53 pm
[Solved] Disable auto capital letters

Last post by Alex1 « Wed Aug 07, 2024 10:40 pm
Replies: 3
by fbax » Thu Mar 24, 2022 5:21 pm

3 Replies

3626 Views

Last post by Alex1
Wed Aug 07, 2024 10:40 pm
[Solved] Calc crashes on copy/paste

Last post by RoryOF « Sat Aug 03, 2024 10:35 pm
Replies: 31
by N1MM » Thu Dec 01, 2022 8:25 pm
1

2
31 Replies

10413 Views

Last post by RoryOF
Sat Aug 03, 2024 10:35 pm
[Solved] Optimization of time for song set list

Last post by Alex1 « Sat Aug 03, 2024 4:35 pm
Replies: 5
by zooropa » Fri Aug 02, 2024 1:43 pm

5 Replies

2505 Views

Last post by Alex1
Sat Aug 03, 2024 4:35 pm
[Solved] Help in filtering and sorting

Last post by pgcranie « Fri Aug 02, 2024 3:06 pm
Replies: 4
by pgcranie » Thu Aug 01, 2024 8:23 pm

4 Replies

2355 Views

Last post by pgcranie
Fri Aug 02, 2024 3:06 pm
[Solved] AOO won't open password-protected files

Last post by HowardJ « Fri Aug 02, 2024 2:26 pm
Replies: 3
by HowardJ » Thu Aug 01, 2024 9:00 pm

3 Replies

2028 Views

Last post by HowardJ
Fri Aug 02, 2024 2:26 pm
[Solved] Interspacing a column with blank rows

Last post by kenppy « Thu Aug 01, 2024 7:27 pm
Replies: 5
by kenppy » Thu Aug 01, 2024 12:03 pm

5 Replies

2129 Views

Last post by kenppy
Thu Aug 01, 2024 7:27 pm
[Solved] Nested AND function within IF function

Last post by MrProgrammer « Thu Aug 01, 2024 4:37 pm
Replies: 2
by AndrewScottMusic » Thu Aug 01, 2024 9:16 am

2 Replies

1745 Views

Last post by MrProgrammer
Thu Aug 01, 2024 4:37 pm
[Solved] SUMIF Sequence of Character check

Last post by Alex1 « Wed Jul 31, 2024 1:03 am
Replies: 6
by SamIfTrue » Mon Feb 01, 2021 8:30 pm

6 Replies

3212 Views

Last post by Alex1
Wed Jul 31, 2024 1:03 am
[Dropped] Pull data from drop down menu

Last post by MrProgrammer « Fri Jul 26, 2024 6:05 pm
Replies: 3
by twodogies » Thu Jul 25, 2024 7:08 am

3 Replies

2119 Views

Last post by MrProgrammer
Fri Jul 26, 2024 6:05 pm
Financial data template

Last post by taylorr113y93 « Fri Jul 26, 2024 5:05 pm
Replies: 4
by taylorr113y93 » Thu Jul 25, 2024 7:50 pm

4 Replies

2176 Views

Last post by taylorr113y93
Fri Jul 26, 2024 5:05 pm
Change all background color X to color Y

Last post by Hagar Delest « Fri Jul 26, 2024 7:34 am
Replies: 15
by swampwiz » Sun Jun 09, 2024 1:25 pm

15 Replies

6653 Views

Last post by Hagar Delest
Fri Jul 26, 2024 7:34 am
[Solved] Want to use something like SUMIF

Last post by swampwiz « Fri Jul 26, 2024 4:39 am
Replies: 2
by swampwiz » Thu Jul 25, 2024 4:55 pm

2 Replies

2106 Views

Last post by swampwiz
Fri Jul 26, 2024 4:39 am
[Solved] Highlight row for dates in "Holidays" sheet

Last post by taylorr113y93 « Thu Jul 25, 2024 3:45 pm
Replies: 4
by taylorr113y93 » Thu Jul 25, 2024 11:04 am

4 Replies

2070 Views

Last post by taylorr113y93
Thu Jul 25, 2024 3:45 pm
[Solved] COUNTIF does not differentiate upper/lower case

Last post by Geoff T « Thu Jul 25, 2024 5:23 am
Replies: 5
by Geoff T » Mon Jul 22, 2024 4:11 pm

5 Replies

2387 Views

Last post by Geoff T
Thu Jul 25, 2024 5:23 am
[Solved] Import web page table into spreadsheet

Last post by Marscaleb « Thu Jul 25, 2024 3:03 am
Replies: 4
by Marscaleb » Wed Jul 24, 2024 5:53 am

4 Replies

2333 Views

Last post by Marscaleb
Thu Jul 25, 2024 3:03 am
[Solved] Automatically fill Year column

Last post by robleyd « Wed Jul 24, 2024 5:27 am
Replies: 5
by Marscaleb » Mon Jul 22, 2024 7:12 am

5 Replies

2502 Views

Last post by robleyd
Wed Jul 24, 2024 5:27 am
[Solved] Behavior of formulas when moving rows

Last post by MrProgrammer « Tue Jul 23, 2024 2:44 am
Replies: 15
by lanyi » Wed Jul 17, 2024 8:15 pm

15 Replies

3822 Views

Last post by MrProgrammer
Tue Jul 23, 2024 2:44 am
[Solved] Determine balance after deposits and payments

Last post by FJCC « Fri Jul 19, 2024 2:38 pm
Replies: 1
by Bigmack1866 » Fri Jul 19, 2024 1:21 pm

1 Replies

1763 Views

Last post by FJCC
Fri Jul 19, 2024 2:38 pm
[Solved] Import Google Sheets spreadsheet

Last post by Mick Berg « Fri Jul 19, 2024 7:16 am
Replies: 2
by Mick Berg » Fri Jul 19, 2024 5:43 am

2 Replies

2528 Views

Last post by Mick Berg
Fri Jul 19, 2024 7:16 am
[Solved+Issue] Unwanted prompt to update links

Last post by Hagar Delest « Tue Jul 16, 2024 5:57 pm
Replies: 15
by tom9940 » Thu Nov 02, 2017 4:55 pm

15 Replies

9183 Views

Last post by Hagar Delest
Tue Jul 16, 2024 5:57 pm
[Solved] Weekly vs quarterly data in Line chart

Last post by legalnan « Mon Jul 15, 2024 6:10 pm
Replies: 4
by legalnan » Mon Jul 15, 2024 4:50 am

4 Replies

2309 Views

Last post by legalnan
Mon Jul 15, 2024 6:10 pm
[Solved] Unwanted printing on chart

Last post by MrProgrammer « Mon Jul 15, 2024 6:00 am
Replies: 1
by legalnan » Mon Jul 15, 2024 5:06 am

1 Replies

2159 Views

Last post by MrProgrammer
Mon Jul 15, 2024 6:00 am
[Solved] #NAME? error when using column label

Last post by prabharathi « Sun Jul 14, 2024 7:36 am
Replies: 7
by prabharathi » Fri Jul 12, 2024 2:19 pm

7 Replies

2932 Views

Last post by prabharathi
Sun Jul 14, 2024 7:36 am
[Solved] Determine the larger of two products

Last post by Alex1 « Sat Jul 13, 2024 9:51 pm
Replies: 2
by Kevyn53 » Fri Jul 12, 2024 11:45 pm

2 Replies

2048 Views

Last post by Alex1
Sat Jul 13, 2024 9:51 pm
[Solved] Possible use of VLOOKUP

Last post by kenppy « Sat Jul 13, 2024 11:30 am
Replies: 13
by kenppy » Fri Jul 12, 2024 5:15 pm

13 Replies

3749 Views

Last post by kenppy
Sat Jul 13, 2024 11:30 am
[Solved] Maintain historically largest cell value

Last post by Mountaineer « Thu Jul 11, 2024 9:31 am
Replies: 2
by thebigo » Wed Jul 10, 2024 8:30 pm

2 Replies

2371 Views

Last post by Mountaineer
Thu Jul 11, 2024 9:31 am
[Solved] Rearrange alphabetically column and rows

Last post by Alex1 « Mon Jul 08, 2024 10:26 am
Replies: 5
by TheOldThug » Sun Jul 07, 2024 6:43 pm

5 Replies

3675 Views

Last post by Alex1
Mon Jul 08, 2024 10:26 am
[Solved] Keyboard shortcut for array formula entry

Last post by Hickery Doc « Sun Jul 07, 2024 2:02 pm
Replies: 2
by Hickery Doc » Sun Jul 07, 2024 12:13 pm

2 Replies

2487 Views

Last post by Hickery Doc
Sun Jul 07, 2024 2:02 pm
[Solved] Calc concatenates numbers but not text

Last post by MrProgrammer « Fri Jul 05, 2024 2:23 am
Replies: 8
by BTFT66 » Wed Jul 03, 2024 6:51 pm

8 Replies

3652 Views

Last post by MrProgrammer
Fri Jul 05, 2024 2:23 am
[Solved] Get date for event in next column

Last post by okjhum « Thu Jul 04, 2024 5:52 pm
Replies: 7
by okjhum » Sat Jun 29, 2024 12:14 pm

7 Replies

3720 Views

Last post by okjhum
Thu Jul 04, 2024 5:52 pm
[Solved] Show text outside of cell boundaries

Last post by FJCC « Wed Jul 03, 2024 8:40 pm
Replies: 1
by herbyguitar » Wed Jul 03, 2024 7:56 pm

1 Replies

2362 Views

Last post by FJCC
Wed Jul 03, 2024 8:40 pm
[Solved] Copy right, but increment row references down

Last post by LeroyTennison « Wed Jul 03, 2024 1:58 am
Replies: 5
by LeroyTennison » Sun Jun 30, 2024 1:58 am

5 Replies

3373 Views

Last post by LeroyTennison
Wed Jul 03, 2024 1:58 am
[Solved] Cannot get rid of "Update all links?" prompt

Last post by trcjt.ca « Tue Jul 02, 2024 6:37 pm
Replies: 5
by peanutaxis » Wed Jun 19, 2024 11:01 am

5 Replies

5619 Views

Last post by trcjt.ca
Tue Jul 02, 2024 6:37 pm
Merge cells in each row, like Excel 2003

Last post by Fufila « Tue Jul 02, 2024 11:58 am
Replies: 17
by Fufila » Mon Jul 01, 2024 8:54 am

17 Replies

4382 Views

Last post by Fufila
Tue Jul 02, 2024 11:58 am
[Solved] Short cut for sum of products

Last post by MrProgrammer « Mon Jul 01, 2024 8:38 pm
Replies: 1
by me231 » Mon Jul 01, 2024 8:16 pm

1 Replies

2604 Views

Last post by MrProgrammer
Mon Jul 01, 2024 8:38 pm
[Solved] Link cell to a cell in another sheet

Last post by Alex in Grimsby « Mon Jul 01, 2024 12:13 pm
Replies: 6
by Alex in Grimsby » Fri Jun 28, 2024 12:44 pm

6 Replies

4580 Views

Last post by Alex in Grimsby
Mon Jul 01, 2024 12:13 pm
[Solved] Improve year&month summary method

Last post by Cobbles_Classics « Sun Jun 30, 2024 1:21 pm
Replies: 4
by Cobbles_Classics » Sat Jun 29, 2024 9:14 pm

4 Replies

2781 Views

Last post by Cobbles_Classics
Sun Jun 30, 2024 1:21 pm
[Solved] Grey menu prevents field entry

Last post by morphingstar « Fri Jun 28, 2024 7:58 pm
Replies: 13
by morphingstar » Thu Dec 07, 2023 10:15 pm

13 Replies

6980 Views

Last post by morphingstar
Fri Jun 28, 2024 7:58 pm
[Solved] Multiple IF statements

Last post by phillmold « Tue Jun 25, 2024 8:57 pm
Replies: 10
by phillmold » Sat Jun 22, 2024 1:04 pm

10 Replies

4632 Views

Last post by phillmold
Tue Jun 25, 2024 8:57 pm
[Solved] Very long numbers paste incorrectly

Last post by mahairod « Sun Jun 23, 2024 6:17 pm
Replies: 4
by NTcalc » Sun Nov 20, 2022 7:13 am

4 Replies

4443 Views

Last post by mahairod
Sun Jun 23, 2024 6:17 pm
[Solved] Track income/expenses by day

Last post by MrProgrammer « Sun Jun 23, 2024 6:52 am
Replies: 1
by Vancouver_Guy » Sun Jun 23, 2024 4:36 am

1 Replies

3049 Views

Last post by MrProgrammer
Sun Jun 23, 2024 6:52 am
[Solved] Weird value 2.8422E-14 from column sum

Last post by robleyd « Fri Jun 21, 2024 2:27 am
Replies: 5
by TheOldThug » Thu Jun 20, 2024 3:28 pm

5 Replies

3605 Views

Last post by robleyd
Fri Jun 21, 2024 2:27 am
[Solved] Multi-paste row into calendar on due dates

Last post by NTintheNT « Fri Jun 21, 2024 12:47 am
Replies: 4
by NTintheNT » Thu Jun 20, 2024 5:58 am

4 Replies

3312 Views

Last post by NTintheNT
Fri Jun 21, 2024 12:47 am
White borders when convert to PDF

Last post by Elle_Wyv « Thu Jun 20, 2024 6:22 am

by Elle_Wyv » Thu Jun 20, 2024 6:22 am

0 Replies

10863 Views

Last post by Elle_Wyv
Thu Jun 20, 2024 6:22 am
[Solved] Remove periods in string before @

Last post by robleyd « Wed Jun 19, 2024 12:53 pm
Replies: 3
by OPfan8 » Wed Jun 19, 2024 8:32 am

3 Replies

2849 Views

Last post by robleyd
Wed Jun 19, 2024 12:53 pm

New Topic

23347 topics

Page 8 of 467
- Jump to page:
Previous
1
…
6
7
8
9
10
…
467
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