## Problem in Openoffie calc

### Problem in Openoffie calc

I made a function as following:
=TAG(HEUTE())
i mean the result has to be the Number of the day today. If i calculate with them it is ok. bay the View at openoffice cals is one day minus. What is the reason?

Regards

Bjoern
Bjoern.Buechel

Posts: 3
Joined: Tue Dec 18, 2007 10:35 pm

### Re: Problem in Openoffie calc

That is
Code: Select all   Expand viewCollapse view
`=DAY(TODAY())`
in English I think. Can you give us an example of the calculations that are ruturning values one day out? Remember, you can add days to a date, but not add two dates together and get another date. The latter is nonsensical.
huw
Volunteer

Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

### Re: Problem in Openoffie calc

Bjoern wrote:.......bay the View at openoffice cals is one day minus. What is the reason?

Could it be that Calc sees 31-12-1899 as day 1 and you are probably counting on 01-01-1900 to be day 1 ??

See: Tools > Options OpenOffice Calc > Calculate foor your setting.
____________
DiGro

AOO 4.1.7 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)

DiGro

Posts: 103
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

### Re: Problem in Openoffie calc

DiGro wrote:Could it be that Calc sees 31-12-1899 as day 1 and you are probably counting on 01-01-1900 to be day 1 ??

See: Tools > Options OpenOffice Calc > Calculate foor your setting.

I tried changing that, but it made no difference to the result returned.
huw
Volunteer

Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

### Re: Problem in Openoffie calc

huw wrote:That is
Code: Select all   Expand viewCollapse view
`=DAY(TODAY())`
in English I think. Can you give us an example of the calculations that are ruturning values one day out? Remember, you can add days to a date, but not add two dates together and get another date. The latter is nonsensical.

thanks for this information,
by the english input =day(today())the visible Value is ok. By the german version the visible Value is one from the day befor. I tryed this with your input =Day(tody()) with englisch settings and with my input =TAG(HEUTE()) it has to be the same but the View result is not the same.
eg. in then english version i see for then 19.12.2007 the 19 and at the german version the 18. that only thy few. The calculation with this value is ok.
Bjoern.Buechel

Posts: 3
Joined: Tue Dec 18, 2007 10:35 pm

### Re: Problem in Openoffie calc

Odd. Perhaps you have discovered a bug in the German localisation. What is Tools > Options... > Calc > Calculate > Date set to?
huw
Volunteer

Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

### Re: Problem in Openoffie calc

For my opinion it is a mistake in the german translation. If i use the english settings its works properly i have open this as a problem in the german community Forum. but the answers are not satisfied. If i use the Function in excel it is ok.

Bjoern.Buechel

Posts: 3
Joined: Tue Dec 18, 2007 10:35 pm

### Re: Problem in Openoffie calc

Merry Christmas, Frohe Weihnachten!
Code: Select all   Expand viewCollapse view
`=DAY(TODAY()) => 24`

Switching to German GUI:
Code: Select all   Expand viewCollapse view
`=TAG(HEUTE()) => 24`

Regardless which day is day #0.
Do not apply any format. The same formula with format "D" (or "T" with german cell number format locale) yields 23 because it shows the day portion only of 1900-01-23, which is the 24th day after day #0 (1899-12-30).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 28647
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Problem in Openoffie calc

Are you sure it's not this bug: Date decrements by one day in Calc.?
AOO4/LO5 • Linux • Fedora 23

acknak
Moderator

Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

### Re: Problem in Openoffie calc

acknak wrote:Are you sure it's not this bug: Date decrements by one day in Calc.?

acknak wrote:I believe[*] this is your issue: Issue 76623: Wrong formatting and displaying for some dates.
...

I don't think so because that issue is about some formatting problem and this thread was initiated with a appearently wrong formula result. =DAY(TODAY()) which should always return the day number of today's date as an integer number.
Bjoern, you can show today's day number by 3 methods at least:
1. =DAY(TODAY()) whithout any date/time formatting. The cell's real numeric value is 24 at the time of writing this.
2. =TODAY() formatted as "D" (or "T" with german cell number format locale). The cell's real numeric value remains the number of days since day #0 (39440 at the time of writing this).
3. =TEXT(TODAY();"D") (or "T" with german cell number format locale) yields a text value, representing today's day number. The text is "24".
Option 1 with any sort of date formatting will display the formatted value of number 24 which might not be what you want since day #24 is January, 23rd of year 1900 and thus the formatted cell shows 23.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 28647
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany