Apache OpenOffice Community Forum

We are presently using a lab file solution for printing bulk jobs of photographs. This includes adding groups.

Presently, the system prints out one group at a time and everything is in essence pre-sorted. The program however requires leading zeroes, and OO.o strips leading zeroes upon resaving the CSV file, meaning that if we need to edit something in the lab file, the bulk is going to print out of order.

Is there an option to force OO.o to respect leading zeroes on CSV imports?

If the numbers are quoted, Base will obey the quotes and serve the text to any document as literal text. One of many reasons why one should always connect a Base document to a directory of csv and then work with import ranges in spreadsheets.

In Calc's text import dialog you have to specify the column as "Text" every time you open such a file. Right-click the column in the preview and choose "Text". You can also select more than one column and choose "Text" from the list box.
Column type "Standard" means: treat each value exactly like manually entered.