SaveExcel2007File Issue System.AccessViolationException in SSGetValueLen

Posted by: fabio.oliva on 17 November 2021, 7:25 pm EST

  • Posted 17 November 2021, 7:25 pm EST

    Hello
    I have an issue creating .xlsx file with SaveExcel2007File .

    I use VB6 sp6 , Spread ocx fpSPR80.OCX 8.0.0.28 , windows 10 pro 1909 build 18363.1556 , FarPoint.Spread8.Excel2007.dll registered with regasm


    I set every cell to .CellType = CellTypeEdit before exporting but i still have the warning '1 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.


    the log file:

    ===== FarPoint Technologies, Inc =====
    ===== Begin of Excel Export =====
    18/11/2021 09:08:58

    Col Row Information
    ___ ___ ___________
    160:Export Excel File: C:\Users\ ... \excel2007\export.xlsx
    1 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    2 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    3 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    4 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    5 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    6 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    9 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    10 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    11 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    12 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    13 -1 175:Excel does not support the Spread static text cell type. The value of the Spread cell has been placed in the corresponding Excel cell, but the cell formatting has been discarded.
    System.AccessViolationException: Tentativo di lettura o scrittura della memoria protetta. Spesso questa condizione indica che altre parti della memoria sono danneggiate.
    in FarPoint.Com.Excel.SpreadDll.SSGetValueLen(IntPtr hWnd, Int32 Col, Int32 Row)
    in FarPoint.Com.Excel.SheetView.LoadSheetData()
    in FarPoint.Com.Excel.SheetView.Load()
    in FarPoint.Com.Excel.SpreadAdapter.Load()
    in FarPoint.Com.Excel.FpExcelStub.SaveExcelEx(IntPtr fpControl, String filename, String logfile, Int16 flags, String password)
    [li][/li]



    In the attached file a small zipped evb6 project example who loads a .ss8 data file to replicate the issue

    Thank you

    Fabio Oliva
    Italy


    excel2007.zip
  • Replied 29 November 2021, 4:02 pm EST

    Hello,

    We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix. We will update you as soon as we hear anything from them.

    Tracking id for your issue is:- SPCOM-11

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels