Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri May 17, 2013 1:59 am

Attempting to insert data into an existing spreadsheet and getting this error:

AreaProperties cannot be support for this chart type.

The file is an xlsm file. Is this something that Spire cannot handle?

Thanks,

Richard

rbrynteson
 
Posts: 11
Joined: Wed Jun 20, 2012 3:58 am

Fri May 17, 2013 5:07 am

Hello Richard,

Thanks for your inquiry.

Sorry for inconvenience. Could you please provide us the XLSM file, Data and code if convenience? If so, It would be helpful for us, and we would figure out the solution for you ASAP.

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri May 17, 2013 3:16 pm

Is there an e-mail address I can send it to you?

Thanks,

Richard

rbrynteson
 
Posts: 11
Joined: Wed Jun 20, 2012 3:58 am

Mon May 20, 2013 1:12 am

Hello Richard,

Sorry for the delay as weekend.

You could send them to the e-mail address as below,
e-iceblue support team <support@e-iceblue.com>

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Mon May 20, 2013 7:49 am

Hello Richard,

The issue has been reproduced by testing, and which has been transferred to our Dev team, Once there are any response, I will get it back to you ASAP. Sorry for inconvenience.

If there are any questions, welcome to get it back to you.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Jun 04, 2013 9:32 am

Hello,

Thanks for your waiting.

There are some response from our Dev team that they have resolved the AreaProperties issue, but when
analyze the SigmaRule(D11, $E$2, $E$7,2) formula which calls Public Function SigmaRule(rngParticipantVal As Range, rngSampleMean As Range, rngSampleDev As Range, dblMultiplier As Double) As String methods in VBA, it gets other errors. They are working on this issue, once there are any response from them, we will get it back to you ASAP. Sorry for inconvenience.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS