search

eric-wood / excel2latex

Javascript .xlsx to LaTeX table converter
90 stars 28 forks source link

Decimal Truncation Issue #3

Open nickhudspeth opened 11 years ago

nickhudspeth commented 11 years ago

By default, the excel2latex converter ignores the decimal truncation formatting in excel, instead including all decimal places (out to 20 or so). This is frequently undesirable in latex tables.

eric-wood commented 11 years ago

Agreed, this was on my original wish list as well...the whole tool was hacked together so quickly I didn't add it.

Excel stores the raw, unformatted, number in the data elements. The real challenge is understanding how they mark up formatting info.

I'll start by getting it to truncate to the desired decimal point, and if there's other formatting you'd like to see it accept, I can figure that out as well.

I'll get a chance to work on this next week.

Thanks for your feedback!

On Jun 7, 2013, at 3:16 AM, Nick Hudspeth notifications@github.com wrote:

By default, the excel2latex converter ignores the decimal truncation formatting in excel, instead including all decimal places (out to 20 or so). This is frequently undesirable in latex tables.

— Reply to this email directly or view it on GitHub.

SheetJSDev commented 10 years ago

@eric-wood if you are still interested, https://github.com/SheetJS/ssf is a pure JS module that parses excel format codes and generates text

eric-wood commented 10 years ago

This looks like exactly what I need. I'll check it out! Thanks a ton!