StockOpenHighLowClose Chart :: Invalid chart type Error

Aspose.Cells Product Family
1

Hi

I am trying to create a StockOpenHighLowClose chart and its giving me the following error

System.Exception: Invalid chart type.

at Aspose.Excel.୏.୰()

at Aspose.Excel.୏.୩()

at Aspose.Excel.୏.ୖ()

at Aspose.Excel.୏.୑(Int32 ԡ)

at Aspose.Excel.Worksheet.֠(ھ Ԏ)

at Aspose.Excel.Worksheets.֜(ھ Ԏ)

at Aspose.Excel.Worksheets.֡(FileFormatType ֟)

at Aspose.Excel.Worksheets.֠(Stream Ԏ, FileFormatType ֟)

at Aspose.Excel.Excel.Save(Stream stream, FileFormatType fileFormatType)

at Aspose.Excel.Excel.Save(String fileName, FileFormatType fileFormatType)

Can you please tell me why it happening? I have added the chart creation code in the attached text file.

When I use the StockHighLowClose and use only three series it works fine.

regards

Naveen

2

Hi Naveen,

Not all stock chart type are supported. StockOpenHighLowClose chart type is not supported yet.

If you need this chart type, I will work on it in the next week. It will take about 2 weeks.

3

Hi Laurance

Thanks for quick reply.Yes I would definitely need StockOpenHighLowClose chart as we need to plot stock prices.

I think it will be good for your product as well becasue many financial institutions would need that feature.

Regards

Naveen

4

Hi

I havent not heard from you regarding this error.

Are you fixing it???

Regards

Naveen

5

Hi Naveen,

I am still working on this feature. It will be available in about one week. Thanks for your patience.

6

Hi Laurance

Were you able to fix this issue. I cannot wait any longer its already more than three weeks.

Please update me with the status.

Regards

Naveen

7

Hi Naveen,

Please try this attached fix. It's supported now.

8

Hi Laurance

The DLL thats attached is Aspose.cells and NOT aspose.excel.

We have already done a lot of development using aspose.excel and it would be difficult for me to change everything to aspose.cells. now.

Can you please suggest an easy way to migrate.

OR can you please give me a Aspose.Excel DLL.

Regards

Naveen

9

It's very easy to migrate. You just need to do:

1. Remove the reference to Aspose.Excel and add the reference to Aspose.Cells.

2. Find all "Aspose.Excel" string in your application and replace it with "Aspose.Cells".