Re: automatic move to next spreadsheet
Hello, -Original Message- From: JW LISTER [mailto:sa...@jwlister.co.uk] Sent: Tuesday, May 21, 2013 3:54 PM To: marketing@openoffice.apache.org Subject: automatic move to next spreadsheet Dear Sir I use Openoffice spreadsheets and would find it handy if the next or following spreadsheet was suggested when updating a list of spreadsheets. i.e. if BASK011 has been amended,saved and I wish to save and go to the next BASK012 it would be a great help and save time if next file name be shown in the box used for opening a spreadsheet. Best regards J.S.Wardingley I think this is a typical task for a macro automation not for a change of AOO itself. Are you familiar with macros? If not, use a forum such as: http://forum.openoffice.org/en/forum/ or you hire a supporter, see: http://www.openoffice.org/bizdev/consultants.html or inform yourself about macro programming, a good start is eg http://www.pitonyak.org/oo.php Greetings, Jörg - To unsubscribe, e-mail: marketing-unsubscr...@openoffice.apache.org For additional commands, e-mail: marketing-h...@openoffice.apache.org
Re: automatic move to next spreadsheet
Hello, From: acolor...@gmail.com [mailto:acolor...@gmail.com] On Behalf Of Alexandro Colorado Sent: Tuesday, May 21, 2013 6:23 PM To: OpenOffice Marketing Subject: Re: automatic move to next spreadsheet I am not sure how can we predict ther is a BASK012 You can separate the file name and read character by character from right, as in Basic as follows: i = 0 do i = i + 1 tmp = Right (filename, i) loop while IsNumic(tmp) = True If LEN (Right (filename, i-1)) = 1 Then '--here is a file name, with number at the end, found end if But I think this is a typical task for a macro automation not for a change of AOO itself. Greetings, Jörg - To unsubscribe, e-mail: marketing-unsubscr...@openoffice.apache.org For additional commands, e-mail: marketing-h...@openoffice.apache.org
automatic move to next spreadsheet
Dear Sir I use Openoffice spreadsheets and would find it handy if the next or following spreadsheet was suggested when updating a list of spreadsheets. i.e. if BASK011 has been amended,saved and I wish to save and go to the next BASK012 it would be a great help and save time if next file name be shown in the box used for opening a spreadsheet. Best regards J.S.Wardingley J W Lister Ltd Clifton Road, Brighouse HD6 1SL Tele: 01484 712925 Fax: 01484 715314 __ Information from ESET NOD32 Antivirus, version of virus signature database 8357 (20130521) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com - To unsubscribe, e-mail: marketing-unsubscr...@openoffice.apache.org For additional commands, e-mail: marketing-h...@openoffice.apache.org
Re: automatic move to next spreadsheet
I am not sure how can we predict ther is a BASK012 On Tue, May 21, 2013 at 8:54 AM, JW LISTER sa...@jwlister.co.uk wrote: Dear Sir I use Openoffice spreadsheets and would find it handy if the next or following spreadsheet was suggested when updating a list of spreadsheets. i.e. if BASK011 has been amended,saved and I wish to save and go to the next BASK012 it would be a great help and save time if next file name be shown in the box used for opening a spreadsheet. Best regards J.S.Wardingley J W Lister Ltd Clifton Road, Brighouse HD6 1SL Tele: 01484 712925 Fax: 01484 715314 __ Information from ESET NOD32 Antivirus, version of virus signature database 8357 (20130521) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --**--**- To unsubscribe, e-mail: marketing-unsubscribe@**openoffice.apache.orgmarketing-unsubscr...@openoffice.apache.org For additional commands, e-mail: marketing-help@openoffice.**apache.orgmarketing-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor http://es.openoffice.org