Excel Formatting is a Beautiful Thing

Not many people in the world of eDiscovery would suggest that Excel formatting is a beautiful thing, but we do, and for good reason. We developed a method to format Excel documents in such a way that they don’t look like complete junk when converted to images. How did we do this? Ask Sheng, he spent a few months refining a very complex algorithm that…

• Detects how many characters are in each cell and adjusting the width and height accordingly(this means we don’t have to EXPAND the column or row fully, which results in a prettier picture)
  
• Finds all charts on every sheet and dynamically creates a new sheet directly behind the sheet the chart came from. The chart is then placed on that sheet with original coordinates to where the chart came from. This process, called chart extraction, eliminates the possibility of charts being cut-off across pages.
  

Of course we do all the standard formatting options like unhiding rows/columns/sheets, converting in black and white text, providing headers and footers, print area extended fully, etc.

Posted by Logik Systems