* Jarkko Hietaniemi j...@iki.fi [2009-03-24 15:10]:
=01234
I won't bother explaining the whys because I will start
sobbing.
They are reasonably obvious by looking at the outcome. The fun
part was obviously the journey...
Oh yeah, and I think this constitutes positive evidence for what
Bruce
* Matthew King matthew.k...@monnsta.net [2009-03-24 16:50]:
[Excel] is the effort of an impressive collection of morons all
the way from the luser to the cpu.
Joel Spolsky was the Excel program manager at one time.
Regards,
--
Aristotle Pagaltzis // http://plasmasturm.org/
Aristotle Pagaltzis wrote:
* Matthew King matthew.k...@monnsta.net [2009-03-24 16:50]:
[Excel] is the effort of an impressive collection of morons all
the way from the luser to the cpu.
Joel Spolsky was the Excel program manager at one time.
Which doesn't mean what one might think it does
* Matt McLeod m...@boggle.org [2009-03-26 00:25]:
Aristotle Pagaltzis wrote:
* Matthew King matthew.k...@monnsta.net [2009-03-24 16:50]:
[Excel] is the effort of an impressive collection of morons
all the way from the luser to the cpu.
Joel Spolsky was the Excel program manager at one
* H.Merijn Brand h.m.br...@xs4all.nl [2009-03-24 14:35]:
but why on earth 2009-03-05 *WITH* quotes end up as May 03,
2009 - even in the Dutch locale - is way beyond my level of
understanding.
Did you try 2009-03-05 ? Ie. a quoted column value
surrounded by quote-escaped quotes... It looks
On Mar 25, 2009, at 4:25 PM, Aristotle Pagaltzis wrote:
* H.Merijn Brand h.m.br...@xs4all.nl [2009-03-24 14:35]:
but why on earth 2009-03-05 *WITH* quotes end up as May 03,
2009 - even in the Dutch locale - is way beyond my level of
understanding.
Did you try 2009-03-05 ? Ie. a quoted column
On Wed, Mar 25, 2009 at 06:39:51PM -0700, Joshua Juran wrote:
On Mar 25, 2009, at 4:25 PM, Aristotle Pagaltzis wrote:
[^1]: Or is it? I forget what hates-software is supposed to be,
other than not-a-list.
An automatically-generated blog.
And a gem of self-reference, in that instance.
do
it in Excel anyway.
Darrell
CPU for... well.. long enough that you say fuck it
and go do it in Excel anyway.
Why don't you use the program the way it was designed to be used...
on a brand new Macintosh?
Josh
2009-03-05 is always -MM-DD unless you're a moron.
Granted.
MICROSOFT EXCEL.
You edit my data.
Did you consider that maybe, MAYBE, 8-16 wasn't a date and that you
shouldn't convert it to August 16th? Or perhaps, not edit the DATA so
that I could choose to reformat the cell to text and get back to
8-16 instead of 42853? Where the HELL did 42853 come from
On Tue, 24 Mar 2009 06:35:48 -0700 (PDT), Ann Barcomb
a...@domaintje.com wrote:
On Tue, 24 Mar 2009, H.Merijn Brand wrote:
OO is IMHO even worse, in that they say they follow the locale pretty
strict, but they only follow $LANG and ignore $LC_*
Set $LANG to en_US.utf8 and LC_PAPER to
On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo madsru...@gmail.com wrote:
Where the HELL did 42853 come from anyways?
Honest question? (Fractional) days since the Excel epoch IIRC.
Also, when I save you as a CSV, I expect a line break inside a cell to
be removed or converted. I don't
2009/3/24 Philip Newton philip.new...@gmail.com:
On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo madsru...@gmail.com wrote:
Where the HELL did 42853 come from anyways?
Honest question? (Fractional) days since the Excel epoch IIRC.
Excel Windows epoch. :-) (It was different on a Mac)
Also
Philip Newton writes:
On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo madsru...@gmail.com wrote:
Where the HELL did 42853 come from anyways?
Honest question? (Fractional) days since the Excel epoch IIRC.
Normally, yes, except (with day 1 of the Excel epoch being 1/1/1900)
day 42853 would
Philip Newton philip.new...@gmail.com writes:
On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo madsru...@gmail.com wrote:
Also, when I save you as a CSV, I expect a line break inside a cell to
be removed or converted. I don't expect to see two 8-column lines in
my 16-column CSV file.
I
2009/3/24 Dagfinn Ilmari Mannsåker ilm...@ilmari.org:
Philip Newton philip.new...@gmail.com writes:
On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo madsru...@gmail.com wrote:
Also, when I save you as a CSV, I expect a line break inside a cell to
be removed or converted. I don't expect to
On 2009-03-24, at 07:03, Philip Newton wrote:
In Excel's little sub-dialect, for example, quotation marks around a
field escape not only the field delimiter but also the record
delimiter.
As they should.
Another fun little hateful fact about Excel is that CSV is really
locale-specific list
.
Another fun little hateful fact about Excel is that CSV is really
locale-specific list separator separated values;
Oh, god, I need to update my CSV converter.
Note that the CSV definition only allows single-byte characters as
field separator character, quotation character and escape character
On Tue, 24 Mar 2009 12:43:08 +0100, Mads Ruben Rennemo
madsru...@gmail.com wrote:
MICROSOFT EXCEL.
You edit my data.
Did you consider that maybe, MAYBE, 8-16 wasn't a date and that you
shouldn't convert it to August 16th?
It is worse even. If you have a value like 20090307, obviously an ISO
I had to recently fight Excel not to convert e.g. postal code numbers
and phone numbers to normal numbers. Here's the stomach-wrenching
way to quote a cell in CSV so that Excel gets it:
=01234
I won't bother explaining the whys because I will start sobbing.
--
There is this special biologist
generator I used single-
quotes (which mean nothing to CSV) around serial numbers to keep Excel
from turning them into decimals. No, Excel, 0012345678 is not the same
as 12345678.
, and it's legal for a
program to quote ALL strings. In one CSV generator I used single-quotes
(which mean nothing to CSV) around serial numbers to keep Excel from
turning them into decimals. No, Excel, 0012345678 is not the same as
12345678.
The point is it's interpreting the month and day
Joshua Rodman jrod...@hate.spamportal.net writes:
2009-03-05 is always -MM-DD unless you're a moron.
Ah well you see that's where Excel has one up on you. It is the effort
of an impressive collection of morons all the way from the luser to the
cpu.
Matthew
--
I must take issue
and it's a lot more complex than it seems at first... and while
there's a couple of special case hacks for brain-damaged programs,
Excel isn't one of them. At least as far as CSv *generation* is
concerned. Getting Excel to read CSV without turning random text
strings into other formats is more
line breaks, if they're quoted. I wrote a CSV parser last
year and it's a lot more complex than it seems at first... and while
there's a couple of special case hacks for brain-damaged programs, Excel
isn't one of them. At least as far as CSv *generation* is concerned.
Getting Excel to read
Converting the number to a floating point is an improvement. Often Excel
converts long numbers to dates!
It should be fairly simple using Perl (or Python or Ruby etc.) to generate
an Excel file (or convert a CSV to an Excel file) with the correct types,
and even some fancy formatting.
On 01
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
If that were all, I would probably get a friendly WTF mail from the
commercial guy, and look
is better,
but only slightly.
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-excel).
As an added bonus
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
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 moment
' gets converted to '1234567890123456', which is better,
but only slightly.
Did you try
'1234567890123456
with a leading but no trailing quotation mark?
Yup - it would work if I were to generate an Excel file directly. In CSV
conversion, one just gets '1234567890123456 verbatim
an Excel file directly. In CSV
conversion, one just gets '1234567890123456 verbatim, as it was.
The converter is hatefully cleverer than you or me.
Define 'clever'. M$ Excel has always managed to make me curse when using
it's convertor(s) and `do-the-right-thing'. So far their cleverness has
On Tue, Sep 12, 2006 at 05:03:19PM -0400, Cory Myers wrote:
Worse IMHO, is customers/people/boneheads that have switched to
html-only
mail, just so they can force this font upon us, as they like it so
much.
Or those who've switched to HTML-only mail for the purpose of
delighting in
jrod...@hate.spamportal.net wrote:
In the middle of a long technical discussion about some sort of
development problem in a clunky API that the customer is misusing:
Me: I often become unclear as to who is saying what in these email
exchanges. Could you consider indenting or prefixing the
On or about Tue, Sep 12, 2006 at 07:36:46PM +1000, Daniel Pittman typed:
I think this unfairly maligns Comic Sans, a fine font for the purpose it
was designed for: lettering funny books. Having actually seen it in use
where it was intended I think the font itself is great.
It is utterly
On Sep 12, 2006, at 5:36 AM, Daniel Pittman wrote:
I think this unfairly maligns Comic Sans, a fine font for the
purpose it
was designed for: lettering funny books. Having actually seen it
in use
where it was intended I think the font itself is great.
What I loath is the fashion for
On Tue, 12 Sep 2006, Patrick Carr wrote:
There was a time when I was similarly blasé about the abuses of comic
sans, and then I saw it at 3600 pt, in lights.
http://gneiss.geo.cornell.edu/external/saucy_noodle.jpg
From what I understand they put just as much care into their food.
A
at an impressionable age that *OF COURSE* Excel sheets saved
with localized versions won't work with English Excel since the
functions KESKIARVO(), MEDELTAL(), MOYENNE(), MITTELWERT(), MEDIA(),
etc. are something completely different from AVERAGE() .
* Phil Pennock phil.penn...@globnix.org [2006-09-11 16:21]:
The Project Manager on the office assistant stuff was a lady
who was later to become Melinda Gates.
Melinda French. She also managed the spectacularly stupid
Microsoft Bob project, whose notable spawns include the Comic
Sans font.
On Tue, 12 Sep 2006 19:36:46 +1000, Daniel Pittman dan...@rimspace.net
wrote:
A. Pagaltzis pagalt...@gmx.de writes:
* Phil Pennock phil.penn...@globnix.org [2006-09-11 16:21]:
The Project Manager on the office assistant stuff was a lady
who was later to become Melinda Gates.
Melinda
A document with the name 'TS_200609_NWC.xls' is already open
You cannot open two documents with the same name,
even if the documents are in different folders.
To open the second document, either close the document
that's currently open, or rename one of the documents.
People *pay*
, or rename one of the documents.
People *pay* money for this? Positive sums of money?
Insane isn't it? I hate it too.
I blame the VB scripting model and marketing. They could have had it said
Warning, another different file of this name is already open.
Internally Excel will use 'BLORG
problem
I think you'd still have the problem with OLE Automation -- IIRC, you
can remote-control an Excel and tell it to give you a handle to the
document with name foo.xls that's currently open.
If Excel has three different foo.xls open, and you don't know the
UUIDs, what are you going to do
On 2006-09-11 at 11:15 +0200, demerphq wrote:
Probably the same clowns who got the paperclip idiocy added.
That's called true love.
The Project Manager on the office assistant stuff was a lady who was
later to become Melinda Gates.
-Phil
45 matches
Mail list logo