Six Common Review and Production Problems: How to Fix Them August 2014 - Page 11

CHAPTER THREE Spreadsheet and Database Files POTENTIAL ISSUE: Spreadsheets are notoriously difficult to adapt into a letter-sized format. There may be too many rows or columns to easily read information and they may be blank, thereby creating thousands of pages of unnecessary documents. If TIFFed, reviewers may miss hidden columns, formulas, and other internal data (the same would be true if spreadsheets were printed hard copy). There is no common solution to how these spreadsheets are converted to images; one method is to expose all hidden columns, sheets, etc. and another method is to print with last known print settings. RESOLUTION: The best practice is to review spreadsheets in their native format, taking care to look for hidden rows, columns, sheets, and other nonvisible data. 11