Re: LibXL - Some questions
We use another technology (softartisans excelwriter), where writing a null has the desired effect.
Is that possible in LibXL?
Re: LibXL - Some questions
Marco, I have just tried it. If I check the date value before writing it and it has an empty value or a date older than 00/01/1900, I write NullDateTime() instead of that date in the given cell. Surprisingly the library converts it to "General" data type and ignores the given format (I use the WriteNumberWithFormat function with a peNumFormat with a date mask). It might work that way, at least it doesn't show that default date. The only downside is that it doesn't have a "Date" type.
Sorry if some of the Excel terms I'm using are not accurate enough, the language we use on Office products is not English.
Re: LibXL - Some questions
Hi Alberto
Maybe you have to change the format on that cell so that it is formatted as "General" and then leave the value blank.
Re: LibXL - Some questions
Hello Mike,
[QUOTE=Mike Cooper;349220]Maybe you have to change the format on that cell so that it is formatted as "General" and then leave the value blank.[/QUOTE]
Yes, this is indeed what my code does right now (even though it uses "number" format functions) and it seems to work fine. I hope it won't be a problem for our clients (perhaps they won't notice). If that causes them some trouble with ordering or filters on Excel they can always select every cell on that column and format it that way I think.
I will leave it as it is right now. LibXL is a pretty useful library, I really like it!
Thank you very much!
Re: LibXL - Some questions
I too found it very useful and used to to create a fairly complex Excel workbook with multiple sheets.