Not a vaild forumla?

Aspose.Cells Product Family
1

Okay, I’m asking this question with not a ton of Excel experience so the answer to this may be obious. I have two formulas that I am trying to add to the forumula property of my cells.

They are:

=D6&", "&E6
=(J6-G6)/365

Is there some reason I cannot use these. Looking at the API documentaion it said all forumulas begin with a type? But these aren’t that way in the excel file as they were given to me. All I see is whats above, Any ideas? The first forumla puts together two string cells and the second one takes one date minus another to retun a float value of timespan.

Thanks!

2

Hi,

Formula “=(J6-G6)/365” is supported in Aspose.Excel but “=D6&”, “&E6” is not now.
I missed & operator currently. I will support this feature before the end of this month.

Now you can put the formula in your designer file and use Aspose.Excel to import it.
Sorry for the inconvenience.

3

I will support this feature before the end of this month.


Awesome, That would be super helpful. But like you said for now I’ll just use the designer file.