Jan Havlíček

Results 134 comments of Jan Havlíček

@everythingajw Hi, I am the new maintainer. I am thankful that you took the time to investigate the issue and submit the PR, but the whole situation with storing a...

I have looked through the spec and I haven't seen a requirement that table has to have a data row. But: Excel does have "at least one data row" requirement...

Hi, LINEST returns an array, so ClosedXml it must be able to use array formulas. That can be done only after #1812. New parser should land 0.97, new CalcEngine (evaluates...

@igitur What do you think about using libraries for functions? Although we could implement various math functions, or (better yet) offload it to someone who requests it, it would be...

@igitur It is missing ability to load saved file that has subtotals in some fields and and not in others. I had some problems with XML comparing, so I worked...

I have simplified the error case to this `ISNA(VLOOKUP(...))`. The VLOOKUP didn't match anything and ended with #N/A and ISNA should convert it to true or false. It didn't. It...

@igitur I think desired feature is to be able to write a numeric value as a string, so it is treated as a string, but tell excel to ignore it's...

Resources are scarce. Time of developers is valuable. Should we allocate it for a long dead target with incredibly easy update path? We will still target net46. If they don't...

@igitur Hi, some time you asked about performance and I made some guesses that weren't very accurate. I made some benchmarks (https://github.com/ClosedXML/ClosedXML/pull/1848#issuecomment-1206784192) and the results are troublesome. XLParser is two...

My perf. concerns were based on a small sample and a little overblown. XLParser has a large collection of excel formulas from Enron (yea, that Enron). Based on that collection,...