Re: Updates about Enhanced Database Ranges.

What I managed to get done:

-Optimise calculation code.
-Figure out and code the pBackground stuff from FillInfo() but coding
it is still work in progress like its almost over with pushing that
soon.
-Ignore the failing test case.
-Learn from Kohei's latest patches.

What I will get done in 2 days time:
-Rendering would be done with.
-Stripe size import export.

Whats to be done this week:
-Frond end UI for all this.
-Polish some sloppy coding in import/export I have identified.
-More to be added here


On 8/20/13, Akash Shetye <shetyeakash@gmail.com> wrote:
> 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.