TestFiles

Test Files

This page documents the test files that have been used to test the DDT.

• Test Files
  • Files
  • Expected Results
  • Linking Mechanisms

Files

For each of the file types, there are will be test files for each version of Office. Well, there should be, but I don't have access to copies of Office earlier than 2003.

Each test file should have a name that describes what mechanism was used to create the links. There should be only one mechanism per file, but that mechanism should be repeated for files from all available office versions. So for instance if the file formulas.xls contains links in formulas, then formulas.xls should contain several formulas, each one of which uses data from a file made with a different version of office.

The folder structure at the moment is

testfiles
|---- xls
|---|---- 2003
|---|---|----chart-from-source.xls
|---|---|----chart-pasted.xls
|---|---|----formulas.xls
|---|---|----insert-as-object.xls
|---|---|----pivot-tables.xls
|---|---|----paste-as-link-text.xls
|---|---|----paste-as-link-doc.xls
|---|---- 2007
|---|---|----chart-from-source.xls
|---|---|----chart-pasted.xls
|---|---|----formulas.xls
|---|---|----insert-as-object.xls
|---|---|----pivot-tables.xls
|---|---- 2010

Where folders named after an office version contain files created by that version of office.
All of the version folders should contain the same files to make it easy to get a consistent set of
test files across versions.

Expected Results

The expected results are:

File:	Dependencies
chart-from-source.xls	2003-chartsource.xls
	2007-chartsource.xls
	2010-chartsource.xls
chart-pasted.xls	2003-chart.xls
	2007-chart.xls
	2010-chart.xls
formulas.xls	2003-formulasource.xls
	2007-formulasource.xls
	2010-formulasource.xls
insert-as-object.xls	2003-normalsource.xls
	2007-normalsource.xls
	2010-normalsource.xls
	2003-object-source.doc
pivot-tables.xls	2003-pivotsource.xls
	2007-pivotsource.xls
	2010-pivotsource.xls
paste-as-link-text.xls	2003-paste-special-range-source.doc
paste-as-link-doc.xls	2003-paste-special-doc-source.doc

As is fairly obvious, the dependencies are files that are created by different versions of office again.
Each file represents a mechanism for linking files. For instance, chart-from-source.xls contains
charts that use data from the '20xx-chartsource.xls' files.

Linking Mechanisms

The mechanisms that have been tested so far are:

• chart-from-source: a chart created with source data from another workbook.
• chart-pasted: a chart created in another workbook, then pasted into this one.
• formulas: a formula that references data in another workbook.
• insert-as-object: another OLE file inserted as an OLE object, see attached screenshot
• pivot-tables: a pivot table from data in another workbook.
• paste-as-link-doc: paste special'ed as a linked document. See attached screenshot
• paste-as-link-text: paste special'ed as a text and unicode text region.

If any other files/tests are added to the project, they should be noted in here.

[Urh]

Hi,
can you please share jour test files in folder strukture?

Reagards,
Urh

[Niklas Rehfeld]

They are in the code:
https://sourceforge.net/p/officeddt/code/HEAD/tree/trunk/testfiles/

[Urh]

Thank you for your answer,
i can get results with your xls test files, but cant get any results with
mine.
Also i don' quite understand how to configure files in test folder
(apache/ddt) and what exactly are they for.

i've created new folder in testfiles\xls (2013) where are two xls files.
One has a table and other has a graph with data from table in 1. file.
I've attached some screenshots and would kindly ask you if you can help me
with some clue.

Thank you for your help,
Urh

Urh Kopitar
tel: 040 470 705

2018-03-07 23:35 GMT+01:00 Niklas Rehfeld niklasr@users.sourceforge.net:

They are in the code:
https://sourceforge.net/p/officeddt/code/HEAD/tree/trunk/testfiles/

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/officeddt/wiki/TestFiles/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Niklas Rehfeld]

That looks like you are trying to run it on xlsx files. This tool only works for the old binary (.xls) files, not the newer xml-based ones.