Issue 50702 - Excel CELL function not properly converted to ROW function
Summary: Excel CELL function not properly converted to ROW function
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2005-06-14 09:27 UTC by chrom_
Modified: 2008-05-18 00:08 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
.xls file showing the CELL function conversion bug (18.00 KB, application/vnd.ms-excel)
2005-06-16 16:09 UTC, chrom_ 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description chrom_ 2005-06-14 09:27:36 UTC 
Using an italian version of Excel 2003 (11.6355.6360) SP1, the
"=CELLA("riga";A8)" function is ont properly converted into the Calc ROW
function. The problem is with the "riga" argument, because if I translate it
into "row", Calc recognizes it.

To sum up: the italian Excel "=CELLA("riga";A8)" function, should be converted
to "=ROW(A8)" (or to the english excell "=CELL("row";A8)" function).

The bug was found in Openoffice version is the 1.9.100 (tried on both italian
and english versions and I had the same issue).
Comment 1 frank 2005-06-16 14:51:37 UTC 
Hi,

please attach an Excel document with this function created with an Italian Excel.

Thanks for your help.

Frank
Comment 2 chrom_ 2005-06-16 16:09:12 UTC 
Created attachment 27248 [details]
.xls file showing the CELL function conversion bug
Comment 3 chrom_ 2005-06-16 16:10:32 UTC 
I provided the .xls showing the bug.
Comment 4 daniel.rentz 2005-06-17 10:35:12 UTC 
It has been decided in the past that the CELL function of Calc only supports the
English arguments. This is to ensure compatibility between different localized
versions of Calc and Excel.

Note that *only* an Italian Excel will calculate the CELL function using the
argument "riga". An English and a German Excel fail as well as Calc fails. Note
the difference between the function name CELLA and the function argument "riga":
The function name is not stored literally in the formula (only a function
identifier), therefore all versions of Calc and Excel can show the function name
in the current language. But the argument "riga" is a literal text which cannot
be translated. Therefore only the Italian Excel knows how to handle it.

Solution: Change "riga" to the English name "row". All Excel versions can handle
the local versions *and* the English versions of the arguments for this function.
Comment 5 ace_dent 2008-05-17 22:06:05 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 6 ace_dent 2008-05-18 00:08:53 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew