![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Spreadsheets still works for .csv CSV files. The problem is with .txt
ones.
I reported this as bug 38479:
Tab delimited files are quite common. they were .tsv once. I use them
for some of my exports where the data contains commas.
The commas could be in the text of text fields or if you are using a
comma as a decimal separator you probably want a .tsv file for import.
Calc handles import of text data well in my opinion, fixed width is
usefull for undelimeted text.
steve
Please note Calc's CSV import allows you to pick tab as a separator,
thus "tab separated values" are supported, just rename the file to .csv
and then pick the right option in the "Text import" window that appears.
nunojsilva@ist.utl.pt (Nuno J. Silva) writes:
I see the "Text CSV (*.csv;*.txt)" now. When I checked the File |
Open ... dialog before, the scroll bar was off the right of my display
[;<). That is *way* down there, huh?It is. Well, it means LibO supports many formats.
But the list is really long, I wonder if someone is thinking about how
to make it easier to browse (if that's possible).
Just make the list larger, as screen space permits.
It took about 20 years before file selectors finally became reasonably
large (or could be resized) and even remembered their size. Still they
don´t remember their position on the screen and don´t allow you to have
the scroll bars on the left side, so they continue to be a nuisance. Why
can´t developers create good file selectors even after 20 years?
Lee, I agree with the commenter here.
I think it is also a bug when the Open dialog has a pull-down list that extends beyond the edge of the screen. My understanding is they are supposed to move left, down, or up, to avoid that. All the well-behaved applications I run do that. In fact, I take advantage of that fact in arranging to take screen shots where dialogs and pop-ups are forced inside the frame of the application.
Also, I don't know what the minimum dimension of screen for successful use of LibreOffice might be, but the list we're talking about could easily exceed it. The bigger problem is that it appears to be random so folks have no clue that they should perhaps keep looking once they find a likely suspect (that happens to not work).
- Dennis
The list if file types is impressive but beyond utility. Why not filter the list
according to the extension of the file being opened as soon as a file has been
specified?
PS I urgently need tio divert the tsunami of mail list items overwhleming my
email. I've twice sent an email to users+help@libreoffice.org but nothing comes
back even to my spam. What do I do to change the email address or unsubscribe?
Thanks
The mailing list domain changed a couple weeks ago, that should be
users+help@global.libreoffice.org.
Some headers from a random message from this list:
List-Unsubscribe: <mailto:users+help@global.libreoffice.org>
List-Help: <mailto:users+help@global.libreoffice.org>
List-Subscribe: <mailto:users+subscribe@global.libreoffice.org>
List-Owner: <mailto:postmaster@documentfoundation.org>
I guess you can try subscribing from the new address and unsubscribing
from the other.
Or maybe the reply you'll get when mailing +help has specific
instructions to change the address associated to the subscription.
If everything else fails, you can reach a human using the list-owner
address.
Am 19.06.2011 23:07, Tom Davies wrote:
Hi
Where do you get the tab delimited file from? Does it offer a Csv (comma
separated values) option as well? If so then Csv is the more normal method of
transferring data.
Tab delimited, comma delimited, pipe delimited, semicolon delimited, any char can delimit text tables and there are thousands of different text table formats out there, not counting those separated by fixed positions. Calc is supposed to handle all of them as far as they provide some reasonable pattern. Comma as column delimiter is inapropriate when decimals have commas.
Any file can have any file name extension (even under Windows). LibreOffice can open or link any plain text file with any (or none) file name extension using Writer or Calc as the appropriate component.
It is kind of random.
The problem is that the useful display area depends on the display
physical size, the defined screen resolution (as in density of pixels,
DPI), the screen size (number of pixels, what's commonly called
resolution) and the text size. (And also on the way LibO reacts to these
variables.)
A subproblem now is with the new netbooks, where manufacturers try to
make "more space" available by increasing the resolution (DPI) of the
display, while the OS runs at 96 DPI.
This leads some users to just use the 96 DPI and the default, others to
increase font size so things become readable (thus somehow reducing the
available space) and others to actually set the resolution to the
correct value (which will reduce even more the available space).
Yesterday I was pointed to a 3-year-old weblog post by Federico Mena
Quintero, about how font sizes are affected by this problem:
http://people.gnome.org/~federico/news-2007-01.html#font-sizes
From: lee [mailto:lee@yun.yagibdah.de]
nunojsilva@ist.utl.pt (Nuno J. Silva) writes:
I see the "Text CSV (*.csv;*.txt)" now. When I checked the File |
Open ... dialog before, the scroll bar was off the right of my display
[;<). That is *way* down there, huh?It is. Well, it means LibO supports many formats.
But the list is really long, I wonder if someone is thinking about how
to make it easier to browse (if that's possible).Just make the list larger, as screen space permits.
[...]
I think it is also a bug when the Open dialog has a pull-down list that extends
beyond the edge of the screen. My understanding is they are supposed to move
left, down, or up, to avoid that. All the well-behaved applications I run do
that. In fact, I take advantage of that fact in arranging to take screen shots
where dialogs and pop-ups are forced inside the frame of the application.
[...]
The list if file types is impressive but beyond utility. Why not filter the list
according to the extension of the file being opened as soon as a file has been
specified?
What happens now is that the "File type" option fills two purposes:
filter the file list and specify which "input filter" (file format) to
use.
Filtering the list is useful when a directory has lots of files, and
picking the right format is useful not only when there are ambiguities
(like *.txt) but also when the file does not have the "extension" LibO
associates with the format (although this requires you to either pick
the file first with "All files" and only then choose the tipe, or to
enter the filename by hand).
Nino,
>
>> Just make the list larger, as screen space permits.
>>
> Lee, I agree with the commenter here.
>
> I think it is also a bug when the Open dialog has a pull-down list
> that extends beyond the edge of the screen. My understanding is they
> are supposed to move left, down, or up, to avoid that. All the
> well-behaved applications I run do that. In fact, I take advantage of
> that fact in arranging to take screen shots where dialogs and pop-ups
> are forced inside the frame of the application.
>
> Also, I don't know what the minimum dimension of screen for successful
> use of LibreOffice might be, but the list we're talking about could
> easily exceed it. The bigger problem is that it appears to be random
> so folks have no clue that they should perhaps keep looking once they
> find a likely suspect (that happens to not work).It is kind of random.
The problem is that the useful display area depends on the display
physical size, the defined screen resolution (as in density of pixels,
DPI), the screen size (number of pixels, what's commonly called
resolution) and the text size. (And also on the way LibO reacts to these
variables.)A subproblem now is with the new netbooks, where manufacturers try to
make "more space" available by increasing the resolution (DPI) of the
display, while the OS runs at 96 DPI.This leads some users to just use the 96 DPI and the default, others to
increase font size so things become readable (thus somehow reducing the
available space) and others to actually set the resolution to the
correct value (which will reduce even more the available space).Yesterday I was pointed to a 3-year-old weblog post by Federico Mena
Quintero, about how font sizes are affected by this problem:http://people.gnome.org/~federico/news-2007-01.html#font-sizes
--
Nuno J. Silva (aka njsg)
gopher://sdf-eu.org/1/users/njsg
Thanks for the link. I would add another group to his users, those who
are old enough to need reading glasses or bifocals would prefer a larger
font on screen.
I have seen some webpages use a very small font that is was impossible
to read.
As a suggestion on netbooks as default display.
Have icons roll out to right, instead of full text and down. When doing a roll-over on icon, blip menu text for that icon.
This way menus can be set by default according to screen automatically to give most understandable result.