Posted 18 November 2021, 4:25 am 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.
[b]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
[zip filename="excel2007.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-5a3fe1d2-f20d-4e8a-8c9b-8adda5935f4e.zip[/zip]
