[Spreadsheet Comment] Is there a way to add a line break to text in a cell? Topic is solved

[Ryan]

Having used personal computer spreadsheet programs extensively since they were introduced, I'm fascinated with the spreadsheet comment module incorporated into TDL. It has some nice features but also some very big flaws, the worst of which cause data loss. I do recognize, however, what a monumental job the developers of this module did even to take it as far as they did not to mention what a monumental job Dan did incorporating it so nicely into TDL.

Unfortunately I have not yet found to time to try to document some of the problems, but still hope to get to that someday (although I assume the majority of them are in the module itself and probably not fixable). In the meantime I use it cautiously and not as much as I would like. Some of the features really take some getting used to for me since I am so accustomed to MS Excel. But I have managed to find enough workarounds to get some good use out of the spreadsheets in TDL and hope to find even more.

In Excel, while typing text into a cell you can press Alt-Enter to insert a line break. I have tried every trick I know to find a similar way to insert a line break in a cell in spreadsheet comments (short of inserting some kind of like break character manually which may not work anyway) with no luck.

Unfortunately this severely limits the usefulness of the spreadsheet comments for me so I am hoping there might be some kind of reasonable way to do this that I was unable to find.

Thanks for any help!

[abstr]

with no luck

Try 'Ctrl' + 'Enter' for now. I'll add 'Alt' + Enter if I can.

Unfortunately I have not yet found to time to try to document some of the problems

One at a time is fine, and as long as there's a clear(ish) description I can always ask clarifying questions if I need.

ps. I have the code to the 3rd-party spreadsheet module so all things are possibly possible (possibly)!

[abstr]

I've split off your reply as a bug.