Re: [expert] open source spreadsheet file format.

2003-04-06 Thread Anne Wilson
On Sunday 06 Apr 2003 2:28 pm, Adolfo Bello wrote: > On Tue, 2003-04-01 at 10:46, Frankie wrote: > > its not in xls format... > > > > its currently csv, and as far as I know, having a perl script create xls > > format data would be quiet hard.. > > > > > > Also, I don't want to support M$ file form

RE: [expert] open source spreadsheet file format.

2003-04-06 Thread Adolfo Bello
On Tue, 2003-04-01 at 10:46, Frankie wrote: > its not in xls format... > > its currently csv, and as far as I know, having a perl script create xls > format data would be quiet hard.. > > > Also, I don't want to support M$ file formats.. > > > Thats why I was hoping there was an rtf type forma

RE: [expert] open source spreadsheet file format.

2003-04-03 Thread Frankie
] [mailto:[EMAIL PROTECTED] Behalf Of Jack Coates Sent: Friday, 4 April 2003 12:21 AM To: [EMAIL PROTECTED] Subject: RE: [expert] open source spreadsheet file format. On Thu, 2003-04-03 at 02:36, Frankie wrote: > by that same analogy, rtf should not exist either and data can be handed out >

RE: [expert] open source spreadsheet file format.

2003-04-03 Thread Jack Coates
On Thu, 2003-04-03 at 02:36, Frankie wrote: > by that same analogy, rtf should not exist either and data can be handed out > as txt files with no formating... > users could add the own formatting.. > > I am simply trying to see things though the eyes of our users, who vary form > developers to com

RE: [expert] open source spreadsheet file format.

2003-04-03 Thread Frankie
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David E. Fox Sent: Thursday, 3 April 2003 1:54 PM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. > I can make do assumptions about the systems of the end user... nor about >

Re: [expert] open source spreadsheet file format.

2003-04-02 Thread David E. Fox
> I can make do assumptions about the systems of the end user... nor about > their knowledge level. I can understand that. The end user will just get the data and import it into their favorite spreadsheet or what have you. And it's a given that html is not something that is going to come into a sp

RE: [expert] open source spreadsheet file format.

2003-04-02 Thread Frankie
it'll have to do till someone comes up with rtf for spreadsheets. regards Franki -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Damian Gatabria Sent: Wednesday, 2 April 2003 6:20 PM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet

RE: [expert] open source spreadsheet file format.

2003-04-02 Thread Frankie
ing a session file. It works now.. and its reusable code..so it'll do. rgds Franki -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David E. Fox Sent: Wednesday, 2 April 2003 1:08 PM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet f

Re: [expert] open source spreadsheet file format.

2003-04-02 Thread Damian Gatabria
On Tuesday 01 April 2003 11:46, Frankie wrote: > its not in xls format... > > its currently csv, and as far as I know, having a perl script create xls > format data would be quiet hard.. Is saving as HTML not an option? Damian Want to buy your Pack or Services from MandrakeSoft? Go to http://

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread David E. Fox
> I have to write a webapp with a downlaod option for the data.. > at present the format is in .csv (comma seperated values) OK, most if not all spreadsheets can take CSV. (csv is nearly identical to Basic DATA statement format, without the DATA tokens, in case anyone's wondering). It seems you

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread James Sparenberg
On Tue, 2003-04-01 at 10:44, diego wrote: > XML is universal and should perform ok with any perl/whatever script to > convert to/from any other format. Only backdraw I can think of is > unefficiency (you'd probably end with much more tags than data > itself)... > > Anyway, it seems you have

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread James Sparenberg
On Tue, 2003-04-01 at 06:20, Anne Wilson wrote: > On Tuesday 01 Apr 2003 3:10 pm, Frankie wrote: > > Hi guys, > > > > I have to write a webapp with a downlaod option for the data.. > > at present the format is in .csv (comma seperated values) > > > > however there are massive limitations to what cs

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread diego
--Original Message- > > From: diego [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 01, 2003 11:44 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [expert] open source spreadsheet file format. > > > > > > XML is universal and should perform

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
IL PROTECTED] > Sent: Tuesday, April 01, 2003 11:44 AM > To: [EMAIL PROTECTED] > Subject: Re: [expert] open source spreadsheet file format. > > > XML is universal and should perform ok with any perl/whatever script to > convert to/from any other format. Only backdraw I can think

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 8:21 pm, Frankie wrote: > I also got headers of a sort with csv now as well.. > I had the headings in an array (a list)... so I did a count on them.. and > inserted this in the script: > $csv_output .= '-,' x $count; > > so it adds an underline for each header...

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
bject: Re: [expert] open source spreadsheet file format. Frankie wrote: > so maybe that will have to do for now... csv is just missing to much... I > need basic formatting.. Why not try the original standard SS file formats, Lotus 1-2-3 v1A (WKS) or v2 (WK1)? AFAIK, there is no such

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread JOHAM,DAVID (HP-Boise,ex1)
IIRC, OpenOffice.org is working with OASIS to correct this very problem Here's hoping... David -Original Message- From: diego [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:44 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. X

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread diego
XML is universal and should perform ok with any perl/whatever script to convert to/from any other format. Only backdraw I can think of is unefficiency (you'd probably end with much more tags than data itself)... Anyway, it seems you have hit a good point: missing aplication standards!!

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
ach header... gives it some seperation from the data.. testing in OOo looks ok.. rgds Franki -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anne Wilson Sent: Wednesday, 2 April 2003 1:57 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet f

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Felix Miata
Frankie wrote: > so maybe that will have to do for now... csv is just missing to much... I > need basic formatting.. Why not try the original standard SS file formats, Lotus 1-2-3 v1A (WKS) or v2 (WK1)? AFAIK, there is no such thing as a spreadsheet app that can't handle at least one of them. My

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 12:54 pm, Anne Wilson wrote: > On Tuesday 01 Apr 2003 6:21 pm, Praedor Atrebates wrote: > > As I think about it, I don't see much basis for anyone to come up with a > > "universal" spreadsheet format. Certainly, OO/SO, gnumeri

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 6:45 pm, Frankie wrote: > yeah, I agree with all of that.. > > problem is the end user is not gonna understand downloadin the data as > html.. > > so I went looking at cpan and found this: > http://search.cpan.org/author/JMCNAMARA/Spreadsheet-WriteExcel-0.40/WriteEx >c el.pm

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 6:21 pm, Praedor Atrebates wrote: > As I think about it, I don't see much basis for anyone to come up with a > "universal" spreadsheet format. Certainly, OO/SO, gnumeric, and kspread > developers COULD do so but it would be universal only to them and leave out > excel and lo

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread JOHAM,DAVID (HP-Boise,ex1)
But if you name the file .html.xls, for all the users know, they are downloading Excel files. :) David -Original Message- From: Frankie [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: [expert] open source spreadsheet file format

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
: Re: [expert] open source spreadsheet file format. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 11:57 am, JOHAM,DAVID (HP-Boise,ex1) wrote: > I was able to get it to open in OO.o Calc only after naming the html file > spreadsheet.html.xls. The .xls extension is re

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 11:57 am, JOHAM,DAVID (HP-Boise,ex1) wrote: > I was able to get it to open in OO.o Calc only after naming the html file > spreadsheet.html.xls. The .xls extension is required or OO.o opens the file > (as you saw) in it's silly

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread JOHAM,DAVID (HP-Boise,ex1)
aedor Atrebates [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:43 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 11:18 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 4:55 pm,

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 11:18 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 4:55 pm, JOHAM,DAVID (HP-Boise,ex1) wrote: > > I would suggest trying HTML. Since you're using Perl, it should be a no > > brainier to create an HTML file that you can feed

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Praedor Atrebates Sent: Wednesday, 2 April 2003 12:07 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 10:58 am, Jack Coates wrote: > On Tue, 2003-04

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 11:18 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 4:55 pm, JOHAM,DAVID (HP-Boise,ex1) wrote: > > I would suggest trying HTML. Since you're using Perl, it should be a no > > brainier to create an HTML file that you can feed

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread JOHAM,DAVID (HP-Boise,ex1)
Thanks! I'll send the file via private Email in a minute or so... David -Original Message- From: Anne Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:18 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. On Tuesday 01 Apr 2003 4:

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 4:55 pm, JOHAM,DAVID (HP-Boise,ex1) wrote: > I would suggest trying HTML. Since you're using Perl, it should be a no > brainier to create an HTML file that you can feed to whatever your client > is. I just tried a simple HTML file with both Excel (via CrossOver Office) > and

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 5:07 pm, Praedor Atrebates wrote: > So what IS wrong with *.csv? You can format it so that it is compatible > with windoze or Mac or linux/unix. It is a simple text file and is > importable readable by virtually anything (as Anna stated). > The original post said that he h

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 4:58 pm, Jack Coates wrote: > On Tue, 2003-04-01 at 07:51, Frankie wrote: > > thats great > > > > do u have a suggestion for me as to a spreadsheet format ??? > > .sxw if you must be free, and encourage people to use OpenOffice on all > platforms, or .xls if you want to g

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 4:36 pm, Praedor Atrebates wrote: > I certainly understand the desire to not support M$ file formats. Even > though M$ doesn't gain directly from such support, they do peripherally. > It perpetuates the use of M$ software and the idea that M$ is a "standard" > that people n

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 10:58 am, Jack Coates wrote: > On Tue, 2003-04-01 at 07:51, Frankie wrote: > > thats great > > > > do u have a suggestion for me as to a spreadsheet format ??? > > .sxw if you must be free, and encourage people to use OpenO

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Jack Coates
preadsheet version? > nope. > > seems odd.. > > > rgds > > Franki > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Praedor Atrebates > Sent: Tuesday, 1 April 2003 11:37 PM > To: [EMAIL PROTECTED]

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread JOHAM,DAVID (HP-Boise,ex1)
uesday, April 01, 2003 7:11 AM To: [EMAIL PROTECTED] Subject: [expert] open source spreadsheet file format. Hi guys, I have to write a webapp with a downlaod option for the data.. at present the format is in .csv (comma seperated values) however there are massive limitations to what csv can display

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
Praedor Atrebates Sent: Tuesday, 1 April 2003 11:37 PM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 10:07 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 3:46 pm, Frankie wrote: > > its n

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Praedor Atrebates
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 01 April 2003 10:07 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 3:46 pm, Frankie wrote: > > its not in xls format... > > > > its currently csv, and as far as I know, having a perl script create xls > > format data would be quiet hard.. >

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 3:46 pm, Frankie wrote: > its not in xls format... > > its currently csv, and as far as I know, having a perl script create xls > format data would be quiet hard.. > I suggested this because just about any spreadsheet can read/write .xls. I use Gnumeric, and use .xls to cro

RE: [expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
ssage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anne Wilson Sent: Tuesday, 1 April 2003 10:20 PM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. On Tuesday 01 Apr 2003 3:10 pm, Frankie wrote: > Hi guys, > > I have to write a webapp w

Re: [expert] open source spreadsheet file format.

2003-04-01 Thread Anne Wilson
On Tuesday 01 Apr 2003 3:10 pm, Frankie wrote: > Hi guys, > > I have to write a webapp with a downlaod option for the data.. > at present the format is in .csv (comma seperated values) > > however there are massive limitations to what csv can display. notably > there is no way to make headers of fo

[expert] open source spreadsheet file format.

2003-04-01 Thread Frankie
Hi guys, I have to write a webapp with a downlaod option for the data.. at present the format is in .csv (comma seperated values) however there are massive limitations to what csv can display. notably there is no way to make headers of format the data at all In word processors we have rich text