A customer had a program that opened a very large spreadsheet in Excel. Very large, like over 300,000 rows. They then selected all of the rows in the very large spreadsheet, copied those rows to the clipboard, and then ran a program that tried to extract the data. The program used the
GetClipboardDatafunction to retrieve the data in Rich Text Format. What they found was that the call to
NULL. Is there a maximum size for clipboard data?
No, there is no pre-set maximum size for clipboard data. You are limited only by available memory and address space.
Edge cases are so much fun to read about – they give so much insight into how certain things are done programmatically, even for a non-programmer such as myself.