Recently, I tried to open an Microsoft Excel file with
OpenOffice Calc and encountered error in a function
(VLOOKUP). I tried to check further and found that
under normal conditions, it is working without error
but only under certain conditions it becomes error.
I just take the sample area that caused the error.
In the Sheet1 of my Excel file, I have the data area
defined in cell A2:C7. Then I put the value that I
want to find in Sheet2 cell B1. Then I put the
following formula in Sheet2 Cell C1.
=VLOOKUP($B1,Sheet1!$B$1:Sheet1!$C$5,2,FALSE)
I saved the file.
Then I use OpenOffice Calc to open that file.
It shows âErr:508â.
The formula in the cell is shown as
=VLOOKUP($B1;$Sheet1.$B$1:$Sheet1.$C$5;2;FALSE())
But if I put the formula in original Excel file as
=VLOOKUP($B1,Sheet1!$B$1:$C$5,2,FALSE)
(without repeating the Sheet1 in front of $C$5)
when I open the file with OpenOffice, there is no
error.
However, in Excel, both format works.
I am not sure, whther it should be called as
incompatibility or bug or just normal condition. Just
to help for some people, who might have encounter
error on this.
rgds,
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
