[libreoffice-users] Macro to create sheets

Dear All, I am trying to write a macro in order to create some sheets once it is invoked (e.g. through a button). Sheet 1 contains a list. So cells in the first column contains a name: A1 = player1 A2 = player2 A3 = player3 A4 = player4 A5 = player5 A6 = player6 .. An = playern where n may chan

Re: [libreoffice-users] Insert the filename in a cell

I solved it with this formula: =REPLACE(REPLACE(CELL("filename");FIND(".";CELL("filename");1);(LEN(CELL("filename"))-FIND(".";CELL("filename");1)+1);"");1;SEARCH("/[^/]*$"; CELL("filename"));"")

[libreoffice-users] Insert the filename in a cell

Dear All, I am trying to insert in a cell (let's say A1) the file name (without the path and - if possible - without the extension). I have tried this, but it does not work: Err.501 app

[libreoffice-users] Questions about LibreOffice

Dear All, I am trying prepare a Calc file for my soccer team (to record training sessions, matches and co).. I have some questions: 1. as far as the conditional formatting is concerned, is it possible to say "if a1 is empty", then the cells in the row one does not have any borders? How can I do