Re: [users] Imported text(csv) to calc

[Greg Merryman]

When I try to export the file from 1.1.4, the only format in the lower 
pulldown I have if I click on "File" and then "Export" is "PDF". I did a 
"Save As" and chose "Text CSV (.csv;.txt)". I then imported the .csv 
into 1.9.79 and all the rows are visible. Does this then mean that we're 
back to the ASCII file as the problem? If so, I'm confused as to why 
1.1.4 handled the file correctly and 1.9.79 did not.

Greg.
Radagar (Greg Merryman)
G. Roderick Singleton wrote:
On Thu, 2005-03-17 at 17:32 -0600, Greg Merryman wrote:
 

I don't mind at all, and thanks again. Sorry I wasn't clear in the 
earlier post.

9809,1341993,Seniawski,Charles,1053662,Generic Users,71048782
9810,1341994,dombrock jr,john,1053662,Generic Users,76013119
9811,1341996,D,Jean,1053662,Generic Users,9186501
9812,1341997,Bennewitz,Thomas,1053662,Generic Users,42944601
I have just put the values of the cells in seperated by commas. I have 
also added the row number. Rows 9811 and 9812 (and all below that) do 
not show in the beta, but they are fine in the stable version. If I open 
the saved spreadsheet from the 1.1.4 in the 1.9.79, it displays fine 
(don't know if that helps). The last line to show from the ASCII file is 
this:

"1341994","dombrock jr","john","1053662","Generic Users","76013119"
Greg.
Radagar (Greg Merryman)
Steve Kopischke wrote:
   

If you don't mind sharing the information, what is in rows 9810, 9811 
and 9812 in the 1.1.4 version after import?

oldgnome
Greg Merryman wrote:
     

I looked at the file...no problems that I can find and it did import 
properly into 1.1.4

Greg.
       

Since you are on windows, may I suggest that you export the 1.1.4
spreadsheet as a CSV and then use 2.0 to import it? I make this
suggestion because it is difficult to see EOF and other control
characters in a file under windows and that is what I suspect is the
problem. That or a missing quote.