Regarding ODF import and Export support for HistogramChart

Devansh Varshney varshney.devansh614 at gmail.com
Mon Jan 13 08:58:21 UTC 2025


[image: image.png]


warn:sal.file:258714:258714:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:sal.file:258714:258714:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:sfx.dialog:258714:258714:sfx2/source/dialog/filtergrouping.cxx:357:
already have an element for WordPerfect
warn:sfx.dialog:258714:258714:sfx2/source/dialog/filtergrouping.cxx:357:
already have an element for writerweb8_writer_template
warn:sfx.dialog:258714:258714:sfx2/source/dialog/filtergrouping.cxx:357:
already have an element for writerglobal8
warn:xmloff:258714:258714:xmloff/source/core/XMLEmbeddedObjectImportContext.cxx:168:
unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0
office:version value=1.3
warn:svx.svdraw:258714:258714:svx/source/unodraw/unoshap4.cxx:306: An
object without client is provided!


warn:xmloff.chart:258714:258714:xmloff/source/chart/SchXMLChartContext.cxx:419:
need a charttype to create a diagram
warn:xmloff.core:258714:258714:xmloff/source/core/xmlimp.cxx:852: No
context for unknown-element
urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0
loext:histogram-configuration
warn:xmloff:258714:258714:xmloff/source/chart/SchXMLPlotAreaContext.cxx:494:
unknown element urn:oasis:names:tc:opendocument:xmlns:chart:1.0
chart:data-point
warn:xmloff.core:258714:258714:xmloff/source/core/xmlimp.cxx:852: No
context for unknown-element
urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0
loext:histogram-configuration

warn:filter.odfflatxml:258714:258714:filter/source/odfflatxml/OdfFlatXml.cxx:206:
 com.sun.star.xml.sax.SAXParseException message:
"[file:///home/devansh/Documents/Untitled%201.fods line 294]: Opening and
ending tag mismatch: plot-a


Getting these while opening the histogramchart.fods file. I'm looking into
these. The build is also successful over Gerrit.


<office:body>
<office:spreadsheet>
<table:calculation-settings table:automatic-find-labels="false"
table:use-regular-expressions="false" table:use-wildcards="true"/>
<table:table table:name="Sheet1" table:style-name="ta1">
<table:shapes>
<draw:frame draw:z-index="0" draw:style-name="gr1" draw:text-style-name="P1"
svg:width="15.999cm" svg:height="8.999cm" svg:x="2.359cm" svg:y="0.1cm">
<draw:object draw:notify-on-update-of-ranges="Sheet1.A1:Sheet1.A5">
<loext:p/>
<office:document xmlns:chartooo="http://openoffice.org/2010/chart"
xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:grddl="
http://www.w3.org/2003/g/data-view#" xmlns:xhtml="
http://www.w3.org/1999/xhtml" xmlns:formx=
"urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="
http://openoffice.org/2005/report" xmlns:dc="
http://purl.org/dc/elements/1.1/" xmlns:chart=
"urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:svg=
"urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:draw=
"urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:text=
"urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:oooc="
http://openoffice.org/2004/calc" xmlns:style=
"urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:ooow="
http://openoffice.org/2004/writer" xmlns:meta=
"urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:xlink="
http://www.w3.org/1999/xlink" xmlns:fo=
"urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:ooo="
http://openoffice.org/2004/office" xmlns:office=
"urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:dr3d=
"urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:table=
"urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:number=
"urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:of=
"urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:calcext=
"urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0"
xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="
http://openoffice.org/2010/draw" xmlns:loext=
"urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0"
xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:field=
"urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:xsd
="http://www.w3.org/2001/XMLSchema" xmlns:math="
http://www.w3.org/1998/Math/MathML" xmlns:form=
"urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script=
"urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:xforms="
http://www.w3.org/2002/xforms" office:version="1.3" office:mimetype=
"application/vnd.oasis.opendocument.chart">
<office:meta><meta:generator>LibreOffice/7.3.7.2$Linux_X86_64
LibreOffice_project/30$Build-2</meta:generator></office:meta>
<office:styles/>
<office:automatic-styles>
<number:number-style style:name="N0">
<number:number number:min-integer-digits="1"/>
</number:number-style>
<style:style style:name="ch1" style:family="chart">
<style:graphic-properties draw:stroke="none"/>
</style:style>
<style:style style:name="ch2" style:family="chart">
<style:chart-properties chart:auto-position="true"/>
<style:graphic-properties draw:stroke="none" svg:stroke-color="#b3b3b3"
draw:fill="none" draw:fill-color="#e6e6e6"/>
<style:text-properties fo:font-size="10pt" style:font-size-asian="10pt"
style:font-size-complex="10pt"/>
</style:style>
<style:style style:name="ch3" style:family="chart">
<style:chart-properties chart:include-hidden-cells="false"
chart:auto-position="true" chart:auto-size="true" chart:treat-empty-cells=
"leave-gap" chart:right-angled-axes="true"/>
</style:style>
<style:style style:name="ch4" style:family="chart" style:data-style-name=
"N0">
<style:chart-properties chart:display-label="true" chart:logarithmic="false"
chart:reverse-direction="false" text:line-break="false"
loext:try-staggering-first="false" chart:link-data-style-to-source="true"
chart:axis-position="0"/>
<style:graphic-properties svg:stroke-color="#b3b3b3"/>
<style:text-properties fo:font-size="10pt" style:font-size-asian="10pt"
style:font-size-complex="10pt"/>
</style:style>
<style:style style:name="ch5" style:family="chart" style:data-style-name=
"N0">
<style:chart-properties chart:display-label="true" chart:logarithmic="false"
chart:reverse-direction="false" text:line-break="false"
loext:try-staggering-first="false" chart:link-data-style-to-source="true"
chart:axis-position="0"/>
<style:graphic-properties svg:stroke-color="#b3b3b3"/>
<style:text-properties fo:font-size="10pt" style:font-size-asian="10pt"
style:font-size-complex="10pt"/>
</style:style>
<style:style style:name="ch6" style:family="chart">
<style:graphic-properties svg:stroke-color="#b3b3b3"/>
</style:style>
<style:style style:name="ch7" style:family="chart" style:data-style-name=
"N0">
<style:chart-properties chart:link-data-style-to-source="true"/>
<style:graphic-properties draw:stroke="none" draw:fill-color="#004586"
dr3d:edge-rounding="5%"/>
<style:text-properties fo:font-size="10pt" style:font-size-asian="10pt"
style:font-size-complex="10pt"/>
</style:style>
<style:style style:name="ch8" style:family="chart">
<style:graphic-properties draw:stroke="solid" svg:stroke-color="#b3b3b3"
draw:fill="none" draw:fill-color="#e6e6e6"/>
</style:style>
<style:style style:name="ch9" style:family="chart">
<style:graphic-properties svg:stroke-color="#b3b3b3" draw:fill-color=
"#cccccc"/>
</style:style>
</office:automatic-styles>
<office:body>
<office:chart>
<chart:chart svg:width="16cm" svg:height="9cm" xlink:href=".." xlink:type=
"simple" chart:class="loext:histogram" chart:style-name="ch1">
<chart:legend chart:legend-position="end" svg:x="13.737cm" svg:y="4.201cm"
style:legend-expansion="high" chart:style-name="ch2"/>
<chart:plot-area chart:style-name="ch3" table:cell-range-address=
"Sheet1.A1:Sheet1.A5" svg:x="0.32cm" svg:y="0.18cm" svg:width="13.097cm"
svg:height="8.64cm">
<chart:coordinate-region svg:x="0.941cm" svg:y="0.379cm" svg:width=
"12.476cm" svg:height="7.794cm"/>
<chart:axis chart:dimension="x" chart:name="primary-x" chart:style-name=
"ch4"/>
<chart:axis chart:dimension="y" chart:name="primary-y" chart:style-name=
"ch5">
<chart:grid chart:style-name="ch6" chart:class="major"/>
</chart:axis>
<chart:series chart:style-name="ch7"
chart:values-cell-range-address="Sheet1.B1:B2"
chart:label-cell-address="Sheet1.A1:A2"
chart:class="loext:histogram">
<chart:data-point chart:repeated="2" />
<loext:histogram-configuration loext:histogram-frequency-type="0" />
</chart:series>
<chart:data-point chart:repeated="5"/>
<loext:histogram-configuration loext:histogram-frequency-type="0"/>
</chart:series>
<chart:wall chart:style-name="ch8"/>
<chart:floor chart:style-name="ch9"/>
</chart:plot-area>
<table:table table:name="local-table">
<table:table-header-columns>
<table:table-column/>
</table:table-header-columns>
<table:table-columns>
<table:table-column/>
</table:table-columns>
<table:table-header-rows>
<table:table-row>
<table:table-cell>
<text:p/>
</table:table-cell>
<table:table-cell office:value-type="string">
<text:p>Column A</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<table:table-row>
<table:table-cell office:value-type="string">
<text:p>1</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="12">
<text:p>12</text:p>
<draw:g>
<svg:desc>Sheet1.A1:Sheet1.A5</svg:desc></draw:g>
</table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell office:value-type="string">
<text:p>2</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="13">
<text:p>13</text:p>
</table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell office:value-type="string">
<text:p>3</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="15">
<text:p>15</text:p>
</table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell office:value-type="string">
<text:p>4</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="16">
<text:p>16</text:p>
</table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell office:value-type="string">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="10">
<text:p>10</text:p>
</table:table-cell>
</table:table-row>
</table:table-rows>
</table:table>
</chart:chart>
</office:chart>
</office:body>
</office:document>

On Sun, 5 Jan 2025 at 19:48, Devansh Varshney <varshney.devansh614 at gmail.com>
wrote:

> This is wrong:
>> chart:class="chart:histogram"
>> "histogram" does not belong to the chart types that are predefined in
>> the ODF standard. Only the names of the predefined chart types may have
>> a prefix "chart". For chart types not defined in the standard you have
>> to use a prefix different from "chart". For chart types defined by
>> LibreOffice use the prefix "loext".
>> So it should be
>> chart:class="loext:histogram"
>> in both cases.
>
> You're I have right corrected this. silly mistake.
>
> This is wrong:
>> <loext:histogram-configuration loext:histogram-frequency-type="0"
>>                                 loext:histogram-bin-count=""
>>                                 loext:histogram-overflow-bin=""
>>                                 loext:histogram-underflow-bin=""
>>                                 loext:histogram-interval-closed="true"/>
>>
>> If an attribute does not exist, you simple omit the attribute.
>> (Precondition it is set as 'optional' in the schema, as it is in your
>> case.) So the element would be
>> <loext:histogram-configuration loext:histogram-frequency-type="0"
>>                                 loext:histogram-interval-closed="true"/>
>
>
> done.
>
>
>  ✘  devansh   odf_histogram  instdir/program/scalc
>
>    [25/01/5| 7:39PM]
> warn:vcl.schedule:541381:541381:vcl/source/app/scheduler.cxx:639: Stop the
> task before changing the priority, as it will just change after the task
> was scheduled with the old prio!
> warn:sfx.dialog:541381:541381:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for WordPerfect
> warn:sfx.dialog:541381:541381:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for writerweb8_writer_template
> warn:sfx.dialog:541381:541381:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for writerglobal8
> warn:xmloff.chart:541381:541381:xmloff/source/chart/SchXMLChartContext.cxx:419:
> need a charttype to create a diagram
> warn:xmloff.core:541381:541381:xmloff/source/core/xmlimp.cxx:852: No
> context for unknown-element
> urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0
> loext:histogram-configuration
> warn:sal.file:541381:541381:sal/osl/unx/file_misc.cxx:659: Invalid file URL
> warn:sal.file:541381:541381:sal/osl/unx/file_misc.cxx:659: Invalid file URL
>
>
> [image: image.png]
> still opening as Column chart looking into this.(My make build is having
> some trouble )
>
>
> On Sun, 5 Jan 2025 at 19:10, Regina Henschel <rb.henschel at t-online.de>
> wrote:
>
>> Hi Devansh,
>>
>> This is wrong:
>> chart:class="chart:histogram"
>>
>> "histogram" does not belong to the chart types that are predefined in
>> the ODF standard. Only the names of the predefined chart types may have
>> a prefix "chart". For chart types not defined in the standard you have
>> to use a prefix different from "chart". For chart types defined by
>> LibreOffice use the prefix "loext".
>> So it should be
>> chart:class="loext:histogram"
>> in both cases.
>>
>> This is wrong:
>> <loext:histogram-configuration loext:histogram-frequency-type="0"
>>                                 loext:histogram-bin-count=""
>>                                 loext:histogram-overflow-bin=""
>>                                 loext:histogram-underflow-bin=""
>>                                 loext:histogram-interval-closed="true"/>
>>
>> If an attribute does not exist, you simple omit the attribute.
>> (Precondition it is set as 'optional' in the schema, as it is in your
>> case.) So the element would be
>> <loext:histogram-configuration loext:histogram-frequency-type="0"
>>                                 loext:histogram-interval-closed="true"/>
>>
>> Kind regards,
>> Regina
>>
>
>
> --
> *Regards,*
> *Devansh*
>


-- 
*Regards,*
*Devansh*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20250113/0c8248df/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 1049315 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20250113/0c8248df/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 314532 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20250113/0c8248df/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled 1.fods
Type: application/vnd.oasis.opendocument.spreadsheet-flat-xml
Size: 61605 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20250113/0c8248df/attachment-0001.bin>


More information about the LibreOffice mailing list