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

2008-03-14

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Muuda )

Twitter picture

You are commenting using your Twitter account. Log Out / Muuda )

Facebook photo

You are commenting using your Facebook account. Log Out / Muuda )

Google+ photo

You are commenting using your Google+ account. Log Out / Muuda )

Connecting to %s

Create a free website or blog at WordPress.com.