[Discussion] [OOXML] Shall we keep all cellStyles from xlsx or not

[bjcheny <co...@gmail.com>]

Hi guys,

I am fixing bug 120619, which is about Aoo takes too long time to open xlsx
file.
The root cause is that sample file has up to 28380 cellStyles/cellStyleXfs,
though nearly no reference to them at all.
https://issues.apache.org/ooo/show_bug.cgi?id=120619

A question came up when I tried to figure out a solution:
Shall we set a limitation here?
When we export xls file by Aoo, there is a limitation of 4050. It seems
reasonable because MS 2003 Excel can't support too many cellStyles.
It can be proved by indication provided by MS 2007 Excel when you save
sample xslx as xls, as attached pic.

Thus, I really need your opinions. Or can there be a better solution?

Regards

Re: [Discussion] [OOXML] Shall we keep all cellStyles from xlsx or not

[bjcheny <co...@gmail.com>]

As I checked, if there are also too many kinds of cellStyles in ods, it
will also take several minutes to open the ods file.


2012/8/30 bjcheny <co...@gmail.com>

> Hi guys,
>
> I am fixing bug 120619, which is about Aoo takes too long time to open
> xlsx file.
> The root cause is that sample file has up to 28380
> cellStyles/cellStyleXfs, though nearly no reference to them at all.
> https://issues.apache.org/ooo/show_bug.cgi?id=120619
>
> A question came up when I tried to figure out a solution:
> Shall we set a limitation here?
> When we export xls file by Aoo, there is a limitation of 4050. It seems
> reasonable because MS 2003 Excel can't support too many cellStyles.
> It can be proved by indication provided by MS 2007 Excel when you save
> sample xslx as xls, as attached pic.
>
> Thus, I really need your opinions. Or can there be a better solution?
>
>  Regards
>

Re: [Discussion] [OOXML] Shall we keep all cellStyles from xlsx or not

[Ying Zhang <tl...@gmail.com>]

I think we should not have such limitation of 4050 like MS binary file
format, it sounds like a workaround for performance improvement, and MS
2007/2010 have more improvement, we should improve the AOO's capacity to
interop with MS Office 2007/2010 further.  And also for the first, could we
find the key problems from technical view for low performance. Then find
solutions for performance improvement.

2012/8/30 bjcheny <co...@gmail.com>

> Hi guys,
>
> I am fixing bug 120619, which is about Aoo takes too long time to open
> xlsx file.
> The root cause is that sample file has up to 28380
> cellStyles/cellStyleXfs, though nearly no reference to them at all.
> https://issues.apache.org/ooo/show_bug.cgi?id=120619
>
> A question came up when I tried to figure out a solution:
> Shall we set a limitation here?
> When we export xls file by Aoo, there is a limitation of 4050. It seems
> reasonable because MS 2003 Excel can't support too many cellStyles.
> It can be proved by indication provided by MS 2007 Excel when you save
> sample xslx as xls, as attached pic.
>
> Thus, I really need your opinions. Or can there be a better solution?
>
>  Regards
>