I am not sure if this is an Excel issue, or a TOAD export issue. When I create columns in a table, I always include a description for that column. Then when I create the schema report, I print the Comments (which is the Description - slightly confusing difference in terms, but they are the same thing). Then I have a data dictionary. Which I export to Excel, and do some additional post-work in, for printing to a PDF.
This works great, except… (you knew there had to be an except, right? )
Except for comments that are more than two lines in length. For some reason, the last line is partially cut off - only half of its height is visible. One line comments are fine. Two line commens are fine. But 3+ line comments are not. The last line is half-height.
I can fix this manually, by going through and manually resizing all 3+ multi-line comments. But, this is a pain in the neck and very time-consuming. It also defeats the purpose of being able to rapidly generate a new data dictionary.
I don’t know if this issue is due to Excel not behaving properly, or due to TOAD’s report export not formatting 3+ multi-lines correctly. Whatever the cause is, it’s a dang nuisance!
Is this something that can be fixed from your end?