Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi Mario,

Mario Splivalo schrieb:
On 11/03/2013 09:16 PM, Regina Henschel wrote:
I need to create several daily reports on some processes I'm overseeing,
and entering all that data into the Calc spreadsheet is cumbersome - the
report resembles of a tax-return/invoice sheet, where various fields
need to be populated - and I'm looking for a way to automate this.

In which form do you get the data? Perhaps there is nothing like XML
needed, but you can import the data directly.

Well, since I'm getting the data, I can put them in anything I like,
more or less. I just think I remember seeing the XML, that's why I
mentioned it...

Do you want to write macros for Calc or do you want to use another
application that manipulates the .ods file source?

I don't know :) Actually, anything that gets the job done.
If I remember correctly that blog post, author was not mentioning a
separate application, nor modifying the .ods source. But I really do not
remember at this time, that's why I'm asking for a suggestion.

The reason I can't use CSV is because the report is funky-formated -
parts of it can be CVSed, but most of the document can not.

Perhaps you can put it in HTML. If you write that parts, which can be "CVSed" into a table element, you can use these tables as import or linked in Calc.

If you need the other parts of the data too, you can try to write .fods directly. Obviously you now how to work with XML and .fods is a pure XML file. If you save a minimal spreadsheet to Flat XML (.fods) you get all the parts like namespaces, settings, styles, which you can copy simply. So you only need to write the table elements newly.

Kind regards

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.