Your message dated Mon, 23 Nov 2009 17:11:07 +0100
with message-id <[email protected]>
has caused the report #557041,
regarding openoffice.org-calc: Functions coming up with #NAME? and,
to be marked as having been forwarded to the upstream software
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Re: Bug#557041: Functions coming up with #NAME? and, com.sun.star.sheet.addin.analysis
Mon, 23 Nov 2009 17:11:07 +0100
fowarded 557041 Kohei Yoshida <[email protected]>
On Fri, Nov 20, 2009 at 06:48:37AM +0000, John Talbut wrote:
> I attach a spreadsheet that exhibits the problem for me. The problem only
> to occur with spreadsheets that were worked on fairly recently. Archived
> versions of the spreadsheets from several months ago do not have the problem.
> I have had the problem with EOMONTH and with CONVERT_ADD.
Asked Novells calc guy:
--- snip ---
16:06 < _rene_> kohei_: btw, (not urgent) any idea about bugs.debia.org/557041?
16:11 <@kohei_> _rene_: nothing comes to mind that could cause stuff like
16:11 <@kohei_> so, a function name look up fails, and the function is an
16:12 -!- erAck is now known as erAck_away
16:13 < _rene_> kohei_: ... on some documents created with some version, not
with new ones...
16:13 < _rene_> kohei_: that's what puzzles me..
16:13 <@kendy> noelp: Ping?
16:13 <@noelp> kendy, pong
16:17 <@kohei_> _rene_: then I would suspect some changes with ODF
import/export, perhaps the
formula written in the document itself is different. either
that's a bug in
the upstream code or ours.. I'm not sure.
16:18 <@kohei_> _rene_: either way, it would be nice to have the actual
document that fails
to import correctly in the most recent version.
16:19 < _rene_> it's attached there :-)
16:19 <@kohei_> oh!
16:19 < _rene_> [Test functions.ods
16:20 < _rene_> (disclaimer: didn't try that one out myself yet)
16:21 <@kohei_> yup, that one fails
16:25 <@kohei_> for the record, the upstream build fails to load that document
16:26 <@kohei_> but then, the question is, when that document was written, was
16:27 <@kohei_> the newer builds store EOMONTH as EOMONTH in the file, but this
stores EMONTH as com.sun.star......getendofmonth and that gets
16:27 <@kohei_> and of course the lookup of that function fails.
16:27 <@kohei_> actually geteomonth, not getendofmonth
--- snip ---
.''`. René Engelhard -- Debian GNU/Linux Developer
: :' : http://www.debian.org | http://people.debian.org/~rene/
`. `' [email protected] | GnuPG-Key ID: D03E3E70
`- Fingerprint: E12D EA46 7506 70CF A960 801D 0AA0 4571 D03E 3E70
--- End Message ---