format problem exchanging between gnumeric, OO, Excel
- From: "Matthew D. Sale" <mdsale matts-workshop com>
- To: gnumeric-list gnome org
- Subject: format problem exchanging between gnumeric, OO, Excel
- Date: Thu, 27 Mar 2003 07:12:33 -0600
I first thought this was an issue with OO, but it seems to be
coming back as an issue with gnumeric:
------------------------------------------------------------------
http://www.openoffice.org/issues/show_bug.cgi?id=8821
------- Additional Comments From jmarmion openoffice org 2003-03-26 06:09 PST
-------
I believe that the source of this problem is that gnumeric has not
exported this formula correctly in excel format. If I create an Excel
doc and use the attached doc and apply stated formula:
=index(Base,match(Width,Widths,0),match(Length,Lengths,0))
and import this to Calc, then it works successfully.
The attached spreadsheet does not work in Excel. Because the formula
result is stored in the file, Excel simply displays the result. But
attempts to re-execute the formula fail and attempts to save the doc
in Excel will also fail and result in a #VALUE error i.e. an error
occurs when the wrong type of argument or operand is used. This
corresponds to what Calc displays: Err:511 i.e. function requires
more variables. Excel displays the formula as:
=Base Width INDEX(MATCH(Widths,0),Length,MATCH(Lengths,0))
which makes no sense.
So I would like to propose that we close this as not a bug.
-------------------------------------------------------------------
I prefer gnumeric, but need to be able to exchange data between tools
from time to time.
I'm running gnumeric 1.0.10, 1.0.12 will not compile for me.
Matt
_________________________________ _________ '69 Mustang
Matthew D. Sale | /_________\ 13.464 ET
http://www.matts-workshop.com/ | (]]]__O__[[[) 105 MPH
http://www.salesbestsales.com/ | |\_o_____o_/| 351W 3.50
http://www.coachhousegarages.com | |__| |__| 5-spd
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]