Bugs: Browse | Submit New | Admin

[#28921] Referenced Strings Parse to Float 0.0

Date:
2011-02-10 16:40
Priority:
3
Submitted By:
moo yu (mugathur)
Assigned To:
Nobody (None)
Category:
None
State:
Open
Summary:
Referenced Strings Parse to Float 0.0

Detailed description
If cell A contains a string and cell B references cell A.  When reading the value of cell B, the result will be
"0.0" instead of the value of cell A.

With the attached test case, I ran the following code:
spreadsheet = Excelx.new('formula_string_error.xlsx')
spreadsheet.default_sheet = 'sheet1'
p "A: #{spreadsheet.cell(1, 1)}"
p "B: #{spreadsheet.cell(2, 1)}"

with the following results
"A: TestString"
"B: 0.0"

where the expected result is
"A: TestString"
"B: TestString"

Add A Comment: Notepad

Please login


Followup

Message
Date: 2011-02-25 18:04
Sender: Robert Yu

I had a similar problem in an .xlsx file a formula
was referencing another string cell but it would
return a float value "0.0".  My work-around was to
convert from .xlsx to .ods, which seemed to work fine.

Attached Files:

Name Description Download
formula_string_error.xlsx Sample Spreadsheet Download

Changes:

Field Old Value Date By
File Added5146: formula_string_error.xlsx2011-02-10 16:40mugathur