Fwd: Updates about Enhanced Database Ranges.

---------- Forwarded message ----------
From: Akash Shetye <shetyeakash@gmail.com>
Date: Thu, Aug 15, 2013 at 8:16 PM
Subject: Re: Updates about Enhanced Database Ranges.
To: Akash Shetye <shetyeakash@gmail.com>


Hello all,

Updating everyone about the branch's progress after a long long time. I
have managed to get done the import and export of table styles and tables
from .xlsx back to .xlsx from LO. LO now supports the import of table
styles but there is nothing in place about the export to Open Document
Format of these table styles. Currently I am swimming around the rendering
codeand should be getting on with something to show pretty soon like in a 3
days.
What follows after that is the making of rendering code that actually works
when when you reposition tables etc but that is something to worry about
after the initial rendering is done. Also dialog and much UI stuff is way
pending. See you next week.


On Thu, Jul 25, 2013 at 1:39 AM, Akash Shetye <shetyeakash@gmail.com> wrote:

> Hello
> I have completed the table style export to OOXML just yesterday however
> the code needs a lot of ironing out.
>
> About exporting the tables to open document format. The tables created in
> excel are available in the xlsx zip at /tables/table#.xml where # is the
> number of the table defined in excel so if you define 4 tables., you will
> have 4 xml files in there one each.
>
> This data is parsed and successfully imported into calc. I spoke with
> markus some time ago about exporting table styles to open document. He
> mentioned writing a rfc or something later on for that so that is on hold.
>
> The export to excel of these db ranges will be done only for those db
> ranges that use any table formatting. This should not be that difficult, I
> realised that this only involves searching through the ScDBData collection
> and identifying the ranges that have formatting and writing the xml for
> them in /tables/..
>
> Even if db ranges are stored as expressions or anything in calc, they will
> be easily exportable to excel. I think we will not have to worry about
> that. Once thats done full excel support for table styles will be achieved.
>
> I will push that soon.