In particular, the solution is that, if you are putting dates DIRECTLY
into the years function, you must put it in QUOTES in the format "-
MM-DD"
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/56953
Marc Stewart, thank you for reporting this bug and helping make Ubuntu
better. As per mentioned OOo website and attached example.ods, the
reason you were getting this error is you were not using the proper date
syntax. Marking Invalid. Please feel free to post any other bugs you
find.
** Changed i
Calc file demonstrating OP syntax v. OOo syntax noted at
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_YEARS_function
** Attachment added: "example.ods"
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/569532/+attachment/1868135/+files/example.ods
--
You
I can confirm this in LibreOffice 3.3.
It would be good if you could raise the bug with the upstream developers at
https://bugs.freedesktop.org//enter_bug.cgi?product=LibreOffice
** Also affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Changed in: libreoffice (Ubuntu)
Actually I didn't realize what it was complaining about, don't worry
about trying again, I'm not sure why it didn't work.
** Changed in: openoffice.org (Ubuntu)
Status: Incomplete => Confirmed
** Tags added: lucid
--
Date strings not interpreted as dates by the YEARS function
https://bug
Rerunning it with openoffice.org-core instead should work, sorry for the
mixup.
** Changed in: openoffice.org (Ubuntu)
Status: Incomplete => New
** Changed in: openoffice.org (Ubuntu)
Status: New => Incomplete
--
Date strings not interpreted as dates by the YEARS function
https://
Chris,
I just did apport-collect 569532 as requested and after giving apport-collect
permissions got the following on my terminal:
===
r...@dart:~$ apport-collect 569532
The authorization page:
(https://edge.launchpad.net/+authorize-token?oauth_token=VXwdvTDnXVBWRcFbwkwq&allow_per
[This is an automatic notification.]
Thank you for taking the time to report this bug and helping to make
Ubuntu better. Please execute the following command, as it will
automatically gather debugging information, in a terminal:
apport-collect 569532
This will help us to find and resolve the pro
I have a similar problem with the DAYS() function.
=DAYS(NOW(), "10/10/2009") gives #VALUE!
but putting 10/10/2009 into cell B3 and doing =DAYS(Now(), B3) seems to work OK.
I also have Openoffice 3.1 running under Xubuntu 9.1 and this works as
expected.
--
Date strings not interpreted as dates