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".