GSoC: Adding Histogram Chart Update Week 14

[Devansh Varshney <varshney.devansh614@xxxxxxxxx>]

Hi,

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. https://gerrit.libreoffice.org/c/core/+/170909

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.

 [~/libreoffice]
 devansh   ooxml_odf_histogram -  instdir/program/scalc                                                                                               [24/08/15| 2:19PM]
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!
warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for WordPerfect
warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerweb8_writer_template
warn:sfx.dialog:18082:18082:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerglobal8
warn:legacy.osl:18082:18082:sc/source/filter/oox/numberformatsbuffer.cxx:2063: NumberFormatsBuffer::insertBuiltinFormats - locale 'en-IN' not supported (#i29949#)

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
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"
warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong
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"
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"
warn:legacy.osl:18082:18082:sc/source/filter/oox/excelchartconverter.cxx:91: ExcelChartConverter::createDataSequence - cannot create data sequence
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"
warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong
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"
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"
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
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"
warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong
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"
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"
warn:legacy.osl:18082:18082:sc/source/filter/oox/excelchartconverter.cxx:91: ExcelChartConverter::createDataSequence - cannot create data sequence
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"
warn:legacy.osl:18082:18082:chart2/source/tools/OPropertySet.cxx:255: Property type is wrong
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"
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"
warn:legacy.osl:18082:18082:comphelper/source/property/propertycontainerhelper.cxx:402: OPropertyContainerHelper::getFastPropertyValue: unknown handle!
warn:legacy.osl:18082:18082:comphelper/source/property/propertycontainerhelper.cxx:402: OPropertyContainerHelper::getFastPropertyValue: unknown handle!
warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:legacy.tools:18082:18082:svx/source/form/fmvwimp.cxx:436: FmXFormView::~FmXFormView: Window list not empty!
warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:sal.file:18082:18082:sal/osl/unx/file_misc.cxx:659: Invalid file URL
warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?
warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?
warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?
warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?
warn:legacy.osl:18082:18082:sc/source/ui/view/tabvwshh.cxx:234: no accessibility broadcaster?
warn:chart2:18082:18082:chart2/source/tools/LifeTime.cxx:119: This component is already disposed
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:chart2:18082:18082:chart2/source/tools/LifeTime.cxx:119: This component is already disposed
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)
warn:svl.items:18082:18082:svl/source/items/itempool.cxx:386: SfxItemPool::unregisterItemSet: ItemSet was not registered (!)

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

(https://gerrit.libreoffice.org/c/core/+/167068)(closed PR)

Although, we have in the oox/source/drawingml/chart/typegroupconverter.cxx

case TYPECATEGORY_HISTO:

{

aTypeProp.setProperty( PROP_BinCount, mrModel.mnBinCount );

aTypeProp.setProperty( PROP_BinRange, mrModel.maBinRange );

aTypeProp.setProperty( PROP_BinWidth, mrModel.mfBinWidth );

aTypeProp.setProperty( PROP_FrequencyType, mrModel.mnFrequencyType );

aTypeProp.setProperty( PROP_OverflowBin, mrModel.mbOverflowBin );

aTypeProp.setProperty( PROP_UnderflowBin, mrModel.mbUnderflowBin );

}

break;

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.

https://docs.libreoffice.org/xmloff.html
https://docs.libreoffice.org/oox.html
https://wiki.openoffice.org/wiki/Office_Open_XML

https://www.youtube.com/watch?v=ojyyxAtUV2Y

https://www.youtube.com/watch?v=HLX22HS8L8g

--

Regards,

Devansh