GSoC: Adding Histogram Chart Update Week 14

Thu Aug 15 14:43:48 UTC 2024

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.
[image: image.png]

 [~/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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240815/a94b25ec/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 159468 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240815/a94b25ec/attachment.png>