<div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Hi,</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">The problem which I am currently stuck at is unable to set the properties in-order to get the LO to be able to save and open the Histogram file, i.e., OOXML(currently)/ODF import/export. <a href="https://gerrit.libreoffice.org/c/core/+/170909">https://gerrit.libreoffice.org/c/core/+/170909</a></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">As of now the histogram XSLS file which I saved in LO being opened in the LO dev and can be seen in the image that it's reading(opening) properties incorrectly. Also missing the details like the Bin-Range and X-Axis binning data.<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><img src="cid:ii_lzvd1i1v0" alt="image.png" width="578" height="431"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"> [~/libreoffice]<br> devansh   ooxml_odf_histogram -  instdir/program/scalc                                                                                               [24/08/15| 2:19PM]<br>warn:vcl.schedule:18082:18082: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!<br>warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for WordPerfect<br>warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerweb8_writer_template<br>warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerglobal8<br>warn:legacy.osl:18082:18082:sc/source/filter/oox/numberformatsbuffer.cxx:2063: NumberFormatsBuffer::insertBuiltinFormats - locale 'en-IN' not supported (#i29949#)<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">warn:svx:18082:18082:svx/source/unodraw/unoshape.cxx:1706: DBG_UNHANDLED_EXCEPTION in setPropertyValues exception: com.sun.star.beans.UnknownPropertyException message: "GraphicColorMode at /home/devansh/libreoffice/svx/source/unodraw/unoshape.cxx:1508" context: SvxOle2Shape<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "BinCount" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "OverflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "UnderflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:sc/source/filter/oox/excelchartconverter.cxx:91: ExcelChartConverter::createDataSequence - cannot create data sequence<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "BinCount" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "OverflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "UnderflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:svx:18082:18082:svx/source/unodraw/unoshape.cxx:1706: DBG_UNHANDLED_EXCEPTION in setPropertyValues exception: com.sun.star.beans.UnknownPropertyException message: "GraphicColorMode at /home/devansh/libreoffice/svx/source/unodraw/unoshape.cxx:1508" context: SvxOle2Shape<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "BinCount" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "OverflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "UnderflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:sc/source/filter/oox/excelchartconverter.cxx:91: ExcelChartConverter::createDataSequence - cannot create data sequence<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "BinCount" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "OverflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:oox:18082:18082:oox/source/helper/propertyset.cxx:135: PropertySet::implSetPropertyValue - cannot set property "UnderflowBin" com.sun.star.beans.UnknownPropertyException message: "-1 at /home/devansh/libreoffice/cppuhelper/source/propshlp.cxx:491"<br>warn:legacy.osl:18082:18082:comphelper/source/property/propertycontainerhelper.cxx:402: OPropertyContainerHelper::getFastPropertyValue: unknown handle!<br>warn:legacy.osl:18082:18082:comphelper/source/property/propertycontainerhelper.cxx:402: OPropertyContainerHelper::getFastPropertyValue: unknown handle!<br>warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL<br>warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL<br>warn:legacy.tools:18082:18082:svx/source/form/fmvwimp.cxx:436: FmXFormView::~FmXFormView: Window list not empty!<br>warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL<br>warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL<br>warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?<br>warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?<br>warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?<br>warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?<br>warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?<br>warn:chart2:18082:18082:chart2/source/tools/LifeTime.cxx:119: This component is already disposed <br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:chart2:18082:18082:chart2/source/tools/LifeTime.cxx:119: This component is already disposed <br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br>warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)<br></div><br><br><div style="font-family:comic sans ms,sans-serif" class="gmail_default">The warnings you're seeing are due to the system attempting to set properties (BinCount, OverflowBin, UnderflowBin, etc.) that it doesn't recognize or that haven't been properly registered or exposed in the relevant UNO interfaces tho we have offapi/com/sun/star/chart/HistogramDiagram.idl <br></div><div style="font-family:comic sans ms,sans-serif" class="gmail_default">(<a href="https://gerrit.libreoffice.org/c/core/+/167068)(closed">https://gerrit.libreoffice.org/c/core/+/167068)(closed</a> PR)<br></div><br><div style="font-family:comic sans ms,sans-serif" class="gmail_default">Although, we have in the oox/source/drawingml/chart/typegroupconverter.cxx<br><br><div style="color:rgb(204,204,204);background-color:rgb(31,31,31);font-family:"Droid Sans Mono","monospace",monospace;font-weight:normal;font-size:14px;line-height:19px;white-space:pre"><div><span style="color:rgb(204,204,204)">            </span><span style="color:rgb(197,134,192)"><br></span></div><div><span style="color:rgb(197,134,192)">            case</span><span style="color:rgb(204,204,204)"> TYPECATEGORY_HISTO:</span></div><div><span style="color:rgb(204,204,204)">            {</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_BinCount, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">mnBinCount</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_BinRange, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">maBinRange</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_BinWidth, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">mfBinWidth</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_FrequencyType, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">mnFrequencyType</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_OverflowBin, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">mbOverflowBin</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">                </span><span style="color:rgb(156,220,254)">aTypeProp</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(220,220,170)">setProperty</span><span style="color:rgb(204,204,204)">( PROP_UnderflowBin, </span><span style="color:rgb(156,220,254)">mrModel</span><span style="color:rgb(204,204,204)">.</span><span style="color:rgb(156,220,254)">mbUnderflowBin</span><span style="color:rgb(204,204,204)"> );</span></div><div><span style="color:rgb(204,204,204)">            }</span></div><div><span style="color:rgb(204,204,204)">            </span><span style="color:rgb(197,134,192)">break</span><span style="color:rgb(204,204,204)">;</span></div><div><span style="color:rgb(204,204,204)"><br></span></div></div></div><div><br></div><div><div style="font-family:comic sans ms,sans-serif" class="gmail_default">What do I really look for as my mentor Tomaz said it's a simple straight-up task yet I am getting there really slow.<br></div><br></div><div><div style="font-family:comic sans ms,sans-serif" class="gmail_default"><a href="https://docs.libreoffice.org/xmloff.html">https://docs.libreoffice.org/xmloff.html</a><br><a href="https://docs.libreoffice.org/oox.html">https://docs.libreoffice.org/oox.html</a><br><a href="https://wiki.openoffice.org/wiki/Office_Open_XML">https://wiki.openoffice.org/wiki/Office_Open_XML</a><br><br><a href="https://www.youtube.com/watch?v=ojyyxAtUV2Y" class="gmail-waffle-rich-text-link" style="font-size:13px;color:rgb(17,85,204);font-weight:normal;text-decoration:underline;font-family:"Arial";font-style:normal">https://www.youtube.com/watch?v=ojyyxAtUV2Y</a><br><br><a href="https://www.youtube.com/watch?v=HLX22HS8L8g" class="gmail-waffle-rich-text-link" style="font-size:13px;color:rgb(17,85,204);font-weight:normal;text-decoration:underline;font-family:"Arial";font-style:normal">https://www.youtube.com/watch?v=HLX22HS8L8g</a></div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="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></div>