Automated document formatting tool

A computer-readable storage medium that stores a set of instructions which when executed perform a method for pasting spreadsheet elements, the method executed by the set of instructions comprising:

• determining a selection of a spreadsheet element having a first set of formatting properties in a source document;
• determining a paste point in a target document;
• comparing the first set of formatting properties associated with the spreadsheet element to a second set of formatting properties associated with the target document in order to determine an intended set of formatting properties for the spreadsheet element when included in the target document, wherein comparing the first set of formatting properties associated with the spreadsheet element to the second set of formatting properties associated with the target document comprises:
• determining whether source style properties of the source document have been at least one of:
• used and modified in the target document,
• in response to a determination that the source style properties have been at least one of:
• used and modified in the target document, setting target style properties as intended style properties associated with the intended formatting properties, and
• in response to a determination that the source style properties have not been at least one of:
• used and modified in the target document, setting the source style properties as the intended style properties associated with the intended formatting properties;
• determining if the selected spreadsheet element is a single cell;
• and
• if the selected spreadsheet element is not a single cell, pasting the spreadsheet element as a table at the paste point in the target document with the intended set of formatting properties applied thereto.

A system for pasting spreadsheet elements, the system comprising:

• a memory storage;
• and
• a processing unit coupled to the memory storage, wherein the processing unit is operative to:
• determine a selection of a spreadsheet element having a first set of formatting properties in a source document;
• determine a paste point in a target document;
• compare the first set of formatting properties associated with the spreadsheet element to a second set of formatting properties associated with the target document in order to determine an intended set of formatting properties for the spreadsheet element when included in the target document, wherein the processing unit being operative to compare the first set of formatting properties associated with the spreadsheet element to the second set of formatting properties associated with the target document comprises the processing unit being operative to:
• determine whether source style properties of the source document have been at least one of:
• used and modified in the target document,
• in response to a determination that the source style properties have been at least one of:
• used and modified in the target document, set target style properties as intended style properties associated with the intended formatting properties, and
• in response to a determination that the source style properties have not been at least one of:
• used and modified in the target document, set the source style properties as the intended style properties associated with the intended formatting properties;
• determine if the selected spreadsheet element is a single cell;
• and
• if the selected spreadsheet element is not a single cell, paste the spreadsheet element as a table at the paste point in the target document with the intended set of formatting properties applied thereto.