https://bugs.documentfoundation.org/show_bug.cgi?id=149760

            Bug ID: 149760
           Summary: Allow to define column widths for fixed-width CSV
                    export from export filter's token 5
           Product: LibreOffice
           Version: unspecified
          Hardware: All
               URL: https://forumooo.ru/index.php/topic,9233
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

As mentioned in bug 149759, currently token 5 of CSV filter parameter string
[1] is import-only. Still it would be nice if this token could be used for
export, when fixed-width export is used (FIX in token 1). In than case, the
token could take a simplified form of "0/30/48/97" to define the position at
which to start the respective column, or maybe "10/10/5/50" to define width in
characters for each column.

Currently, converting to CSV from command line could produce a "glued" columns,
like

  col1  col2 col3
  abc   ghi  jkl
  abcdefghi  jk

where the "abcdef" is not separate from "ghi" in the second data row. (The
actual result could be worse, with all rows having glued data, so it would be
impossible to tell one column from another.) The export takes the widths from
the "physical" column width in lcl_ScDocShell_GetFixedWidthString. So the new
feature, if implemented, would make that code consider the passed column widths
when present.

[1] https://help.libreoffice.org/7.4/en-US/text/shared/guide/csv_params.html

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to