Updates about Enhanced Database Ranges.

[Akash Shetye]

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.
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20130820/5f85ed78/attachment.html>