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 <[email protected]> > 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 >
