Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Jonathan Stowe
On Fri, 2007-06-01 at 17:35 +0100, Patrick Quinn-Graham wrote: > Excel goes "woah! > this isn't really an Excel file let's treat it as HTML! And kill > it!". This is what happens when you let Steve Ballmer have a hand in the software business, though I guess this must be a more mellow mome

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Patrick Quinn-Graham
On 1-Jun-07, at 12:20 PM, b...@cpan.org wrote: Last time I tried to create Excel files with a script, I ended up reverse engineering the XML format produced by Excel to create an XML file that Excel would read back correctly, if the webserver sent the appropriate MIME type (application/vnd.ms-e

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Peter da Silva
On Jun 1, 2007, at 5:58 AM, Anton Berezin wrote: The file has a number of rows with three columns each, like this: something;something else;1234567890123456 The attachments are opened in Excel - by default - and the user sees something something else1.234E15 BTDT I got the WTF mail an

Re: Firefox DOM Inspector

2007-06-01 Thread A. Pagaltzis
* Philip Newton [2007-06-01 13:35]: > On 6/1/07, Rafael Garcia-Suarez wrote: > >Firebug is much nicer. (but that's off-topic) > > I have a sneaking suspicion, that I'm too lazy to prove, that > it's what's causing my Firefox to respond at a snail's pace. Yes. Firebug drains a lot of CPU, even w

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Philip Newton
On 6/1/07, Andrew Black - lists wrote: Yep - it is nice to know that my phone number is 7.77E+09 And equally nice to know that the postal code for the town hall in Leipzig is 4109. (Hint to Excel: postal codes aren't numbers; leading zeroes are significant. Please keep it as 04109.) Cheers,

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Andrew Black - lists
Anton Berezin wrote: something something else1.234E15 Yep - it is nice to know that my phone number is 7.77E+09

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Anton Berezin
On Fri, Jun 01, 2007 at 11:50:18AM +, H.Merijn Brand wrote: > On Fri, 1 Jun 2007 13:44:08 +0200, Anton Berezin wrote: > > > On Fri, Jun 01, 2007 at 01:24:12PM +0200, Philip Newton wrote: > > > On 6/1/07, Anton Berezin wrote: > > > >I experimented a bit, and > > > > > > > >1234567890123456 >

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread H.Merijn Brand
On Fri, 1 Jun 2007 13:44:08 +0200, Anton Berezin wrote: > On Fri, Jun 01, 2007 at 01:24:12PM +0200, Philip Newton wrote: > > On 6/1/07, Anton Berezin wrote: > > >I experimented a bit, and > > > > > >1234567890123456 > > > 1234567890123456 > > >"1234567890123456" > > > > > >are all silently and w

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Anton Berezin
On Fri, Jun 01, 2007 at 01:24:12PM +0200, Philip Newton wrote: > On 6/1/07, Anton Berezin wrote: > >I experimented a bit, and > > > >1234567890123456 > > 1234567890123456 > >"1234567890123456" > > > >are all silently and without complaint converted to a floating point > >number. > > > >'123456789

Re: Firefox DOM Inspector

2007-06-01 Thread Rafael Garcia-Suarez
On 01/06/07, Nicholas Clark wrote: When I have a line selected in the DOM inspector, and I *drag* the scrollbar, what do you think I want to do? The DOM inspector is so hateful and useless that it would be a good thing to axe it off. Firebug is much nicer. (but that's off-topic)

Re: Firefox DOM Inspector

2007-06-01 Thread Philip Newton
On 6/1/07, Rafael Garcia-Suarez wrote: Firebug is much nicer. (but that's off-topic) I have a sneaking suspicion, that I'm too lazy to prove, that it's what's causing my Firefox to respond at a snail's pace. FF used to be my primary browser on this machine, with Opera being used for only cert

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread H.Merijn Brand
On Fri, 1 Jun 2007 12:58:05 +0200, Anton Berezin wrote: > Ok, so I am generating a CSV file (where "C" obviously stands for > "semicolon") and sending it out to commercial folks so that they distribute > relevant information to [friendly] customers for trials. > > The file has a number of rows w

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Philip Newton
On 6/1/07, Anton Berezin wrote: I experimented a bit, and 1234567890123456 1234567890123456 "1234567890123456" are all silently and without complaint converted to a floating point number. '1234567890123456' gets converted to '1234567890123456', which is better, but only slightly. Did you t

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread Philip Newton
On 6/1/07, H.Merijn Brand wrote: Now try loading this in Excel: 20070512,20071205,05-12-2007,12-05-2007,12/05/2007,05/12/2007,"20070512",... etc etc, preferably under a locale that does not use the braindead american MMDD sequence. Try opening the csv in three ways: 1. double-click in inte

Re: Excel & CSV files with long strings of digits

2007-06-01 Thread book
Le vendredi 01 juin 2007 à 12:58, Anton Berezin écrivait: > > I experimented a bit, and > > 1234567890123456 > 1234567890123456 > "1234567890123456" > > are all silently and without complaint converted to a floating point number. > > '1234567890123456' gets converted to '1234567890123456', wh

Re: Firefox DOM Inspector

2007-06-01 Thread Nicholas Clark
On Fri, Jun 01, 2007 at 11:40:36AM +0100, Nicholas Clark wrote: > When I have a line selected in the DOM inspector, and I *drag* the scrollbar, Oh, sweet. If I re-load the page, you lose all the values. Software with alzheimer's. Just what I need. Nicholas Clark

Excel & CSV files with long strings of digits

2007-06-01 Thread Anton Berezin
Ok, so I am generating a CSV file (where "C" obviously stands for "semicolon") and sending it out to commercial folks so that they distribute relevant information to [friendly] customers for trials. The file has a number of rows with three columns each, like this: something;something else;1234567

Firefox DOM Inspector

2007-06-01 Thread Nicholas Clark
When I have a line selected in the DOM inspector, and I *drag* the scrollbar, what do you think I want to do? a: Scroll? b: Initiate a drag-and-drop? And teasing me by giving me 'a' for half a second then swapping to 'b' isn't endearing you to me. Nicholas Clark

firefox

2007-06-01 Thread Aaron J. Grier
the natively compiled version coredumps (Unlocking unlocked mutex) the pre-built version does noting but endlessly eat CPU ... so I run the linux binary... which seems to work fine. teh fuck ... of course the flash plugin takes down the browser, but oh, I could use the nspluginwrapper, but oh