Classification: PUBLIC Please note last email's attachment was infected with a virus.
Charlene Hosein Director, Professional Services Phirelight Security Solutions Inc This communication contains confidential information intended solely for the use of the individual/s and/or entity or entities to whom it was intended to be addressed. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this transmission is prohibited. If you have received this communication in error, please contact the sender immediately, delete the communication from your system and do not disclose its contents to any third party or use its contents. Any opinions expressed are solely those of the author and do not necessarily represent those of Phirelight Security Solutions Inc. unless otherwise specifically stated. From: mhvlug [mailto:[email protected]] On Behalf Of Wesley Peterson Sent: February-19-13 12:09 PM To: Mid-Hudson Valley Linux Users Group Subject: Re: [mhvlug] Two LibreOffice questions Notice from Sophos E-mail Appliance (SEA). Potentially dangerous attachments were identified and removed from this message. Jack, I know you've already handled your "save as .xls" issue, but here's an alternate . . . I'm paranoid. I've been doing this too long to have not lost files, and it always happens when I can least afford to. In order to provide as much of a recovery path as possible, I put together a LibraOffice Basic routine that would save my LibreOffice .ods workbook as: .ods, .sxc and .xls. I then tied this to a new save button that lets me do this save as easily as if I were doing the original save. If my .ods file gets mangled, I can copy / paste from the last saved .sxc version (almost all the stuff in an .ods works in .sxc). If somehow that is also mangled I can drop back to the .xls version (where there are a number of things that won't work due to incompatibilities {thanks MS}, but at least I'll have my data). The attached .bas file works for .ods workbooks, but could very easily be modified for .odt (Writer / Word) documents. I took a copy of an old save button, superimposed a "3" on it and made a new button on my toolbar to run the attached macro. If you like this idea, you could do something similar. A word of caution, I originally did this in Open Office but found that there were some differences in LibreOffice so I had to redo this. It's origins are recorded macros for doing Save As using the file types I was interested in. I then (REALLY) kludged the path / filename / extension extractions because at the time I was working at Excel macros and the VBA way of doing things is not the same as LirbeOffice or OpenOffice.org and I didn't want to dive deep into LibreOffice Basic to the extent that I'd try using LibreOffice Basic at work. I'm certain there are better ways (I would have expected a FileName function for example and I'm sure there is one if I looked hard enough through the documentation -- I just couldn't at the time this was written). I've got some debugging statements with a ''' prefix (to comment them out) and some regular comments prefixed with a single '. Let me know if you try this and/or think a properly written version would be useful. Wes On Mon, Feb 18, 2013 at 5:24 PM, Jack Chastain <[email protected]<mailto:[email protected]>> wrote: Greetings. I am playing around with LibreOffice Calc. Heck, if this works, I might try to spend some time making an Android App out of it. First question - the default save format is ".ods" - and I can't seem to find an app on the Android to open this. The obvious solution is to save it in Excel format - but when I select "File/Save As" - nothing happens. Is my LOC broken, or does LO just not convert files? Second question - I would love to do an embedded calculation (sort of "If (CELL is not blank, then if (A+B then C else D) else null) - Yeah - I'm kind of silly like that). I am probably faced with building a small macro, but figured I would ask if/how to do this without going to a macro if I don't have to. Any thoughts on either or both appreciated! In the mean time, I may just go to Google Drive and recreate the sheet there. I know I can get to that from the phone. JC -- Eschew obfuscation and pompous prolixity. Light a man a fire, he is warm for the night. Light a man afire, he is warm for the rest of his life. _______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) Vassar College Feb 6 - Raspberry Pi Mar 6 - 10th Anniversary Meeting - Linux where you least expect it Apr 3 - Typography: Physical Art to Digital Art This message has been classified as PUBLIC by Charlene Hosein on February-19-13, 12:11:09 PM.
_______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) Vassar College Feb 6 - Raspberry Pi Mar 6 - 10th Anniversary Meeting - Linux where you least expect it Apr 3 - Typography: Physical Art to Digital Art
