Re: GSoC: Adding Histogram Chart Update Week 14

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

 Thu 15 Aug, 2024, 10:29 PM Devansh Varshney, <varshney.devansh614@xxxxxxxxx> wrote:

Thank you so much, Kurt.


I was adding something similar in the chart2/source/controller/chartapiwrapper/DiagramWrapper.cxx -

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@xxxxxxxxxxxxxx> 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@xxxxxxxxx> 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.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.

--
Regards,
Devansh



--
Regards,
Devansh
[Index of Archives]     [LARTC]     [Bugtraq]     [Yosemite Forum]     [Photo]

  Powered by Linux