Excel-Word

How to use 2010 Excel & Word 2010 to export Case Analysis (Chronological Report)

This feature is helpful if you wish to take information within Lexbe eDiscovery Platform and sort it on Excel Spreadsheet for further analysis.

You can export Facts & Issues to an Excel spreadsheet (pivot option to Admin users) and copy the chronological report into a word document following the step below:
>After selecting Facts & Issues from LO and exporting to Excel, open Word 2010, navigate to Home, click Paste drop down button and hit Paste Special
>Click Paste link and select Excel Worksheet Object from the list. Click OK to continue.
>This will create a report in Word.

Another word-around is to copy the Excel spreadsheet to a Word Document

>From Excel, select all the rows in question, or hit Ctrl-A 


>Right click on a row number and select Row Height
>Type in '50' as new height and click Okay

Now copying and saving to a Word 2010 document
From Word File>Paste, select the option:
>Paste Special>Paste Link As>Microsoft Worksheet Object


This is will bring the report:



Excel Versions

Lexbe eDiscovery Platform supports the two most recent versions of Excel for Excel integration (2010 and 2013) and we recommend an upgrade from previous versions of Excel before you start exporting logs. Please note that if you are using previous versions (before 2010), you might lose some formatting, hyperlinks, scripts image files (HTML only), or lists of data in a single cell.