Re: GSoC: Adding Histogram Chart Update Week 14

Devansh Varshney <varshney.devansh614@xxxxxxxxx> · Sun, 18 Aug 2024 20:14:02 +0530

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)

SideBar UI area is shown below the chart Image -

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@xxxxxxxxxxxxxx> 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@xxxxxxxxx> wrote:

             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 - 

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.

 [~/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