XLSSpreadSheet compile error

Questions and answers on how to use XLSSpreadSheet.
Post Reply
dkeith
Posts: 4
Joined: Wed Aug 31, 2022 10:33 pm

XLSSpreadSheet compile error

Post by dkeith »

Working with Delphi Enterprise version 11.1.5, I downloaded and installed the demo XLSSpreadSheet for Delphi 11. I installed the spreadsheet bpl just fine, it pulled in readwrite as well, and successfully installed the components.

I dropped a TXLSSpreadSheet control onto a TTabSheet inside of a TPageControl, and hit F9 to compile. The compile failed, I received the following error:

[dcc32 Fatal Error] main.pas(60): F2051 Unit XBookPaintGDI2 was compiled with a different version of Xc12DataStyleSheet5.TXc12Font

I received similar errors when I tried to compile the "Advanced" spreadsheet demo. Please advise how to fix this.

Thanks.

David Keith
Wellsoft, A Division of Medsphere Systems Corporation (existing XLSReadWriteII6 customer!)
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSSpreadSheet compile error

Post by larsa »

Hello

This can happen if you have several versions of the component installed or if you already have XLSReadWriteII installed. Uninstall XLSReadWriteII or rename the directories with the DCU/PAS files.
Lars Arvidsson, Axolot Data
dkeith
Posts: 4
Joined: Wed Aug 31, 2022 10:33 pm

Re: XLSSpreadSheet compile error

Post by dkeith »

Thanks, that solved one problem. On to the next one:

In the sample "CreateCharts", unit "Main.pas", the following code:

// Set colors
ChartSpace.Chart.PlotArea.BarChart.Shared.Series[0].ColorRGB := $FF0000;

...errors out with "[dcc32 Error] Main.pas(62): E2003 Undeclared identifier: 'ColorRGB'".

This occurs with every call to TCT_BarSeries.ColorRGB.
dkeith
Posts: 4
Joined: Wed Aug 31, 2022 10:33 pm

Re: XLSSpreadSheet compile error

Post by dkeith »

Figured it out. Removed and reinstalled XLSSpreadSheet demo, all is working now.

Thanks.
dkeith
Posts: 4
Joined: Wed Aug 31, 2022 10:33 pm

Re: XLSSpreadSheet compile error

Post by dkeith »

I create a sheet w/chart from the code in the CreateChart demo, save the sheet to a stream, and load the stream in a TXLSSpreadSheet instance. At first this worked without error, now I'm getting an AV:

compiled with : Delphi 11
madExcept version : 5.1.1
callstack crc : $6c28e940, $cbbea538, $cbbea538
count : 6
exception number : 2
exception class : EAccessViolation
exception message : Access violation at address 01BA7C35 in module 'TrendChartTest.exe'. Read of address 00000000.

main thread ($191c):
01ba7c35 +009 TrendChartTest.exe XLSBook2 644 +1 TXLSSpreadSheet.Int_Clear
01ba8b70 +024 TrendChartTest.exe XLSBook2 1104 +1 TXLSSpreadSheet.XLSChanged
01ba8ac7 +01f TrendChartTest.exe XLSBook2 1078 +2 TXLSSpreadSheet.LoadFromStream
01baaefa +046 TrendChartTest.exe main 618 +4 TForm1.Button1Click
005eda8e +0a6 TrendChartTest.exe Vcl.Controls 7664 +9 TControl.Click
0061a831 +031 TrendChartTest.exe Vcl.StdCtrls 5877 +3 TCustomButton.Click
0061c012 +01e TrendChartTest.exe Vcl.StdCtrls 6510 +1 TCustomButton.CNCommand
005ed42c +340 TrendChartTest.exe Vcl.Controls 7548 +91 TControl.WndProc
005f3c22 +6c6 TrendChartTest.exe Vcl.Controls 10583 +170 TWinControl.WndProc
0061a322 +086 TrendChartTest.exe Vcl.StdCtrls 5710 +13 TButtonControl.WndProc
005ecf16 +036 TrendChartTest.exe Vcl.Controls 7326 +10 TControl.Perform
005f3e1b +043 TrendChartTest.exe Vcl.Controls 10652 +12 DoControlMsg
005f4ae5 +015 TrendChartTest.exe Vcl.Controls 10930 +1 TWinControl.WMCommand
005ed42c +340 TrendChartTest.exe Vcl.Controls 7548 +91 TControl.WndProc
005f3c22 +6c6 TrendChartTest.exe Vcl.Controls 10583 +170 TWinControl.WndProc
005f304c +034 TrendChartTest.exe Vcl.Controls 10271 +3 TWinControl.MainWndProc
0054e510 +014 TrendChartTest.exe System.Classes StdWndProc
77694e9b +04b ntdll.dll KiUserCallbackDispatcher
75d558ea +06a USER32.dll SendMessageW
75d55746 +016 USER32.dll CallWindowProcW
005f3d97 +14f TrendChartTest.exe Vcl.Controls 10624 +30 TWinControl.DefaultHandler
005edfe2 +016 TrendChartTest.exe Vcl.Controls 7797 +1 TControl.WMLButtonUp
005ed42c +340 TrendChartTest.exe Vcl.Controls 7548 +91 TControl.WndProc
005f3c22 +6c6 TrendChartTest.exe Vcl.Controls 10583 +170 TWinControl.WndProc
0061a322 +086 TrendChartTest.exe Vcl.StdCtrls 5710 +13 TButtonControl.WndProc
005f304c +034 TrendChartTest.exe Vcl.Controls 10271 +3 TWinControl.MainWndProc
005f3067 +04f TrendChartTest.exe Vcl.Controls 10274 +6 TWinControl.MainWndProc
0054e510 +014 TrendChartTest.exe System.Classes StdWndProc
75d559fb +00b USER32.dll DispatchMessageW
007042a3 +12b TrendChartTest.exe Vcl.Forms 11336 +23 TApplication.ProcessMessage
007042f3 +00f TrendChartTest.exe Vcl.Forms 11366 +1 TApplication.HandleMessage
007046c7 +0db TrendChartTest.exe Vcl.Forms 11505 +27 TApplication.Run
01bda005 +049 TrendChartTest.exe TrendChartTest 19 +4 initialization
75edfa27 +017 KERNEL32.DLL BaseThreadInitThunk

Once I continue the application, I can see that the sheet has loaded successfully, but all other processing stops at the point of the AV, which occurs when I load the sheet from stream into the TXLSSpreadSheet control.
Post Reply