Re: Updates about Enhanced Database Ranges.

Here is what I have done and what I will be doing.

Last week:
-Wrote the calculation part for rendering.
-Wrote a failing stub fro using this calculation and setting the style
sheet.
-Looked at the rendering of statically formatted cells (by applying style
sheets).

This week:
-Get done with the rendering for once.
-Optimise calculation code.
-Why are some tests failing..investigate the sw_subsequentexport test.


On Fri, Aug 16, 2013 at 3:29 AM, Akash Shetye <shetyeakash@gmail.com> wrote:

> ---------- 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.