Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 02 Oct 2018 04:37:42 +0200Adding Blank Rows for Sequential Missing Numbershttps://ask.libreoffice.org/en/question/167356/adding-blank-rows-for-sequential-missing-numbers/ I have a large database import I am working with that is several tables of data that have to be combined into one master spreadsheet(csv) for import.
There is a primary key with both tables but both tables are missing numbers say the order is 11-83529 but neither table is completely sequential.
The only solution I have found the works on that column is to fill - series choosing linear and using the line numbers.
However I need to act that way on the whole , adding a row each time it finds a missing number and adding the number to the first column? Does anyone know how to do this?
chrchcolTue, 02 Oct 2018 04:37:42 +0200https://ask.libreoffice.org/en/question/167356/print using Writer sequentially numbered return address sized labels.https://ask.libreoffice.org/en/question/55822/print-using-writer-sequentially-numbered-return-address-sized-labels/(Have already set up the 4 column 20 line (80 label) sheet to be used.)
Two lines: first line is four words the same on each label, second line the number with leading zeros gotten from a Calc spreadsheet. The font size different on each line (if that should make a difference). REAL newbie, needs easy instructions. Please help.UnkaDThu, 06 Aug 2015 01:00:08 +0200https://ask.libreoffice.org/en/question/55822/