Hello everybody first of all I'm noob about macro programming in LibreOffice but have something outdated experience in programming and with MS Office macro Recorder as well.
Using LibreOffice Ubuntu Linux with Microsoft Windows 10.
I got a spreadsheet with that of columns that all have Filter activated.
One column is day of the week. Another is name of of employee.
I want to create daily schedule printouts to PDF.
This for you want to iterator the day of week List created by the filter. Inside every loop of the day Monday to Friday (I'm using set of strings to identify them with the number and shortcut like 1 equal Monday , 5 = Friday... zero =free planning)
In every day Loop needs to iterate the item's in employees list.
... If possible I want to include one value as a placeholder in both lists active to create empty lines for last minute add-on.
Finally it should be printed landscape with width 1 page height whatever needs (I set a 99 manually so far) to PDF or printer.
Any ideas how to start?
Thanks in advance.
Mike