Apache OpenOffice (AOO) Bugzilla – Issue 68544
Pivot Report without Format layout ...
Last modified: 2017-05-20 11:11:14 UTC
It seems that Pivot Reports without an auto-format thing have a different layout; causing issues with this guy (attached).
Created attachment 38461 [details] pivot size issue ...
Hi Michael, please describe in more detail what the problem is. I don't understand what you mean. Frank
Ah - nice; it seems this got fixed somehow between 2.0.3 and 2.0.4rc2 - at least, the Win32 build now works for me, I'll re-test with Linux. Thanks.
Urgh; I lied. The bug is however triggered by our patches which refresh the pivot on load [ so the GETPIVOTDATA function will work ]. If you do right-click 'Refresh' on the data-pilot after load; it breaks it - that is the underlying bug :-)
Hi Niklas, the problem seems to be that on a refresh all rows from A5:B36 moves one row up eliminating A4:B4 . Frank
There are two distinct issues that are breaking the layout. 1) 0 is being treated as an 'empty' rather than zero, which loses one row. 2) The header layout that is losing the other row seems to have several significant factors. : The number of col/row/data fields : The 'Classic' table format (the default default value) sets a flag. In the Office Open XML it is called 'gridDropZones' and Office12 sets it via a ui that calls it a compatibility feature. I have not managed to set it with anything other than the Classic autoformat in released versions. It's unclear if this flag is set distinctly somewhere in the xls format (possibly in SXVDEX). Suggested course of action. I've started on the 0 vs empty problem. The main difficulty there is that we're going to need an ODF extension to handle the different semantics without breaking backwards compat.
Here's a patch including XLS import/export and a proposed odf extension. There is still some problems with - load xls - save ods - reload ods but they seem to be different. I'll open a new bug there.
Created attachment 40435 [details] Add ScDPOutput:;HeaderLayout and i/o for odf & xls
Any thoughts here ? It involves ODF changes which need to be proposed sooner rather than later.
The extra row must only be added if there are no column fields. In fact, if there are several data fields, and no column fields except the "data layout" field, we already add a row that Excel only adds with the "Classic" AutoFormat, containing the "Data" field header. You're right that we need a new attribute, but do you think the name "header-grid-layout" still fits, or can you think of a better one?
retarget 2.x -> 3.x
Created attachment 56597 [details] updated patch to take presence of column fields into account
Reset assigne to the default "issues@openoffice.apache.org".