Bug 148943

Summary:	CSV filter token 4 (number of first row) needs an explicit "CSV Import" clarification
Product:	LibreOffice	Reporter:	Mike Kaganski <mikekaganski>
Component:	Documentation	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	erack, olivier.hallot
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
URL:	https://ask.libreoffice.org/t/how-to-convert-csv-from-command-line-and-ignore-first-lines/77114/
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=140779 https://bugs.documentfoundation.org/show_bug.cgi?id=149759
Whiteboard:	target:7.4.0
Crash report or crash signature:		Regression By:

Description Mike Kaganski 2022-05-05 04:09:45 UTC

https://help.libreoffice.org/7.3/km/text/shared/guide/csv_params.html

https://ask.libreoffice.org/t/how-to-convert-csv-from-command-line-and-ignore-first-lines/77114/ is how a user was confused that using the "Number of First Row" CSV filter token for export doesn't work.

As Eike mentioned there, "the help text says “Row number to start reading” this is for importing CSV" - but there's an alternative reading of "start reading" as "read the spreadsheet when exporting". So having a uniform "CSV Import" marker, like those used starting from token 7, would be very clear. (I suppose that these markers deserve a separate column, so that token names are separate from import/export specifiers.)

Comment 1 Commit Notification 2022-05-11 09:39:36 UTC

Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/44126837152e16fa861ded498f315d57b574e441

tdf#148943 Clarify CSV import token 4