Updates about Enhanced Database Ranges.

[Akash Shetye]

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