Charleve, The attachment I added was a PLAIN TEXT Basic Source file. I copy / pasted the source from my workbook into my score text editor, saved it and attached the saved file.
If you got some sort of binary file, let me know. What virus scanner are you using? Does your virus scanner get upset just because it sees .bas as an extension? I can rename the file as a .txt if it will keep the peace. Wes On Feb 19, 2013 12:11 PM, "Charlene Hosein" <[email protected]> wrote: > 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]> > 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 > >
_______________________________________________ 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
