search

doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

%format_str list incorrect #55

Open ralesk opened 8 years ago

ralesk commented 8 years ago

It seems to me that the social.msdn site you got it from ate some formatting, and https://metacpan.org/source/Spreadsheet::XLSX::Fmt2007 contains a list that seems more correct (note the opening parentheses in styles 5 to 8 in particular).

doy commented 8 years ago

Have you tested this in Excel to see which is correct? I'd rather not just change things around blindly.

ralesk commented 8 years ago

I could have put a ? at the end of the issue title, and checked in LibreOffice, but I just went with the gut feeling that the syntax there is wonky. Apparently Calc has this wonky syntax as well. (seems like starting with _( would result in the same format, and _), guess an escaped parenthesis, is pretty much a no-op in this situation, whatever it means). I don't currently have access to a real Excel though.

Sorry.