Your message dated Mon, 23 Nov 2009 17:11:07 +0100
with message-id <20091123161107.gl30...@rene-engelhard.de>
has caused the report #557041,
regarding openoffice.org-calc: Functions coming up with #NAME? and,
com.sun.star.sheet.addin.analysis
to be marked as having been forwarded to the upstream software
author(s)
(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 ow...@bugs.debian.org
immediately.)
--
557041: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=557041
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
fowarded 557041 Kohei Yoshida <kyosh...@novell.com>
thanks
Hi,
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
> seems
> 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
that....
16:11 <@kohei_> so, a function name look up fails, and the function is an
add-in....
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
(application/vnd.oasis.opendocument.spreadsheet, inline)]
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
too.
16:26 <@kohei_> but then, the question is, when that document was written, was
it written
properly.... ;-)
16:27 <@kohei_> the newer builds store EOMONTH as EOMONTH in the file, but this
test document
stores EMONTH as com.sun.star......getendofmonth and that gets
imported
literally.
16:27 <@kohei_> and of course the lookup of that function fails.
16:27 <@kohei_> actually geteomonth, not getendofmonth
--- snip ---
Grüße/Regards,
Rene
--
.''`. René Engelhard -- Debian GNU/Linux Developer
: :' : http://www.debian.org | http://people.debian.org/~rene/
`. `' r...@debian.org | GnuPG-Key ID: D03E3E70
`- Fingerprint: E12D EA46 7506 70CF A960 801D 0AA0 4571 D03E 3E70
--- End Message ---