Bug 114199 - FILEOPEN: "Text Import" dialog: show how many columns would get imported with current settings
Summary: FILEOPEN: "Text Import" dialog: show how many columns would get imported with...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.3.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Dialog
  Show dependency treegraph
 
Reported: 2017-12-01 22:15 UTC by clemty
Modified: 2023-05-06 18:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description clemty 2017-12-01 22:15:32 UTC
Description:
Currently there is no way to see how many columns would get imported in the Calc "text import" dialog.

Steps to Reproduce:
1. Paste tab-delimited data with spaces into calc (e.g. "this is sentence A<tab>this is sentence B"
2. Accidentally check both "Tab" and "Space" as separators
3. Click ok

Actual Results:  
8 columns are imported (one for each word)

Expected Results:
2 columns get imported (one for each sentence)


Reproducible: Always


User Profile Reset: No



Additional Info:
Show how many columns will get imported with current separator settings, for example, change the heading 'Fields' to 'Fields (8)' or display a status message in the dialog


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0
Comment 1 Buovjaga 2017-12-03 16:56:01 UTC
Ok, I get it might be hard to notice when there are more than a couple of columns (would require moving the horizontal scrollbar).

Let's ask UX for their view on whether to implement this and if yes, how.
Comment 2 Heiko Tietze 2017-12-04 09:36:46 UTC
Sounds like a good enhancement. Question is how to integrate this info. 

Option 1: Callout, aka speech bubble (that would have to get introduced) showing the number of columns and disappears after a second or so
Option 2a: Label underneath the preview (any other place would be arbitrary and actually wrong)
Option 2b: Redesign with two columns, the preview goes to the right column 

Ideally we get more information into this label. File size -> and/or rough estimation of rows balance the info