Harold Fuchs wrote:
> > Not using a Calc macro. If it were me I'd export the sheet as a CSV file, > write a Perl script to generate a new [correctly formatted] CSV file and > import that into a new sheet. I doubt a suitable Perl script would be more > than about 10 lines of *un*obfuscated code. > Hi Harold, Yeah, I was considering that option. There are roughly 25,000 entries and about a dozen fields involved. I use (Un)Icon rather than Perl and there may or may not be unicode issues involved. (Un)Icon doesn't support unicode but no unicode characters would be involved in anything more than copying. I never learnt Perl (since I could always use Unicon). I'll certainly consider this option if no purely OOo solution is available. Thanks for the hint. Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
