GSoC: Adding Histogram Chart Update Week 14

Devansh Varshney varshney.devansh614 at gmail.com
Thu Aug 15 21:08:10 UTC 2024 

 Thu 15 Aug, 2024, 10:29 PM Devansh Varshney, <varshney.devansh614 at gmail.com>
wrote:

>
Thank you so much, Kurt.
>


> I was adding something similar in the
> chart2/source/controller/chartapiwrapper/DiagramWrapper.cxx -
>
> [image: image.png]
>


> Somewhat like what you did in
> chart2/source/model/main/DataPointProperties.cxx.
>


> But, maybe now I can get this working, :) thank you for pointing me to the
> PR.
>
>
>
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>



--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> A summary of opening a Histogram XLSX file - (which I am looking into)
>


> Unknown properties: The errors indicate that properties like "BinCount",
> "OverflowBin", and "UnderflowBin" are not recognized:
>
> PropertySet::implSetPropertyValue - cannot set property "BinCount" com.sun.star.beans.UnknownPropertyException
> PropertySet::implSetPropertyValue - cannot set property "OverflowBin" com.sun.star.beans.UnknownPropertyException
> PropertySet::implSetPropertyValue - cannot set property "UnderflowBin" com.sun.star.beans.UnknownPropertyException
>
>
> Property type issues:
> Property type is wrong
>
> Data sequence creation failure:
> ExcelChartConverter::createDataSequence - cannot create data sequence
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------
>


> warn:legacy.osl:85610:85610:sc/source/filter/oox/numberformatsbuffer.cxx:2063:
> NumberFormatsBuffer::insertBuiltinFormats - locale 'en-IN' not supported
> (#i29949#)
> warn:svx:85610:85610: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:85610:85610: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:85610:85610:chart2/source/tools/OPropertySet.cxx:255:
> Property type is wrong
> warn:oox:85610:85610: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:85610:85610: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:85610:85610:sc/source/filter/oox/excelchartconverter.cxx:91:
> ExcelChartConverter::createDataSequence - cannot create data sequence
> warn:oox:85610:85610: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:85610:85610:chart2/source/tools/OPropertySet.cxx:255:
> Property type is wrong
> warn:oox:85610:85610: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:85610:85610: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:85610:85610: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:85610:85610: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:85610:85610:chart2/source/tools/OPropertySet.cxx:255:
> Property type is wrong
> warn:oox:85610:85610: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:85610:85610: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:85610:85610:sc/source/filter/oox/excelchartconverter.cxx:91:
> ExcelChartConverter::createDataSequence - cannot create data sequence
> warn:oox:85610:85610: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:85610:85610:chart2/source/tools/OPropertySet.cxx:255:
> Property type is wrong
> warn:oox:85610:85610: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:85610:85610: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"
>
> On Thu, 15 Aug 2024 at 21:40, Kurt Nordback <kurt.nordback at protonmail.com>
> wrote:
>
>> Hi Devansh. I just submitted code to input a parameter from OOXML to the
>> chart handling, so you might want to look at my changes here:
>> https://gerrit.libreoffice.org/c/core/+/171879
>>
>> I also did a more extensive change including input and output to/from
>> both OOXML and ODF here: https://gerrit.libreoffice.org/c/core/+/170666/9
>>
>> I will say I'm still learning this area myself so I can't guarantee that
>> the way I'm handling this is the *best*​ way, but it seems to work. So
>> these might provide a model for how you could do the property-passing.
>>
>> Kurt
>> On Thursday, August 15th, 2024 at 8:43 AM, Devansh Varshney <
>> varshney.devansh614 at gmail.com> wrote:
>>
>> 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*
>>
>>
>>
>
> --
> *Regards,*
> *Devansh*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240816/f00b5b78/attachment-0001.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/20240816/f00b5b78/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 304718 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240816/f00b5b78/attachment-0003.png>

More information about the LibreOffice mailing list