[Libreoffice] Patch for ignoring preceding and trailing spaces in cell during csv import

Kohei Yoshida kyoshida at novell.com
Mon Dec 13 13:28:34 PST 2010


Hi there,

I'd like to port a patch to the libreoffice-3-3 branch to ignore
preceding and trailing spaces in cells during csv import.  The change is
already committed on master, and the attached is the total difference
against the current libreoffice-3-3 branch.  The change on master
consists of several commits.

With this change, a csv file such as this

30, 40, 50

or

30 , 40, 50

will be imported as three number cells.  Currently, Calc imports number
cells as strings in presence of spaces before or after the number.

This change is only applicable when the user leaves the "Detect special
number" option *un*-checked, which is off by default.

Patch reviews are appreciated.

Kohei

-- 
Kohei Yoshida, LibreOffice hacker, Calc
<kyoshida at novell.com>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: patch-to-skip-spaces-csv.diff
Type: text/x-patch
Size: 1897 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20101213/6f937bac/attachment.bin>


More information about the LibreOffice mailing list