#568 Sheet rows formatting

[Eugenioz]

When resulted file is in sheet format, there are no respective cells when last columns are empty (null). Correct sheet should have same number of delimiters/columns in each row independently from existence/validity respective columns. It is critical e.g. when you want to import that sheet to DB. Thus, additional formatting (after Mediainfo) is needed.

[Jerome Martinez]

http://tools.ietf.org/html/rfc4180
Lesser priority because this is "should" instead of "must".
"Each line should contain the same number of fields throughout the file."

[Jerome Martinez]

Accepted.

Warning: non-paid bugs are set to low priority, I don't know when I have time to handle it.
If you desire to accelerate the development, don't hesitate to contact me for a quotation.

[Eugenioz]

'Must' is really hard in English. But I can say 'must' instead 'should' because it is csv sheet format requirement.

[Jerome Martinez]

> because it is csv sheet format requirement.

I don't understand. This is "should" --> This is *not* a rfc4180 CSV requirement, only a recommandation.
http://www.ietf.org/rfc/rfc2119.txt
" SHOULD This word, or the adjective "RECOMMENDED", mean that there
may exist valid reasons in particular circumstances to ignore a
particular item"
--> Your tool *must* accept the file I output, because it is valid. Not recommended, but valid.

Yes, I know I should change it because there is no big reason (my reason was file size, tiny reason), this is the reason the ticket is set to "Accepted".

[Eugenioz]

Thank you in advance.

I have experienced with CSV format only in Excel and sqlite - there is there the same number of columns generated and required in sqlite. I have added missing columns by awk but the awk is not for Unicode and it could be problem.