We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Office 2010 formats supported?

amjad sahi> hi
Roy Willy> Hi! I assume Office 2010 will have new file
formats

Roy Willy> will a Cells support
that if I buy Cells today?

amjad sahi>
yes sure

amjad sahi> office 2010 support
would be include

Roy Willy> It is not
listed in your web-sites as suported

amjad
sahi>
yes when it is supported it will be listed

Roy Willy> so it will be included later? and I must buy
a subscription to get it?

amjad sahi>
yes you should be subscribed to use the component with its full
capacity

Roy Willy> Another issue: is
the license transferable to a new developer when a developer leaves the
company?

amjad sahi> well, I am afraid i
can only help you regarding technical inquires regarding component’s
features/issues or apis

amjad sahi> you
need to contact Aspose.Purchase team to get complete info about
licensing

Roy Willy> OK a technical
issue: when writing a float[] into Cells: how can I handle missing
values?

Roy Willy> Float.NaN seems to
not be working (tested on 1 cell.putvalue() only)

amjad sahi> could you give us sample
code

amjad sahi> you mean to say that
some decimal points are not inserted when checking the vlaue in ms
excel

Roy Willy> No, I have an array of
like 10 float values, but sometimes a couple of float values are not present
(missing). But how can I put that into the sheet?

amjad sahi> yes you can do
amjad sahi> i give you some method api
Roy Willy> Great!
amjad sahi> Aspose.Cells.Cells.ImportArray()

amjad sahi> specify its parameters
accordingly for your requirement

amjad
sahi>
e.g

amjad sahi>
sheet2.Cells.ImportArray(arr,0,0);

amjad
sahi>
check the document:

amjad
sahi>
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/importing-data-to-worksheets.html

amjad sahi> choose suitable overloaded version of
ImportArray() method

Roy Willy> am
trying now

amjad sahi>
ok

Roy Willy> This works: double[] d =
new double[] { 1.1, 2.2, 3.3, 4.4 }; sheet.Cells.ImportArray(d, 1, 1,
true);

Roy Willy> This do NOT work: can
not open file after:

Roy Willy>
double[] d = new double[] { 1.1, 2.2, double.NaN, 4.4 };

Roy Willy> sheet.Cells.ImportArray(d, 1, 1,
true);

Roy Willy> I use Double.NaN
since there are no data for that cell. It should be 'empty’

Roy Willy> Should I use something different from
Double.NaN?

Roy Willy> to signal
‘missing’ element?

amjad sahi> let me
check

Roy Willy> I am saving to
wb.Save(“c:\MyBook.xlsx”, FileFormatType.Excel2007Xlsx);



This message was posted using Email2Forum by Amjad Sahi.

Hi,

Well, double.NaN is a value which is not a number. So, for your case, you may change defining your double array a bit.

e.g

double[] d = new double[] { 1.1, 2.2, 0, 4.4 };
sheet.Cells.ImportArray(d, 1, 1,
true);


OR

double[] d = new double[4];
names[0] =1.1;
names[1] = 2.2;
names[3] = 4.4;
sheet.Cells.ImportArray(d, 1, 1,
true);


Feel free to contact us any time if you need further clarification.

Thank you.

We will provide a new version which supports Excel2010 in the next week.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have supported to keep Excel 2010 features such as sparklines and slicer's data in xlsx file format.

Thank You & Best Regards,