Import .csv[help]submit the bug

when import .csv in calc, any numerical value start with “0” will lose it, for example, like phone number.

If your CSV has quoted fields, then in the Text Import dialog, Other Options section check the box for Quoted field as text.

If your CSV fields are unquoted, then in the Text Import dialog, Fields section, right-click on the column type heading and change Standard to Text.

Good to know it, shift key failed horizontal scrolling, so I thought that was just a preview. Btw, it only works for column, not row.

Good to know it, shift key failed horizontal scrolling, so I thought that was just a preview.

i would still consider this a dirty trick… no setting to avoid this issue?