Hey, I've been playing around with dates and I noticed, that no matter what enum style you choose (NUMSTYLE_DATE/NUMSTYLE_TIME), they are doing basically the same, even the formatString piece. It shows correctly in the cell itself, but if you click on it you will see there is actually whole date and time written, but part of it is somehow invisible. This is ok if I want to look at it only, but I'd like to continue working with file.
I attached image to show you what I mean.
It sucks for example if I want to find difference between two times. (Dates work though)
I mean come on :D, even formulaes are throwing errors. Like why something just cannot work as it is supposed to. I needed 2 things that ARE included but not working. Good luck with project though, it is great someone tries something like this but itneeds a lot of work. I'll go to C# for this one.
If for someone something like:
Sheet.AddCell("=SUM(A1;A2));
works, please tell me, because I could use =DATE for my date problem and be done with it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Probably you have already done everything on C# and I should not bother you...
But seriously:
1. Read this: https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#excel-date-format
2. Library is support formulae recognition (without formula`s content verification, what is written on the main page). The library accepts any formulas, it doesn't care. But if the formula is not correct, then Excel will generate an error.
3. Your formula is not correct, see attached example.
Hey, I've been playing around with dates and I noticed, that no matter what enum style you choose (NUMSTYLE_DATE/NUMSTYLE_TIME), they are doing basically the same, even the formatString piece. It shows correctly in the cell itself, but if you click on it you will see there is actually whole date and time written, but part of it is somehow invisible. This is ok if I want to look at it only, but I'd like to continue working with file.
I attached image to show you what I mean.
It sucks for example if I want to find difference between two times. (Dates work though)
I mean come on :D, even formulaes are throwing errors. Like why something just cannot work as it is supposed to. I needed 2 things that ARE included but not working. Good luck with project though, it is great someone tries something like this but itneeds a lot of work. I'll go to C# for this one.
If for someone something like:
Sheet.AddCell("=SUM(A1;A2));
works, please tell me, because I could use =DATE for my date problem and be done with it.
Probably you have already done everything on C# and I should not bother you...
But seriously:
1. Read this: https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#excel-date-format
2. Library is support formulae recognition (without formula`s content verification, what is written on the main page). The library accepts any formulas, it doesn't care. But if the formula is not correct, then Excel will generate an error.
3. Your formula is not correct, see attached example.