Office 2010 formats supported?

Aspose.Cells Product Family
1

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.
2

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.

3

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

4

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,