[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 this? 2. is it possible to create a `calendar'? I mean: I need 12 sheets, each corresponding to a month. Can I get this automatically? 3. Also, I have a list of players. I have a sheet call players. Is it possible to create a sheet with the name of the player automatically as soon as a new player is added? 4. Once I prepare my `template' how can I save it in order to make it possible for my mates to use the file avoiding to edit it? Thanks a lot, Samuele -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 thishttp://office.microsoft.com/en-us/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx, but it does not work: Err.501 appears. Could you help? Thanks a lot, Samuele -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
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));) I like it! On Fri, Oct 19, 2012 at 4:06 PM, Jay Lozier jsloz...@gmail.com wrote: On 10/19/2012 08:41 AM, Samuele Zampini wrote: 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 thishttp://office.microsoft.**com/en-us/excel-help/** inserting-the-current-excel-**file-name-in-a-cell-**HA001034627.aspxhttp://office.microsoft.com/en-us/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx , but it does not work: Err.501 appears. Could you help? Thanks a lot, Samuele Please post the formula you are using and typical path/file name you are using. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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 change. So I need a funcition that counts the elements in column A (numberOfPlayer) and that create n sheets each called player1, player2, .., playern. I wrote something like this: Sub DateSheets() numberOhSheets=1 While Sheet1.A numberOhSheets numberOhSheets = numberOhSheets + 1 Next For sht = 14 To 14 + numberOfSheets Sheets.Add after:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Rosa.A sht-13 Next End Sub What should I do to make it working? And how can I create a button to run it? Thanks a lot, Samuele -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted