Add comments to cells

[ThomasKiljanczykDev]

Hi,

One of my clients has a use case in their app which would require adding comments to the cells.

Here's an example from ClosedXML:

Here's the part of the ClosedXML documentation I've taken the image from:
https://github.com/closedxml/closedxml/wiki/Comments-Style-Size

Would it be possible to add similar feature to LargeXLSX?

My time is very constrained but I could consider contributing if no other maintainer is available.

LargeXLSX is crucial for the app, since ClosedXML has significantly worse performance and higher memory usage. The difference was literally 10x in some cases for larger files in this particular app.

[ThomasKiljanczykDev]

I've started implementing it on my fork

[salvois]

Hello @ThomasKiljanczykDev ,
sorry for the delayed reply.

If my memory servers me right, last time I checked I saw comments are one of those feature which are not "stream friendly", because you have to accumulate them in memory to write them in a specific portion of the file, thus might be not a perfect fit for this library, but there could be trade-offs.

I understand comments may be a useful feature for some use cases. If you'd like to contribute your implementation I'd be happy to review it, or I could try working on it on my spare time but of course I could not provide an ETA for this.

Thanks,
Salvo