…meie igapäevast IT’d anna meile igapäev…


ASCII 160 or non-breaking space

Filed under: Programmeerimine,Rant — Sander @ 12:10:48
Tags: ,

ascii Dear crappy developer,

please remember, that when you create tables in HTML that need to be opened in Excel, do not use non-breaking space ( ) inside the table cells.   is not rendered to normal space (ASCII 32), it is rendered to ASCII 160 – which Excel then faithfully stores as ASCII 160, meaning that even if (visible) cell content is a number, it is stored as a string in Excel.

And if that particular Excel worksheet is ever opened in an application that is not especially made to remove non-breaking space characters (99.99% of all applications aren’t), it will choke when attempting to convert the cell content into a number. And if you are dealing with legacy applications that you cannot change… guess what? You’re fucked.

Hopefully we’ll meet soon.

Sincerely yours,
axe-murdering mad bastard.


2 kommentaari »

  1. I think I’ve found your problem:

    create tables in HTML that need to be opened in Excel

    Kommentaar kirjutas Jonathan — 2008-03-14 @ 17:54:39 | Vasta

  2. […] ASCII 160 or non-breaking space […]

    Pingback-viide kirjutas 100 000 külastust! « …meie igapäevast IT’d anna meile igapäev… — 2008-11-10 @ 12:50:07 | Vasta

RSS feed for comments on this post. TrackBack URI

Lisa kommentaar

Täida nõutavad väljad või kliki ikoonile, et sisse logida:

WordPress.com Logo

Sa kommenteerid kasutades oma WordPress.com kontot. Logi välja /  Muuda )

Google+ photo

Sa kommenteerid kasutades oma Google+ kontot. Logi välja /  Muuda )

Twitter picture

Sa kommenteerid kasutades oma Twitter kontot. Logi välja /  Muuda )

Facebook photo

Sa kommenteerid kasutades oma Facebook kontot. Logi välja /  Muuda )


Connecting to %s

Create a free website or blog at WordPress.com.