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
>
>
Save_3_LibreOffice.bas
Description: Binary data
_______________________________________________ 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
