GSoC: Adding Histogram Chart Update Week 14

Devansh Varshney varshney.devansh614 at gmail.com
Sun Aug 18 16:35:41 UTC 2024


This is what I am getting while opening the ods Histogram file -
warn:legacy.osl:44953:44953:chart2/source/tools/LegendHelper.cxx:96: need
diagram for creation of legend
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:chart2.tools:44953:44953:chart2/source/tools/WrappedPropertySet.cxx:92:
found no inner property set to map to
warn:legacy.osl:44953:44953:chart2/source/controller/chartapiwrapper/LegendWrapper.cxx:366:
LegendWrapper::getInnerPropertySet() is NULL
warn:chart2.tools:44953:44953:chart2/source/tools/WrappedPropertySet.cxx:92:
found no inner property set to map to



[image: image.png]


Saving and opening is functioning for the XLSX, but it is not working
correctly.-
[image: image.png]

https://gerrit.libreoffice.org/c/core/+/170909

On Sun, 18 Aug 2024 at 20:14, Devansh Varshney <
varshney.devansh614 at gmail.com> wrote:

> Hi everyone,
>
> Kurt's help provided(https://gerrit.libreoffice.org/c/core/+/170666/9) me
> that what should I be looking for and further validated that the changes
> regarding the OOXML import/export are in right direction.
> https://gerrit.libreoffice.org/c/core/+/170909
>
> But, I couldn't figure out how the properties are being set(or what Kurt
> said- "*changes are needed to pass the data down to the rendering in the
> model-view-controller code.*")
>
> as I am still getting errors regarding the UNO API while opening the XLSX
> histogram file -
>
> Unknown properties: The errors indicate that properties like "BinCount",
> "OverflowBin", and "UnderflowBin" are not
> recognized:warn:sfx.dialog:26109:26109:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for WordPerfect
> warn:sfx.dialog:26109:26109:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for writerweb8_writer_template
> warn:sfx.dialog:26109:26109:sfx2/source/dialog/filtergrouping.cxx:357:
> already have an element for writerglobal8
> warn:legacy.osl:26109:26109:sc/source/filter/oox/numberformatsbuffer.cxx:2063:
> NumberFormatsBuffer::insertBuiltinFormats - locale 'en-IN' not supported
> (#i29949#)
> warn:svx:26109:26109: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:svx:26109:26109:svx/source/unodraw/unoshape.cxx:1706:
> DBG_UNHANDLED_EXCEPTION in setPropertyValues exception:
> com.sun.star.beans.UnknownPropertyException message: "Representation at
> /home/devansh/libreoffice/svx/source/unodraw/unoshape.cxx:1508" context:
> SvxOle2Shape
> warn:legacy.osl:26109:26109:sc/source/filter/oox/excelchartconverter.cxx:91:
> ExcelChartConverter::createDataSequence - cannot create data sequence
> warn:legacy.osl:26109:26109:comphelper/source/property/propertycontainerhelper.cxx:402:
> OPropertyContainerHelper::getFastPropertyValue: unknown handle!
> warn:legacy.tools:26109:26109:svx/source/form/fmvwimp.cxx:436:
> FmXFormView::~FmXFormView: Window list not empty!
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------
> while saving the Histogram Chart file as xlsx -
>
> warn:legacy.osl:25495:25495:sc/source/filter/excel/xlchart.cxx:537:
> XclChTypeInfoProvider::GetTypeInfoFromService - unknown service name
> warn:legacy.osl:25495:25495:sc/source/filter/excel/xeformula.cxx:511:
> XclExpFmlaCompImpl::CreateFormula - empty token array
> warn:legacy.osl:25495:25495:sc/source/filter/excel/xechart.cxx:2621:
> XclExpChLabelRange::Convert - cannot get base time unit
> warn:legacy.osl:25495:25495:sc/source/filter/excel/xlchart.cxx:537:
> XclChTypeInfoProvider::GetTypeInfoFromService - unknown service name
> warn:xmloff:25495:25495:xmloff/source/text/XMLTextListAutoStylePool.cxx:161:
> getStyleFamilies() from XModel failed for export!
> warn:xmloff:25495:25495:xmloff/source/text/XMLTextListAutoStylePool.cxx:161:
> getStyleFamilies() from XModel failed for export!
> warn:xmloff:25495:25495:xmloff/source/text/XMLTextListAutoStylePool.cxx:161:
> getStyleFamilies() from XModel failed for export!
> warn:sc:25495:25495:sc/source/ui/unoobj/chart2uno.cxx:2239:
> convertRangeToXML throw IllegalArgumentException from input of: values-y
> warn:xmloff:25495:25495:xmloff/source/core/xmlerror.cxx:162: An error or a
> warning has occurred during XML import/export!
> Error-Id: 0x60040004
>     Flags: 6 ERROR SEVERE
>     Class: 4 API
>     Number: 4
> Parameters:
> Exception-Message: com.sun.star.lang.IllegalArgumentException: "at
> /home/devansh/libreoffice/sc/source/ui/unoobj/chart2uno.cxx:2240"
>
> warn:legacy.osl:25495:25495:sax/source/expatwrap/saxwriter.cxx:134: cached
> Sequence not written
>
>
>
>
>
> Further, I also made entry for the MS Office like Format Axis option for
> the Histogram Chart(which are commented as of now and also some changes
> regarding ODF import/export are also commented)
>
> [image: image.png]
>
> SideBar UI area is shown below the chart Image -
> [image: image.png]
>
> in the files -
>
> *chart2/uiconfig/ui/sidebartype.ui*
>
> *chart2/source/controller/dialogs/ChartTypeDialogController.cxx*
>
> private:
> DECL_LINK(ChangeBinWidthHdl, weld::SpinButton&, void);
> DECL_LINK(ChangeBinCountHdl, weld::SpinButton&, void);
> DECL_LINK(ChangeOverflowBinHdl, weld::Toggleable&, void);
> DECL_LINK(ChangeUnderflowBinHdl, weld::Toggleable&, void);
> DECL_LINK(ChangeBinRangeHdl, weld::Entry&, void);
>
> std::unique_ptr<weld::Label> m_xFT_BinWidth;
> std::unique_ptr<weld::SpinButton> m_xMF_BinWidth;
> std::unique_ptr<weld::Label> m_xFT_BinCount;
> std::unique_ptr<weld::SpinButton> m_xMF_BinCount;
> std::unique_ptr<weld::Label> m_xFT_OverflowBin;
> std::unique_ptr<weld::CheckButton> m_xCB_OverflowBin;
> std::unique_ptr<weld::Label> m_xFT_UnderflowBin;
> std::unique_ptr<weld::CheckButton> m_xCB_UnderflowBin;
> std::unique_ptr<weld::Label> m_xFT_BinRange;
> std::unique_ptr<weld::Entry> m_xMF_BinRange;
>
> perhaps have to *revert the entry* for the *BinRange* as this is only
> related to the OOXML.
>
>
> https://gerrit.libreoffice.org/c/core/+/170909 PR
>
>
> On Sat, 17 Aug 2024 at 00:41, Kurt Nordback <kurt.nordback at protonmail.com>
> wrote:
>
>> Glad to help out if I can.
>>
>> I'm not certain about this, but my understanding is the DiagramWrapper
>> properties are for the UNO API. Your histogram support should go in the
>> API, so changes to DiagramWrapper are needed, but other changes are needed
>> to pass the data down to the rendering in the model-view-controller code.
>>
>> Also, the second example I gave (
>> https://gerrit.libreoffice.org/c/core/+/170666/9) is probably a better
>> one to work off than the first. In the first I was just changing things in
>> the series properties. I think what you're doing wants to be diagram-level
>> properties, as it sounds like you've already realized. So what I did for
>> pie-of-pie and bar-of-pie is more similar.
>>
>> I hope this helps.
>>
>> Kurt
>> On Thursday, August 15th, 2024 at 3:08 PM, Devansh Varshney <
>> varshney.devansh614 at gmail.com> wrote:
>>
>> 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*
>>>
>>
>>
>
> --
> *Regards,*
> *Devansh*
>


-- 
*Regards,*
*Devansh*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240818/e4eff8fd/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/20240818/e4eff8fd/attachment-0006.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/20240818/e4eff8fd/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 44787 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240818/e4eff8fd/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 73711 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240818/e4eff8fd/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 104902 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240818/e4eff8fd/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 28949 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240818/e4eff8fd/attachment-0011.png>


More information about the LibreOffice mailing list