[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#557041: marked as forwarded (openoffice.org-calc: Functions coming up with #NAME? and, com.sun.star.sheet.addin.analysis)

Your message dated Mon, 23 Nov 2009 17:11:07 +0100
with message-id <20091123161107.GL30310@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 owner@bugs.debian.org
immediately.)


-- 
557041: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=557041
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
fowarded 557041 Kohei Yoshida <kyoshida@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/
 `. `'  rene@debian.org | GnuPG-Key ID: D03E3E70
   `-   Fingerprint: E12D EA46 7506 70CF A960 801D 0AA0 4571 D03E 3E70

--- End Message ---
Reply to: