Hi Stephan,
On 01/07/11 10:00, Stephan Zietsman wrote:
I've had a look at the spreadsheet, and tried a few formulas. It
seems that to do this with formulas is quite tricky and unfortunately
I couldn't get it done. I tried a few different approaches and I
think it is technically possible. However, I also think that it would
take quite some time to write such a formula (if it is indeed
possible).
As was mentioned before, it can be done with macros. Would you
consider using a macro instead?
Continued thanks for all your efforts. If I could whip up a macro like
buttered toast I'd do so, but unfortunately for me that would first
involve giving myself a grounding in writing bespoke LO macros. I can
however write a bit of Perl, and I've started trying to tackle the
problem that way :-) Although I think I'll have to finish the current
batch by hand for now, because unlike writing code at least that has a
definite end point...
LO macros would definitely be a good skill to learn eventually, even if
it's not at the top of my todo list at the moment. I haven't yet
searched for any tutorials or the like, but I'd be interested to hear if
you have any personal favourites which you think would suit someone who
knows general programming and just needs an intro to the syntax,
conventions and frameworks / objects involved in LO scripting.
That said, I've noticed there are at least four different languages one
can use. I don't know if any of them would allow writing scripts which
are broadly cross-compatible with other office suites (even if a little
tweaking is needed) but my preference would be for that, so I could help
non-LO-using friends and such.
Thanks again and best regards,
--Ryan
--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
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