search

childoftv / as3-xlsx-reader

An Actionscript 3.0 package to read .xlsx Open XML Excel or Open Office spreadsheets
http://childoftv.com/gameshow-platform.php
Other
41 stars 18 forks source link

Cell value when it reference another cell, which again reference another cell - missing #3

Open nevenavv opened 10 years ago

nevenavv commented 10 years ago

I have For example A1 = "hello", A2 = A1, and A3 = A2, A4 = A3, A5 = A4 etc. I'm getting getCellValue('A1'); // hello getCellValue('A2'); // hello getCellValue('A3'); // hello getCellValue('A4'); // '' getCellValue('A5'); // '' etc.

I've noticed this https://github.com/childoftv/as3-xlsx-reader/blob/master/src/com/childoftv/xlsxreader/Worksheet.as#L178 always returns true. Not sure what's this part +""=="" for,.. you have: item.f.(children().length()!=0) which is item.f.(true), so in total: item.f.(true)+true which is true

nevenavv commented 10 years ago

Actually, it doesn't executes to true always, but here is the example where it does, although value is already replaced:

<c r="A4" s="3" t="str" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <f t="shared" si="2"/>
  <v>
    hello
  </v>
</c>