Free Support Forum - aspose.com

A TIME function

#1

Hello.

I do not become value B hoping that a result becomes A when I carry out this program.
Please teach how it is settled.

Excel excel = new Excel();

Worksheet sheet = excel.Worksheets[0];
sheet.Name = "Sheet1";

Cells cells = sheet.Cells;

Cell cell_a1 = cells["A1"];
Cell cell_a2 = cells["A2"];

cell_a1.PutValue(5);
cell_a2.Formula = "=TIME(A1,0,0)";

excel.CalculateFormula();

Console.WriteLine(cell_a2.DateTimeValue.ToShortTimeString);

The output on the console is:
0:00

Why will not it be output with 5:00?

daimaru(japan)
I translate this sentence by translation software

#2

Hi daimaru,

Formula calculation engine doesn't support TIME function now. Do you have to retrieve the value at run time? If not, just save the formula in the file. When you open the generated file, MS Excel will handle it.

#3

Thank you.
I save it in a file once and acquire a value.
I wish that I have you support it.

#4

Well. I will support this function in the future releases.