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