Table of Contents:
2) By default, where does Ditto store its data?
3) I pasted a past item with Ditto, but it didn’t paste anything.
4) I copied a cell in Microsoft Excel and it only pastes back the text not the formulas.
5) I searched for something I know I copied but it’s not showing in the search results.
Ditto is an extension to the Windows Clipboard. You copy something to the Clipboard and Ditto takes what you copied and stores it in a database to retrieve at a later time.
2) By default, where does Ditto store its data?
Settings are stored in “HKCU\programs\Ditto”
The database is stored in “Documents and Settings\[Current User]\Application Data\Ditto\DittoDB.mdb”
Application files are stored in “Program Files\Ditto\”
3) I pasted a past item with Ditto, but it didn’t paste anything.
Sometimes, Ditto cannot find the currently focused (target) window, so Ditto cannot paste to it. When this happens, the clip is still placed onto the Clipboard, so you can hit Ctrl-V to paste the data wherever you like.
We have seen this happen more in Internet Explorer windows.
4) I copied a cell in Microsoft Excel and it only pastes back the text not the formulas.
Excel generally prevents copying and pasting of the underlying formulas using external sources like Ditto. Presumably, Excel requires that proper pasting be sequential to the copying. In fact, it appears that the Office Clipboard also doesn’t paste the underlying formulas.
The following specific information / exceptions are known:
1) If the block of copied cells are self-contained (i.e. any formulas within the block only refer to other cells within the block), then the “XML Spreadsheet” Clipboard Format contains the formulas and can be properly pasted back into Excel from Ditto. Otherwise, “XML Spreadsheet” just contains the values of the copied cells.
2) The CF_SYLK Clipboard Format does appear to contain cell formulas in relative form, but Excel does not make use of them when it is pasted back.
3) The following Clipboard Formats are used when pasting cell links: “Embed Source”, “Link Source”, “Link Source Descriptor”. In some unknown cases, “Link” and “Object Descriptor” may also be required.
5) I searched for something I know I copied but it’s not showing in the search results.
When searching, you are actually searching through each Clip’s “Description”, not their content. The Description is extracted from the beginning of the Clip’s text Format. The default amount of text saved in the Description is 250 bytes but this can be changed in [Options -> General -> "Amount of text to save for description"].
On all searches, search are treated as Clip Text contains the search words.
When searching spaces are treated as "and" unless they are contained in quotes ("")
ex. search for - right click -
this would find anything with "right" and "click" in the text, not necessarily next to each other
search for - "right click"
this would find all text containing the exact text "right click"