Can I use a spreadsheet file with more than 32,000 rows?
Calc is currently limited to using 32,000 rows. The row limit issue is well known, and it is currently a limitation in comparison to Microsoft Office 2000, which has a limit set at 65536 rows. 6.2. Adding trailing characters to a cell If what you have in columns are index numbers like “DCP_5509” and you want to add a file suffix for instance like “myparty.jpg” to the end. If the “DCP_5509″ and all other names are in column B (so assume the first entry is in B1), then we simply use =CONCATENATE(B1;”myparty.jpg”). Now, apply this to the entire column, and you’ll have “DCP_5509myparty.jpg” and the like.
