Issue 68544 - Pivot Report without Format layout ...
Summary: Pivot Report without Format layout ...
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 680m180
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on: 62494
  Show dependency tree
Reported: 2006-08-11 15:06 UTC by mmeeks
Modified: 2017-05-20 11:11 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

pivot size issue ... (925.00 KB, application/
2006-08-11 15:09 UTC, mmeeks
no flags Details
Add ScDPOutput:;HeaderLayout and i/o for odf & xls (24.18 KB, patch)
2006-11-08 14:43 UTC, jodygoldberg
no flags Details | Diff
updated patch to take presence of column fields into account (21.48 KB, patch)
2008-09-18 06:43 UTC, kyoshida
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description mmeeks 2006-08-11 15:06:16 UTC
It seems that Pivot Reports without an auto-format thing have a different
layout; causing issues with this guy (attached).
Comment 1 mmeeks 2006-08-11 15:09:32 UTC
Created attachment 38461 [details]
pivot size issue ...
Comment 2 frank 2006-09-19 14:01:30 UTC
Hi Michael,

please describe in more detail what the problem is. I don't understand what you

Comment 3 mmeeks 2006-09-20 11:01:35 UTC
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.
Comment 4 mmeeks 2006-09-20 12:43:34 UTC
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 :-)
Comment 5 frank 2006-09-25 14:53:20 UTC
Hi Niklas,

the problem seems to be that on a refresh all rows from A5:B36 moves one row up
eliminating A4:B4 .

Comment 6 jodygoldberg 2006-10-06 14:17:02 UTC
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

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.
Comment 7 jodygoldberg 2006-11-08 14:41:36 UTC
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.
Comment 8 jodygoldberg 2006-11-08 14:43:37 UTC
Created attachment 40435 [details]
Add ScDPOutput:;HeaderLayout and i/o for odf & xls
Comment 9 jodygoldberg 2006-12-01 18:48:15 UTC
Any thoughts here ?
It involves ODF changes which need to be proposed sooner rather than later.
Comment 10 niklas.nebel 2006-12-15 19:01:12 UTC
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?
Comment 11 niklas.nebel 2007-12-04 18:07:15 UTC
retarget 2.x -> 3.x
Comment 12 kyoshida 2008-09-18 06:43:42 UTC
Created attachment 56597 [details]
updated patch to take presence of column fields into account
Comment 13 Marcus 2017-05-20 11:11:14 UTC
Reset assigne to the default "".