The attached file was found on a Microsoft Excel support page, although I can't find the reference. It contains a lot of number formatting examples that should all work.

CommentFileSizeAuthor
#4 NMBRFRMT97.xls21.5 KBinfojunkie
NMBRFRMT.XLS28 KBinfojunkie

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented

Checked in a couple of fixes in the module and a fix in the SocialCalc engine on GitHub. These fixed:

* Incorrect background colors.
* Narrow default columns
* SocialCalc engine crashing in subsequent worksheets due to styling issues

infojunkie’s picture

infojunkie
Location Vancouver
commented
Issue tags: -r1.5 +sheetnode-6.x-1.6
infojunkie’s picture

infojunkie
Location Vancouver
commented

Re-tagged to next release. Current release covers 95% of this spreadsheet.

infojunkie’s picture

infojunkie
Location Vancouver
commented
StatusFileSize
new NMBRFRMT97.xls21.5 KB

The original file is in Excel 5 format, which is less supported than Excel 97. The attached file here is better supported.

infojunkie’s picture

infojunkie
Location Vancouver
commented

Update a year later: only two formats still misbehaving.

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Fixed

Formats are now imported correctly for this sample.

Status: Fixed » Closed (fixed)
Issue tags: -sheetnode-6.x-1.6

Automatically closed -- issue fixed for 2 weeks with no activity.

Issue tags: +sheetnode-6.x-1.6

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.