<chart:chart svg:width="16.001cm" svg:height="8.986cm" xlink:href=".."
chart:class="chart-type">
<chart:title>
<text:p>Histogram Chart</text:p>
</chart:title>
<chart:plot-area>
<chart:series chart:label-cell-address="'Sheet1'.$A$1:Sheet1.$A$1"
chart:values-cell-range-address="'Sheet1'.$A$2:Sheet1.$A$101"
style:style-name="ch6">
<chart:data-point chart:repeated="100"/>
<loext:histogram-configuration
loext:histogram-frequency-type="2"
loext:histogram-bin-count="10"
loext:histogram-overflow-bin="60"
loext:histogram-underflow-bin="0"
loext:histogram-interval-closed="true"/>
</chart:series>
<chart:axis chart:dimension="x">
<chart:title>
<text:p>Values (units)</text:p>
</chart:title>
</chart:axis>
<chart:axis chart:dimension="y">
<chart:title>
<text:p>Frequency</text:p>
</chart:title>
</chart:axis>
</chart:plot-area></chart:chart>
https://gerrit.libreoffice.org/c/core/+/177364/19/schema/libreoffice/OpenDocument-v1.4%252Blibreoffice-schema.rng
But I think in the PR we have only one <choice> block.
I am trying to edit the column chart ods file(content.xml)
On Sat, 4 Jan 2025 at 03:54, Regina Henschel <rb.hensc...@t-online.de>
wrote:
> Hi Devansh,
>
> Devansh Varshney schrieb am 03.01.2025 um 15:08:
> > <chart:chart svg:width="16.001cm" svg:height="8.986cm" xlink:href="..">
> > <chart:title>
> > <text:p>Histogram Chart</text:p>
> > </chart:title>
> > <chart:plot-area>
> > <chart:series chart:label-cell-address="'Sheet1'.$A$1"
> > chart:values-cell-range-address="'Sheet1'.$A$2:$A$101">
> > <chart:data-point chart:repeated="100"/>
> > <loext:histogram-configuration
> > loext:histogram-frequency-type="2"
> > loext:histogram-bin-count="10"
> > loext:histogram-overflow-bin="60"
> > loext:histogram-underflow-bin="0"
> > loext:histogram-interval-closed="true"/>
> > </chart:series>
> > <chart:axis chart:dimension="x">
> > <chart:title>
> > <text:p>Values (units)</text:p>
> > </chart:title>
> > </chart:axis>
> > <chart:axis chart:dimension="y">
> > <chart:title>
> > <text:p>Frequency</text:p>
> > </chart:title>
> > </chart:axis>
> > </chart:plot-area>
> > </chart:chart>
> >
> > I hope this time it's correct :)
>
> That will work. However, LibreOffice will write
> "Sheet1.$A$1:Sheet1.$A$1" and LibreOffice will copy the chart:class
> attribute from the <chart:chart> element to the <chart:series> element.
> And the <chart:series> element will have an attribute
> style:style-name="ch6" (or other number).
>
> Now you know, how the exported file should look. Thus you can manually
> change an existing file (e.g a column chart) so, that it becomes a
> histogram chart. When you manipulate a file, make at least sure, that
> there is no XML-error. An XML editor should take care of that.
> Having such file allows you to test the import without having the export
> finished.
>
> The current state of OpenDocument-v1.4+libreoffice-schema.rng is going
> to correspond to this markup solution. But your schema has still the
> error, that the part for the frequency types has two blocks instead of
> one block with one <choice>.
>
>
>
> The above solution uses for the histogram configuration a child element
> of the <chart:series> element. Since this
> <loext:histogram-configuration> element has only attributes but no child
> elements, it would also be possible to use a solution where the
> histogram configuration is part of the style.
> I can't say, whether exporting and importing such a markup would be more
> complicated or easier. I would have to study the existing code just as
> you before I could give you a qualified advice. If you are still
> interested in such a version, I can provide you with details.
>
> Kind regards,
> Regina
>
>
--
*Regards,*
*Devansh*
