Formulas in CSV files
- From: Spencer Collyer <spencer lasermount uklinux net>
- To: gnumeric-list gnome org
- Subject: Formulas in CSV files
- Date: Thu, 23 Oct 2003 17:34:57 +0100
In an old version of Gnumeric (can't remember exactly which one, it was
the one that came with Mandrake 8.0, and was a 0.*.* one) I could import a
CSV file like the following:
---8<------Start File------8<---
1,"=date(2001,12,15)","=time(14,15,0)"
2,"=date(2001,12,15)","=time(14,45,0)"
---8<-------End File-------8<---
and it would correctly interpret the formulas embedded in the file, and
give me the actual formulas.
Now, however, with Gnumeric 1.0.12 under SuSE Pro 8.2, when I import such
a file, it reads the formulas as strings. If I delete the "'" marker at
the start of them then the formula works correctly, but obviously this is
sub-optimal, and, for big files, a real non-starter.
I tried using the Search & Replace tool, but that did nothing. If I try
removing the quotes from around the forumlas, I just get them split across
several rows instead (which is what I expected, just thought I'd try it
first.)
Is there any way to get the old behaviour back? Alternatively, is there a
text format that _does_ allow me to enter formulas like date() and time()
and interprets them correctly on import?
Thanks in advance for any help
S>
ps Searched the archives of this ML for anything related to this problem,
but I couldn't find anything.
--
<<< Eagles may soar, but weasels don't get sucked into jet engines >>>
5:15pm up 23 days 0:56, 12 users, load average: 0.00, 0.02, 0.03
Registered Linux User #232457
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]