summaryrefslogtreecommitdiff
path: root/testautomation/chart2/optional
diff options
context:
space:
mode:
Diffstat (limited to 'testautomation/chart2/optional')
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_ods_to_ods.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_ods_to_ots.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_ods_to_sdc.bas73
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_ods_to_sxc.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_ods_to_xls.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_sxc_to_ods.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_losa_sxc_to_sdc.bas74
-rwxr-xr-xtestautomation/chart2/optional/ch2_lvl1_wizard.bas68
-rw-r--r--testautomation/chart2/optional/ch2_xml_format.bas62
-rwxr-xr-xtestautomation/chart2/optional/includes/wizard/ch2_lvl1_wizard.inc717
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_areas_normal.odsbin0 -> 19980 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_areas_percent.odsbin0 -> 22854 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_areas_stacked.odsbin0 -> 20547 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_bars_normal.odsbin0 -> 22851 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_bars_percent.odsbin0 -> 23088 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_bars_stacked.odsbin0 -> 23782 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_columns_lines_and_columns.odsbin0 -> 24097 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_columns_lines_and_stacked_columns.odsbin0 -> 25212 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_columns_normal.odsbin0 -> 23151 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_columns_percent.odsbin0 -> 23058 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/2d_columns_stacked.odsbin0 -> 24970 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/3d_lines_deep.odsbin0 -> 35335 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/3d_pies_normal.odsbin0 -> 39008 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/areas_deep.odsbin0 -> 52064 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/areas_percent.odsbin0 -> 38468 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/areas_stacked.odsbin0 -> 42860 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_deep.odsbin0 -> 61483 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_cones.odsbin0 -> 66269 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_cones_deep.odsbin0 -> 110686 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_cones_percent.odsbin0 -> 110617 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_pyramids.odsbin0 -> 67118 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_pyramids_deep.odsbin0 -> 98383 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_pyramids_percent.odsbin0 -> 110239 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_pyramids_stacked.odsbin0 -> 85911 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_horizontal_stacked_cones.odsbin0 -> 88184 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_normal.odsbin0 -> 71033 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_percent.odsbin0 -> 66755 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_stacked.odsbin0 -> 60722 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_tube.odsbin0 -> 41905 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_tubes_deep.odsbin0 -> 59620 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_tubes_percent.odsbin0 -> 62875 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/bars_tubes_stacked.odsbin0 -> 50291 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cones.odsbin0 -> 50195 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cones_deep.odsbin0 -> 84795 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cones_percent.odsbin0 -> 90080 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cones_stacked.odsbin0 -> 88072 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cylinder.odsbin0 -> 53406 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cylinder_deep.odsbin0 -> 67403 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cylinder_percent.odsbin0 -> 86518 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_cylinder_stacked.odsbin0 -> 79786 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_deep.odsbin0 -> 50144 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_normal.odsbin0 -> 59819 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_percent.odsbin0 -> 60109 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_pyramids.odsbin0 -> 71749 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_pyramids_deep.odsbin0 -> 96324 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_pyramids_percent.odsbin0 -> 103938 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_pyramids_stacked.odsbin0 -> 104487 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/columns_stacked.odsbin0 -> 65360 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_b-spline.odsbin0 -> 25651 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_b-spline_with_symbols.odsbin0 -> 30305 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_cubic_spline.odsbin0 -> 25841 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_cubic_spline_with_symbols.odsbin0 -> 33585 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_normal.odsbin0 -> 19673 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_percent.odsbin0 -> 19326 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_percent_with_symbols.odsbin0 -> 23242 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_stacked.odsbin0 -> 20462 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_stacked_with_symbols.odsbin0 -> 24066 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/lines_symbols.odsbin0 -> 23002 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_normal.odsbin0 -> 19926 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_percent.odsbin0 -> 20031 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_percent_with_symbols.odsbin0 -> 24009 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_stacked.odsbin0 -> 20018 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_stacked_with_symbols.odsbin0 -> 24083 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/net_symbols.odsbin0 -> 23820 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/pies_normal.odsbin0 -> 20506 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/pies_offset1.odsbin0 -> 20195 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/pies_offset2.odsbin0 -> 20524 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/pies_rings.odsbin0 -> 27925 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/stockchart_type1.odsbin0 -> 19889 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/stockchart_type2.odsbin0 -> 21315 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/stockchart_type3.odsbin0 -> 22123 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/stockchart_type4.odsbin0 -> 23348 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_b-spline.odsbin0 -> 24219 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_b-spline_with_symbols.odsbin0 -> 27576 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_cubic_spline.odsbin0 -> 24489 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_cubic_spline_with_symbols.odsbin0 -> 27677 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_lines_only.odsbin0 -> 19266 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_lines_with_symbols.odsbin0 -> 22498 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/ods/xy_chart_symbols_only.odsbin0 -> 21517 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/randomData.odsbin0 -> 7713 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_areas_normal.sxcbin0 -> 11879 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_areas_percent.sxcbin0 -> 12137 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_areas_stacked.sxcbin0 -> 12547 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_bars_normal.sxcbin0 -> 13620 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_bars_percent.sxcbin0 -> 13373 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_bars_stacked.sxcbin0 -> 12325 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_columns_lines_and_columns.sxcbin0 -> 14033 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_columns_lines_and_stacked_columns.sxcbin0 -> 14458 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_columns_normal.sxcbin0 -> 13793 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_columns_percent.sxcbin0 -> 13675 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/2d_columns_stacked.sxcbin0 -> 14365 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/3d_lines_deep.sxcbin0 -> 18632 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/3d_pies_normal.sxcbin0 -> 20396 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/areas_deep.sxcbin0 -> 32742 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/areas_percent.sxcbin0 -> 21962 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/areas_stacked.sxcbin0 -> 23672 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_deep.sxcbin0 -> 39140 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_cones.sxcbin0 -> 34799 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_cones_deep.sxcbin0 -> 51450 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_cones_percent.sxcbin0 -> 48313 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_pyramids.sxcbin0 -> 32902 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_deep.sxcbin0 -> 48143 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_percent.sxcbin0 -> 47134 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_stacked.sxcbin0 -> 40866 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_horizontal_stacked_cones.sxcbin0 -> 41810 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_normal.sxcbin0 -> 34087 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_percent.sxcbin0 -> 35015 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_stacked.sxcbin0 -> 30564 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_tube.sxcbin0 -> 28453 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_tubes_deep.sxcbin0 -> 36522 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_tubes_percent.sxcbin0 -> 39245 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/bars_tubes_stacked.sxcbin0 -> 32849 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cones.sxcbin0 -> 27681 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cones_deep.sxcbin0 -> 41842 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cones_percent.sxcbin0 -> 44938 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cones_stacked.sxcbin0 -> 40843 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cylinder.sxcbin0 -> 28562 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cylinder_deep.sxcbin0 -> 34619 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cylinder_percent.sxcbin0 -> 42982 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_cylinder_stacked.sxcbin0 -> 44840 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_deep.sxcbin0 -> 32156 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_normal.sxcbin0 -> 37062 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_percent.sxcbin0 -> 37149 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_pyramids.sxcbin0 -> 38666 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_pyramids_deep.sxcbin0 -> 53341 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_pyramids_percent.sxcbin0 -> 55649 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_pyramids_stacked.sxcbin0 -> 53051 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/columns_stacked.sxcbin0 -> 32245 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_b-spline.sxcbin0 -> 19509 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_b-spline_with_symbols.sxcbin0 -> 22013 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_cubic_spline.sxcbin0 -> 19650 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_cubic_spline_with_symbols.sxcbin0 -> 22066 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_normal.sxcbin0 -> 17027 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_percent.sxcbin0 -> 16447 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_percent_with_symbols.sxcbin0 -> 18472 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_stacked.sxcbin0 -> 17579 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_stacked_with_symbols.sxcbin0 -> 19077 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/lines_symbols.sxcbin0 -> 18275 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_normal.sxcbin0 -> 16864 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_percent.sxcbin0 -> 16992 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_percent_with_symbols.sxcbin0 -> 19009 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_stacked.sxcbin0 -> 16947 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_stacked_with_symbols.sxcbin0 -> 19043 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/net_symbols.sxcbin0 -> 18861 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/pies_normal.sxcbin0 -> 25337 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/pies_offset1.sxcbin0 -> 16978 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/pies_offset2.sxcbin0 -> 17217 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/pies_rings.sxcbin0 -> 20869 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/stockchart_type1.sxcbin0 -> 16651 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/stockchart_type2.sxcbin0 -> 17371 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/stockchart_type3.sxcbin0 -> 17883 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/stockchart_type4.sxcbin0 -> 18534 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_b-spline.sxcbin0 -> 19090 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_b-spline_with_symbols.sxcbin0 -> 20759 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_cubic_spline.sxcbin0 -> 19391 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_cubic_spline_with_symbols.sxcbin0 -> 20911 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_lines_only.sxcbin0 -> 16609 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_lines_with_symbols.sxcbin0 -> 18325 bytes
-rwxr-xr-xtestautomation/chart2/optional/input/sxc/xy_chart_symbols_only.sxcbin0 -> 17630 bytes
169 files changed, 1364 insertions, 0 deletions
diff --git a/testautomation/chart2/optional/ch2_losa_ods_to_ods.bas b/testautomation/chart2/optional/ch2_losa_ods_to_ods.bas
new file mode 100755
index 000000000000..af689ebb6829
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_ods_to_ods.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_ods_to_ods.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: ODS, Output:ODS
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "calc8"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "ods"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".ods"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in ODS - SaveAS ODS ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/tools/ch_tools_common.inc"
+ use "chart2/optional/includes/ch2_losa.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_ods_to_ods.bas")
+ call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_ods_to_ots.bas b/testautomation/chart2/optional/ch2_losa_ods_to_ots.bas
new file mode 100755
index 000000000000..8270deb19e6b
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_ods_to_ots.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_ods_to_ots.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: ODS, Output: OTS
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "calc8_template"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "ods"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".ots"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in ODS - SaveAS OTS ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_ods_to_ots.bas")
+ call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_ods_to_sdc.bas b/testautomation/chart2/optional/ch2_losa_ods_to_sdc.bas
new file mode 100755
index 000000000000..4df2c54ea384
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_ods_to_sdc.bas
@@ -0,0 +1,73 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_ods_to_sdc.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: ODS, Output: SDC
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "StarCalc 5.0"
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "ods"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".sdc"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in ODS - SaveAS SDC ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_ods_to_sdc.bas")
+ call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_ods_to_sxc.bas b/testautomation/chart2/optional/ch2_losa_ods_to_sxc.bas
new file mode 100755
index 000000000000..dd112ce784e4
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_ods_to_sxc.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_ods_to_sxc.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: ODS, Output: SXC
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "StarOffice XML (Calc)"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "ods"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".sxc"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in ODS - SaveAS SXC ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_ods_to_sxc.bas")
+ Call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_ods_to_xls.bas b/testautomation/chart2/optional/ch2_losa_ods_to_xls.bas
new file mode 100755
index 000000000000..33d9e7928cb1
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_ods_to_xls.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_ods_to_xls.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: ODS, Output: XLS
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "MS Excel 97"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "ods"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".xls"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in ODS - SaveAS XLS ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_ods_to_xls.bas")
+ Call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_sxc_to_ods.bas b/testautomation/chart2/optional/ch2_losa_sxc_to_ods.bas
new file mode 100755
index 000000000000..388ca5a51ac8
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_sxc_to_ods.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_sxc_to_ods.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: SXC, Output:ODS
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "calc8"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "sxc"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".ods"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in SXC - SaveAS ODS ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_sxc_to_ods.bas")
+ Call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_losa_sxc_to_sdc.bas b/testautomation/chart2/optional/ch2_losa_sxc_to_sdc.bas
new file mode 100755
index 000000000000..f6c3e43f65c9
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_losa_sxc_to_sdc.bas
@@ -0,0 +1,74 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_losa_sxc_to_sdc.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:54 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@Sun.COM
+'*
+'* short description : Load/Save test for chart files - Input: SXC, Output: SDC
+'*
+'\************************************************************************
+
+Global gsFileFormat as String
+Global gsDirectoryInSourcePath as String
+Global gsOutputFileCustomExtension as String
+
+sub main
+ gsFileFormat = "StarCalc 5.0"
+
+ 'Important for determination of input file source path
+ '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
+ gsDirectoryInSourcePath = "sxc"
+
+ 'Custom output file extension. Can be different to result from hGetFilternameExtension.
+ 'e.g. "_excel95.xls"
+ gsOutputFileCustomExtension = ".sdc"
+
+ Printlog "--------------------------------------------------"
+ Printlog "--- Load charts in SXC - SaveAS SDC ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_losa.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_losa_sxc_to_sdc.bas")
+ Call subLoSaFromTo
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ gApplication = "Calc"
+ Call GetUseFiles
+end sub
diff --git a/testautomation/chart2/optional/ch2_lvl1_wizard.bas b/testautomation/chart2/optional/ch2_lvl1_wizard.bas
new file mode 100755
index 000000000000..ab36e6ca55e2
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_lvl1_wizard.bas
@@ -0,0 +1,68 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_lvl1_wizard.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:55 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@sun.com
+'*
+'* short description : Level 1 functional test for Chart2 Wizard
+'*
+'\************************************************************************************************
+
+sub main
+ use "chart2\tools\ch_tools_common.inc"
+ use "chart2\tools\ch_tools_chart_type.inc"
+ use "chart2\tools\ch_tools_titles.inc"
+ use "chart2\tools\ch_tools_axes.inc"
+ use "chart2\tools\ch_tools_grids.inc"
+ use "chart2\tools\ch_tools_legend.inc"
+ use "chart2\tools\ch_tools_data_labels.inc"
+ use "chart2\tools\ch_tools_statistics.inc"
+ use "chart2\tools\ch_tools_tab_pages.inc"
+ use "chart2\tools\ch_tools_select.inc"
+ use "chart2\optional\includes\wizard\ch2_lvl1_wizard.inc"
+
+ Call hStatusIn ( "Chart2", "ch2_lvl1_wizard.bas" )
+ Call tCreateNew3DChart
+ Call tCreateNewLineChart
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global\system\includes\master.inc"
+ use "global\system\includes\gvariabl.inc"
+ use "global\tools\includes\optional\t_set_standard_controls.inc"
+ Call GetUseFiles
+ gApplication = "Calc"
+end sub
+
diff --git a/testautomation/chart2/optional/ch2_xml_format.bas b/testautomation/chart2/optional/ch2_xml_format.bas
new file mode 100644
index 000000000000..bc85521d8fc3
--- /dev/null
+++ b/testautomation/chart2/optional/ch2_xml_format.bas
@@ -0,0 +1,62 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_xml_format.bas,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:55 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/***********************************************************************
+'*
+'* owner : oliver.craemer@sun.com
+'*
+'* short description : General XML file format check
+'*
+'\***********************************************************************
+
+
+sub main
+ Printlog "--------------------------------------------------"
+ Printlog "--- Chart2 General XML file format check ---"
+ Printlog "--------------------------------------------------"
+
+ use "chart2/loadsave/inc/ch2_xml_format.inc"
+ use "chart2/tools/ch_tools_common.inc"
+
+ Call hStatusIn("Chart2", "ch2_xml_format.bas")
+ call tCompareXMLFormatCreate
+ call tCompareXMLFormatLoad
+ Call hStatusOut
+end sub
+'
+'-------------------------------------------------------------------------------
+'
+sub LoadIncludeFiles
+ use "global/system/inc/master.inc"
+ use "global/system/inc/gvariabl.inc"
+ use "global/tools/inc/t_doc2.inc"
+ call getusefiles
+end sub
diff --git a/testautomation/chart2/optional/includes/wizard/ch2_lvl1_wizard.inc b/testautomation/chart2/optional/includes/wizard/ch2_lvl1_wizard.inc
new file mode 100755
index 000000000000..062d56b149a2
--- /dev/null
+++ b/testautomation/chart2/optional/includes/wizard/ch2_lvl1_wizard.inc
@@ -0,0 +1,717 @@
+'encoding UTF-8 Do not remove or change this line!
+'**************************************************************************
+'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'*
+'* Copyright 2008 by Sun Microsystems, Inc.
+'*
+'* OpenOffice.org - a multi-platform office productivity suite
+'*
+'* $RCSfile: ch2_lvl1_wizard.inc,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change: $Author: jsi $ $Date: 2008-06-13 14:26:55 $
+'*
+'* This file is part of OpenOffice.org.
+'*
+'* OpenOffice.org is free software: you can redistribute it and/or modify
+'* it under the terms of the GNU Lesser General Public License version 3
+'* only, as published by the Free Software Foundation.
+'*
+'* OpenOffice.org is distributed in the hope that it will be useful,
+'* but WITHOUT ANY WARRANTY; without even the implied warranty of
+'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+'* GNU Lesser General Public License version 3 for more details
+'* (a copy is included in the LICENSE file that accompanied this code).
+'*
+'* You should have received a copy of the GNU Lesser General Public License
+'* version 3 along with OpenOffice.org. If not, see
+'* <http://www.openoffice.org/license.html>
+'* for a copy of the LGPLv3 License.
+'*
+'/************************************************************************
+'*
+'* owner : joerg.sievers@sun.com
+'*
+'* short description : Chart wizard general functionality
+'*
+'************************************************************************
+'*
+' #1 tCreateNew3DChart ' Create a new 3D chart and check the preserved values
+' #1 tCreateNewLineChart ' Create a new line chart and check the preserved values
+'*
+'\************************************************************************
+
+testcase tCreateNew3DChart
+ Dim sInputFile as STRING
+ Dim sOutputFile as STRING
+ Dim sControlString as STRING
+ Dim iChartVariant as integer
+ Dim iChartVariantText as string
+
+
+ sInputFile = convertpath ( gTesttoolPath & "chart2/level1/input/randomData.ods" )
+ sOutputFile = convertpath ( gOfficePath & "user/work/tCreateNew3DChart.ods" )
+
+ printlog "Load test document TesttoolPath/chart2/level1/input/randomData.ods"
+ call hFileOpen(sInputFile)
+ sleep(2)
+ printlog "Save document as OfficePath/user/work/tCreateNew3DChart.ods"
+ if NOT hFileSaveAsWithFilterKill ( sOutputFile , "calc8" ) then
+ warnlog "Saving test document localy failed -> Aborting"
+ call hCloseDocument
+ goto endsub
+ endif
+ printlog "Insert / Chart"
+ InsertChart
+ sleep(5)
+ Kontext "ChartType"
+ printlog "Choose the Chart type bar (should be the second in the top-down list)"
+ if fSetChartType( "bar" ) > 0 then
+ warnlog "Something went wrong setting chart type to BAR."
+ endif
+ printlog "Select 2nd chart variant from left"
+ if fSetChartTypeVariant( 2 ) > 0 then
+ warnlog "Something went wrong setting chart type VARIANT."
+ endif
+ printlog "Check 3D Look checkbox"
+ if fSetChartType3D( TRUE ) > 0 then
+ warnlog "Something went wrong setting 3D chart."
+ endif
+ printlog "Change Chart type look to simple"
+ if fSetChartLook3D( "simple" ) > 0 then
+ warnlog "Something went wrong setting 3D look."
+ endif
+ printlog "Change Chart shape to cone"
+ if fSetChartShape3D( "cone" ) > 0 then
+ warnlog "Something went wrong setting 3D shape."
+ endif
+ printlog "Change to Data Range tab page by clicking the Next-button"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeDataRange"
+ printlog "Set data range text box to $Sheet1.$A$2:$E$13"
+ if fSetTextBox ( DataRange , "$Sheet1.$A$2:$E$13" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Select data series in Rows radiobox"
+ if fSetRadioButton ( Rows ) > 0 then
+ warnlog "Something went wrong selecting 'Data Series in: Rows'."
+ endif
+ printlog "Uncheck First row as label checkbox"
+ if fSetCheckBox ( FirstRowAsLabel , FALSE ) > 0 then
+ warnlog "Something went wrong unselecting 'First row as label'."
+ endif
+ printlog "Change to Data Series tab page by clicking the Next-button"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeDataSeries"
+ printlog "Select last (12th) entry in Data Series list on the left"
+ if fSetListBoxByItem ( DataSeries , 12 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Series' item no. 12."
+ endif
+ printlog "Click on the add-button"
+ AddButton.Click
+ printlog "Set Range for Name text field to A17"
+ if fSetTextBox ( RangeFor , "A17" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Select 2nd entry in Data Ranges (Y-Values) list on the right"
+ if fSetListBoxByItem ( DataRanges , 2 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 2."
+ endif
+ printlog "Set Range for Y-Values text field to B17:E17"
+ if fSetTextBox ( RangeFor , "B17:E17" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Change to Chart Elements tab-page by clicking the Next-button"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeChartElements"
+ printlog "Set 'Title' text box to MyTitle"
+ if fSetTextBox ( Title , "MyTitle" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Set 'Subtitle' text box to 1 2 3"
+ if fSetTextBox ( Subtitle , "1 2 3" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Set 'X Title' text box to Grått"
+ if fSetTextBox ( TitleXAxis , "Grått" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Set 'Y Title' text box to Gräulich"
+ if fSetTextBox ( TitleYAxis , "Gräulich" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Set 'Z Title' text box to 灰色"
+ if fSetTextBox ( TitleZAxis , "灰色" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Check X Axis-checkbox"
+ if fSetCheckBox ( GridLinesXAxis , TRUE ) > 0 then
+ warnlog "Something went wrong checking 'X Axis'."
+ endif
+ printlog "Uncheck Y Axis-checkbox"
+ if fSetCheckBox ( GridLinesYAxis , FALSE ) > 0 then
+ warnlog "Something went wrong unchecking 'Y Axis'."
+ endif
+ printlog "heck Z Axis-checkbox"
+ if fSetCheckBox ( GridLinesZAxis , TRUE ) > 0 then
+ warnlog "Something went wrong checking 'Z Axis'."
+ endif
+ printlog "Select under Legend (on the right) the Left radio-button"
+ if fSetRadioButton ( PositionLeft ) > 0 then
+ warnlog "Something went wrong selecting 'Legend Display Left'."
+ endif
+ printlog "Click the Finish-button"
+ Kontext "ChartWizard"
+ ChartWizard.OK
+ sleep(2)
+ printlog "File / Save"
+ FileSave
+ Kontext "DocumentCalc"
+ printlog "Press ESCAPE button (deselecting the OLE object)"
+ DocumentCalc.TypeKeys "<Escape>"
+ printlog "Close the document"
+ Call hCloseDocument
+ sleep(2)
+ printlog "Open saved file again"
+ call hFileOpen(sOutputFile)
+ sleep(2)
+ printlog "Select chart OLE using navigator"
+ call fSelectFirstOLE
+ printlog "Edit / Object / Edit to enter inplace mode of the chart"
+ printlog "(enabling the chart menus and editing possibilities)"
+ EditObjectEdit
+ printlog "Format / Chart Type"
+ FormatChartType
+ sleep(1)
+ Kontext "ChartType"
+ printlog "Check if chart type is 'bar'"
+ if ChooseType.GetSelIndex <> 2 Then
+ warnlog "Selected chart type (bar) wasn't preserved after save and reload."
+ endif
+ printlog "Check that variant is 'stacked'"
+ iChartVariant = variant.GetSelIndex
+ iChartVariantText = variant.GetSelText(iChartVariant)
+ printlog "Check that the chart variant is 'Stacked' (2nd entry)"
+ if iChartVariant <> 2 then
+ warnlog "Instead of chart variant 'Stacked' (2) the variant " & iChartVariant & "(" & iChartVariantText & ") has been used - FAILED"
+ end if
+ printlog "Check the the '3D Look' box is checked"
+ if NOT Look3D.IsChecked then
+ warnlog "Check box 3D (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 3D look is 'simple' (=default)"
+ if Scheme3D.GetSelIndex <> 1 then
+ warnlog "Default 3D Look ('simple') has not been preserved after save and reload."
+ endif
+ printlog "Check that 3D shape 'cone' is selected"
+ if BarColumnShape.GetSelIndex <> 3 Then
+ warnlog "3D Shape CONE wasn't preserved after save and reload."
+ endif
+ Kontext "ChartType"
+ printlog "Leave dialog with CANCEL button."
+ ChartType.CANCEL
+ printlog "Invoke Format / Data Ranges"
+ FormatDataRanges
+ printlog "Goto tab-page Data Range"
+ printlog "Verify now the made settings in the 'Data Ranges' dialog:"
+ Kontext
+ Active.SetPage TabFormatDataRangesDataRange
+ Kontext "TabFormatDataRangesDataRange"
+ if TabFormatDataRangesDataRange.Exists(2) then
+ printlog "Check substrings $A$2:$E$13 and $A$17:$E$17 in 'Data Range'"
+ sControlString = DataRange.GetText
+ if instr ( sControlString , "$A$2:$E$13" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload and does not caontain $A$2:$E$13."
+ endif
+ if instr ( sControlString , "$A$17:$E$17" ) = 0 Then
+ warnlog "#i72241# - Data range wasn't correctly preserved after save and reload and does not contain $A$17:$E$17."
+ endif
+ printlog "Check that radio button 'rows' is checked"
+ if NOT Rows.IsChecked then
+ warnlog "Radio Button ROWS (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check that radio button 'columns is unchecked."
+ if Columns.IsChecked then
+ warnlog "Radio Button COLUMNS (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'First row as label' checkbox is unchecked"
+ if FirstRowAsLabel.IsChecked then
+ warnlog "Check box 'First row as label' (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'First column as label' checkbox is checked."
+ if NOT FirstColumnAsLabel.IsChecked then
+ warnlog "#i72241# - Check box 'First column as label' (enabled) wasn't preserved after save and reload."
+ endif
+ else
+ warnlog "Tab page 'Data Range' not visible!"
+ end if
+ printlog "Go to tab page 'Data Series'"
+ Kontext
+ Active.SetPage TabFormatDataRangesDataSeries
+ Kontext "TabFormatDataRangesDataSeries"
+ if TabFormatDataRangesDataSeries.Exists(2) then
+ printlog "Check if added range (13 in list on the left) was preserved."
+ if fSetListBoxByItem ( DataSeries , 13 ) > 0 then
+ warnlog "Selecting 13th item in Data Series seems to fail. Added range wasn't preserved."
+ else
+ printlog "Select 'Name'-entry in Data Ranges list on the right."
+ if fSetListBoxByItem ( DataRanges , 1 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 1."
+ else
+ printlog "Check that the string $A$17 exists in range for 'Name'"
+ sControlString = RangeFor.GetText
+ printlog "'Range for name' is: " & sControlString
+ if instr ( sControlString , "$A$17" ) = 0 Then
+ warnlog "#i72241# - 'Range for name' wasn't correctly preserved after save and reload."
+ else
+ printlog "Select 'Y-Values' in Data Ranges list on the right."
+ if fSetListBoxByItem ( DataRanges , 2 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 2."
+ else
+ printlog "Check that the string $B$17:$E$17 is in range for 'Y-Values'"
+ sControlString = RangeFor.GetText
+ if instr ( sControlString , "$B$17:$E$17" ) = 0 Then
+ warnlog "'Range for Y-Values' wasn't correctly preserved after save and reload."
+ endif
+ endif
+ endif
+ endif
+ endif
+ printlog "Close the dialog with 'cancel'-button"
+ TabFormatDataRangesDataSeries.Cancel
+ else
+ warnlog "Tab page 'Data series' not visible!"
+ end if
+ if fInvokeTitlesDialog() = 0 then
+ printlog "Insert / Title"
+ printlog "Verify now the made settings in the 'Titles' dialog:"
+ Kontext "InsertTitleDialog"
+ printlog "Check that 'Title' text field contains 'MyTitle'"
+ sControlString = MainTitle.GetText
+ if sControlString <> "MyTitle" then
+ warnlog "Title string 'MyTitle' wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Subtitle'text field contains 1 2 3"
+ sControlString = SubTitle.GetText
+ if sControlString <> "1 2 3" then
+ warnlog "Subtitle string '1 2 3' wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'X Title' text field contains Grått"
+ sControlString = TitleXAxis.GetText
+ printlog "'X Title' is: " & sControlString
+ if sControlString <> "Grått" then
+ warnlog "X Title string 'Grått' wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Y Title' text field contains 'Gräulich'"
+ sControlString = TitleYAxis.GetText
+ if sControlString <> "Gräulich" then
+ warnlog "Y Title string 'Gräulich' wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Z Title' text field contains 灰色"
+ sControlString = TitleZAxis.GetText
+ printlog "'Z Title' is: " & sControlString
+ if sControlString <> "灰色" then
+ warnlog "Z Title string '灰色' wasn't preserved after save and reload."
+ endif
+ printlog "Close the Title-dialog by pressing 'Cancel'-button"
+ InsertTitleDialog.Cancel
+ endif
+ if fInvokeGridsDialog() = 0 then
+ printlog "Insert / Grid"
+ Kontext "InsertGridsDialog"
+ printlog "Check that 'Main Grid X Axis' checkbox is checked"
+ if NOT MainGridXaxis.IsChecked then
+ warnlog "Check box 'Gridlines X Axis' (checked) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Main Grid Y Axis' checkbox is checked"
+ if MainGridYaxis.IsChecked then
+ warnlog "Check box 'Gridlines Y Axis' (unchecked) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Main Grid Z Axis' checkbox is checked"
+ if NOT MainGridZaxis.IsChecked then
+ warnlog "Check box 'Gridlines Z Axis' (checked) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Minor Grid X Axis' checkbox is unchecked"
+ if MinorGridXaxis.IsChecked then
+ warnlog "Check box 'Minor Grid X Axis' (unchecked) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Minor Grid Y Axis' checkbox is unchecked"
+ if MinorGridYaxis.IsChecked then
+ warnlog "Check box 'Minor Grid Y Axis' (unchecked) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Minor Grid Z Axis' checkbox is unchecked"
+ if MinorGridZaxis.IsChecked then
+ warnlog "Check box 'Minor Grid Z Axis' (unchecked) wasn't preserved after save and reload."
+ endif
+ printlog "Leave dialog with Cancel-button."
+ InsertGridsDialog.Cancel
+ endif
+ if fInvokeLegendDialog() = 0 then
+ printlog "Insert / Legend"
+ Kontext "InsertLegendDialog"
+ printlog "Check that 'Legend Display' checkbox is checked"
+ if NOT Display.IsChecked then
+ warnlog "Check box 'Legend Display' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check that 'Left' radio button is selected"
+ if NOT PositionLeft.IsChecked then
+ warnlog "Radio button 'Left' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Cancel InsertLegend-dialog"
+ Kontext "InsertLegendDialog"
+ InsertLegendDialog.Cancel
+ end if
+ Kontext "DocumentCalc"
+ DocumentCalc.TypeKeys "<Escape>"
+ printlog "Close document"
+ Call hCloseDocument
+endcase
+'
+'--------------------------------------------------------------------
+'
+testcase tCreateNewLineChart
+ dim sInputFile as STRING
+ dim sOutputFile as STRING
+ dim sControlString as STRING
+ sInputFile = convertpath ( gTesttoolPath & "chart2/level1/input/randomData.ods" )
+ sOutputFile = convertpath ( gOfficepath & "user/work/tCreateNewLineChart.ods" )
+ printlog "File / Load TesttoolPath/chart2/level1/input/randomData.ods"
+ call hFileOpen(sInputFile)
+ sleep(2)
+ printlog "Save document as Officepath/user/work/tCreateNewLineChart.ods"
+ if NOT hFileSaveAsWithFilterKill ( sOutputFile , "calc8" ) then
+ warnlog "Saving test document localy failed -> Aborting"
+ call hCloseDocument
+ goto endsub
+ endif
+ printlog "Insert / Chart"
+ InsertChart
+ printlog "Change Chart type to LINE (5th entry from the top)"
+ Kontext "ChartType"
+ if NOT ChartType.Exists(5) then
+ warnlog "Chart Wizard was not visible. EXITING!"
+ goto endsub
+ else
+ printlog "Chart Wizard visible."
+ end if
+ if fSetChartType ( "line" ) > 0 then
+ warnlog "Something went wrong setting chart type to LINE."
+ endif
+ printlog "Select 3rd Change chart type variant (lines only)"
+ if fSetChartTypeVariant ( 3 ) > 0 then
+ warnlog "Something went wrong setting chart type to 3rd variant (lines only)."
+ endif
+ printlog "Enable 'Stack Series' and select 'Percent'"
+ if fSetStackSeries ( "percent" ) > 0 then
+ warnlog "Something went wrong setting Stack Series to Percent."
+ endif
+ '/// Enable 'Smooth Lines'
+ printlog "Enable 'Smooth Lines'"
+ if fSetSmoothLines ( TRUE ) > 0 then
+ warnlog "Something went wrong enabling Smooth Lines."
+ endif
+ printlog "Invoke 'Smooth Lines' dialog"
+ if fInvokeSmoothLineProperties() > 0 then
+ warnlog "Something went wrong invoking Smooth Lines Dialog."
+ endif
+ printlog "Check B-Spline"
+ BSpline.check
+ printlog "Set Resolution to 33"
+ Resolution.SetText "33"
+ printlog "et Data Points Order to 5"
+ DataPointsOrder.SetText "5"
+ printlog "Close 'Smooth Lines' dialog"
+ if fCloseSmoothLinePropertiesOK() > 0 then
+ warnlog "Something went wrong closing Smooth Lines Dialog."
+ endif
+ printlog "Change to Data Range tab-page"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeDataRange"
+ printlog "Set Data Range text box to $Sheet1.$A$1:$F$13;$Sheet1.$A$17:$F$17"
+ if fSetTextBox ( DataRange , "$Sheet1.$A$1:$F$13;$Sheet1.$A$17:$F$17" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Change to Data Series tab-page"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeDataSeries"
+ printlog "Select 3rd entry in Data Series"
+ if fSetListBoxByItem ( DataSeries , 3 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Series' item No. 3."
+ endif
+ printlog "Remove series labeled 'John'"
+ RemoveButton.Click
+ printlog "Select 4th entry in Data Series"
+ if fSetListBoxByItem ( DataSeries , 4 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Series' item No. 4."
+ endif
+ printlog "Select 2nd entry in Data Ranges"
+ if fSetListBoxByItem ( DataRanges , 2 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 2."
+ endif
+ printlog "Set 'Range for Y-Values' text box to $Sheet1.$F$2:$F$13;$Sheet1.$D$17"
+ if fSetTextBox ( RangeFor , "$Sheet1.$F$2:$F$13;$Sheet1.$D$17" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Set 'Categories' text box to $Sheet1.$A$2:$A$13;$Sheet1.$A$1"
+ if fSetTextBox ( Categories , "$Sheet1.$A$2:$A$13;$Sheet1.$A$19" ) > 0 then
+ warnlog "Something went wrong setting Text."
+ endif
+ printlog "Change to Chart Elements tab-page"
+ Kontext "ChartWizard"
+ GoNext.Click
+ Kontext "TabChartTypeChartElements"
+ printlog "Uncheck 'Y Axis'"
+ if fSetCheckBox ( GridLinesYAxis , FALSE ) > 0 then
+ warnlog "Something went wrong unselecting 'Y Axis'."
+ endif
+ printlog "Uncheck 'Legend Display'"
+ if fSetCheckBox ( Display , FALSE ) > 0 then
+ warnlog "Something went wrong unselecting 'Legend Display'."
+ endif
+ printlog "Create Chart by clicking Finish-button"
+ Kontext "ChartWizard"
+ ChartWizard.OK
+ sleep(2)
+ printlog "File / Save"
+ FileSave
+ Kontext "DocumentCalc"
+ printlog "Press twice <ESCAPE>-key"
+ DocumentCalc.TypeKeys "<Escape>" , 2
+ printlog "File / Close document"
+ Call hCloseDocument
+ sleep(2)
+ printlog "Open saved file again"
+ call hFileOpen(sOutputFile)
+ sleep(2)
+ printlog "Open the Navigator (F5)"
+ printlog "Select the first OLE object in the Navigator"
+ call fSelectFirstOLE
+ printlog "Edit / Object / Edit to enter Inplace Mode"
+ EditObjectEdit
+ printlog "Format / Chart Type"
+ FormatChartType
+ Kontext "ChartType"
+ if ChartType.Exists(2) then
+ printlog "Check if chart type is LINE"
+ if ChooseType.GetSelIndex <> 5 then
+ warnlog "Selected chart type wasn't preserved after save and reload."
+ endif
+ printlog "Check if chart variant is LINES ONLY (third variant in non-CTL versions from the left)"
+ if Variant.GetSelIndex <> 3 then
+ warnlog "Selected chart type variant wasn't preserved after save and reload."
+ end if
+ printlog "Check if 'Stack Series' box is checked"
+ if NOT StackSeries.IsChecked then
+ warnlog "Check box 'Stack Series' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Percent' radio button is checked"
+ if NOT Percent.IsChecked then
+ warnlog "Radio button box 'Percent' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Smooth Lines' box is checked"
+ if NOT SmoothLines.IsChecked then
+ warnlog "Check box 'Smooth Lines' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Invoke 'Smooth Lines' dialog"
+ if fInvokeSmoothLineProperties() > 0 then
+ warnlog "Something went wrong invoking Smooth Lines dialog."
+ endif
+ printlog "Check if 'B-Spline' radio button is checked"
+ if NOT BSpline.IsChecked then
+ warnlog "Radio button box 'B-Spline' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Resolution' has value '33'"
+ if Resolution.GetText <> "33" then
+ warnlog "Value for Resolution '33' wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Data Points Order' has value '5'"
+ if DataPointsOrder.GetText <> "5" then
+ warnlog "Value for Data Points Order '5' wasn't preserved after save and reload."
+ endif
+ printlog "Close 'Smooth Lines' dialog"
+ if fCloseSmoothLinePropertiesOK() > 0 then
+ warnlog "Something went wrong closing Smooth Lines Dialog."
+ endif
+ printlog "Leave Chart Type dialog with Cancel"
+ Kontext "ChartType"
+ if ChartType.Exists(2) then
+ ChartType.Cancel
+ else
+ warnlog "ChartType dialog was not visible!?"
+ end if
+ else
+ warnlog "Chart Type dialog was not up!"
+ end if
+ printlog "Format / Data Ranges"
+ FormatDataRanges
+ Kontext
+ Active.SetPage TabChartTypeDataRange
+ Kontext "TabChartTypeDataRange"
+ if TabChartTypeDataRange.Exists(2) then
+ printlog "Check substrings '$A$2:$C$13', '$A$19', '$B$1:$C$13', '$E$1:$F$13' and '$B$17:$E$17' in Data Range"
+ sControlString = DataRange.GetText
+ printlog "Data Range is: " & sControlString
+ if instr ( sControlString , "$A$2:$C$13" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$A$19" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$B$1:$C$13" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$E$1:$F$13" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$B$17:$E$17" ) = 0 Then
+ warnlog "Data range wasn't correctly preserved after save and reload."
+ endif
+ printlog "Check if Radio Button ROWS is checked"
+ if Rows.IsChecked then
+ warnlog "Radio Button ROWS (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if Radio Button COLUMNS is unchecked"
+ if NOT Columns.IsChecked then
+ warnlog "Radio Button COLUMNS (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'First row as label' box is unchecked"
+ if NOT FirstRowAsLabel.IsChecked then
+ warnlog "Check box 'First row as label' (enabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'First column as label' box is checked"
+ if NOT FirstColumnAsLabel.IsChecked then
+ warnlog "Check box 'First column as label' (enabled) wasn't preserved after save and reload."
+ endif
+ else
+ warnlog "Tab page Data Range was not up!"
+ FormatDataRanges
+ end if
+ printlog "Switch to tab page Data Series"
+ Kontext
+ Active.SetPage TabFormatDataRangesDataSeries
+ Kontext "TabChartTypeDataSeries"
+ if TabChartTypeDataSeries.Exists(2) then
+ printlog "Select 4th entry in Data Series"
+ if fSetListBoxByItem ( DataSeries , 4 ) > 0 then
+ warnlog "Selecting 4th item in Data Series failed. EXITING!"
+ TabChartTypeDataSeries.Cancel
+ call hCloseDocument
+ goto endsub
+ endif
+ printlog "Select Name in Data Ranges"
+ if fSetListBoxByItem ( DataRanges , 1 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 1."
+ endif
+ printlog "Check substring '$F$1' in Range for Name"
+ sControlString = RangeFor.GetText
+ printlog "'Range for name' is: " & sControlString
+ if instr ( sControlString , "$F$1" ) = 0 Then
+ warnlog "'Range for name' wasn't correctly preserved after save and reload."
+ endif
+ printlog "Select Y-Values in Data Ranges"
+ if fSetListBoxByItem ( DataRanges , 2 ) > 0 then
+ warnlog "Something went wrong selecting 'Data Ranges' item No. 2. EXITING!"
+ TabChartTypeDataSeries.Cancel
+ call hCloseDocument
+ goto endsub
+ endif
+ printlog "Check substring '$F$2:$F$13' and '$D$17'in Range for Name"
+ sControlString = RangeFor.GetText
+ if instr ( sControlString , "$F$2:$F$13" ) = 0 Then
+ warnlog "'Range for Y-Values' wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$D$17" ) = 0 Then
+ warnlog "'Range for Y-Values' wasn't correctly preserved after save and reload."
+ endif
+ printlog "Check substring '$A$2:$A$13' and '$A$19'in Categories"
+ sControlString = Categories.GetText
+ if instr ( sControlString , "$A$2:$A$13" ) = 0 Then
+ warnlog "'Categories' wasn't correctly preserved after save and reload."
+ endif
+ if instr ( sControlString , "$A$19" ) = 0 Then
+ warnlog "'Categories' wasn't correctly preserved after save and reload."
+ endif
+ printlog "Leave tab page data series with CANCEL"
+ TabChartTypeDataSeries.Cancel
+ else
+ warnlog "Tab page Data Series was not up!"
+ end if
+ printlog "Insert / Title"
+ InsertTitle
+ Kontext "InsertTitleDialog"
+ if InsertTitleDialog.Exists(2) then
+ printlog "Check if 'Title' text box is empty"
+ sControlString = MainTitle.GetText
+ if sControlString <> "" then
+ warnlog "Empty Title string wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Subtitle' text box is empty"
+ sControlString = SubTitle.GetText
+ if sControlString <> "" then
+ warnlog "Empty Subtitle string wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'X Title' text box is empty"
+ sControlString = TitleXaxis.GetText
+ if sControlString <> "" then
+ warnlog "Empty X Title string wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Y Title' text box is empty"
+ sControlString = TitleYaxis.GetText
+ if sControlString <> "" then
+ warnlog "Empty Y Title string wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Z Title' text box is empty"
+ sControlString = TitleZaxis.GetText
+ if sControlString <> "" then
+ warnlog "Empty Z Title string wasn't preserved after save and reload."
+ endif
+ printlog "Leaving Title dialog with Cancel"
+ InsertTitleDialog.Cancel
+ else
+ warnlog "Title dialog was not up!"
+ end if
+ printlog "Insert / Grids"
+ If fInvokeGridsDialog = 0 then
+ Kontext "InsertGridsDialog"
+ printlog "Check if 'Gridlines X Axis' box is checked"
+ if MainGridXaxis.IsChecked then
+ warnlog "Check box 'Gridlines X Axis' (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Gridlines Y Axis' box is unchecked"
+ if MainGridYaxis.IsChecked then
+ warnlog "Check box 'Gridlines Y Axis' (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Check if 'Gridlines Z Axis' box is checked"
+ if MainGridZaxis.IsEnabled then
+ warnlog "Check box 'Gridlines Z Axis' shouldn't be enabled after save and reload."
+ endif
+ printlog "Leave dialog with CANCEL"
+ InsertGridsDialog.Cancel
+ else
+ warnlog "Insert Grids dialog was not up!"
+ end if
+ printlog "Insert / Legend"
+ if fInvokeLegendDialog() = 0 then
+ printlog "Check if 'Legend Display' box is checked"
+ Kontext "InsertLegendDialog"
+ if Display.IsChecked then
+ warnlog "Check box 'Legend Display' (disabled) wasn't preserved after save and reload."
+ endif
+ printlog "Leave dialog with CANCEL."
+ InsertLegendDialog.Cancel
+ else
+ warnlog "Insert Legend dialog was not up!"
+ end if
+ printlog "Press ESCAPE button (deselecting the OLE object)"
+ Kontext "DocumentCalc"
+ DocumentCalc.TypeKeys "<Escape>"
+ printlog "Close document"
+ Call hCloseDocument
+endcase
+
diff --git a/testautomation/chart2/optional/input/ods/2d_areas_normal.ods b/testautomation/chart2/optional/input/ods/2d_areas_normal.ods
new file mode 100755
index 000000000000..432d5edf3013
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_areas_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_areas_percent.ods b/testautomation/chart2/optional/input/ods/2d_areas_percent.ods
new file mode 100755
index 000000000000..6e4d8dd362f7
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_areas_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_areas_stacked.ods b/testautomation/chart2/optional/input/ods/2d_areas_stacked.ods
new file mode 100755
index 000000000000..ff47f9503829
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_areas_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_bars_normal.ods b/testautomation/chart2/optional/input/ods/2d_bars_normal.ods
new file mode 100755
index 000000000000..cd4d74737e4e
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_bars_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_bars_percent.ods b/testautomation/chart2/optional/input/ods/2d_bars_percent.ods
new file mode 100755
index 000000000000..0abeac786764
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_bars_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_bars_stacked.ods b/testautomation/chart2/optional/input/ods/2d_bars_stacked.ods
new file mode 100755
index 000000000000..865ce277e3de
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_bars_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_columns_lines_and_columns.ods b/testautomation/chart2/optional/input/ods/2d_columns_lines_and_columns.ods
new file mode 100755
index 000000000000..08c11fd62c3c
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_columns_lines_and_columns.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_columns_lines_and_stacked_columns.ods b/testautomation/chart2/optional/input/ods/2d_columns_lines_and_stacked_columns.ods
new file mode 100755
index 000000000000..43231f8b9277
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_columns_lines_and_stacked_columns.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_columns_normal.ods b/testautomation/chart2/optional/input/ods/2d_columns_normal.ods
new file mode 100755
index 000000000000..17c69191bb0d
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_columns_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_columns_percent.ods b/testautomation/chart2/optional/input/ods/2d_columns_percent.ods
new file mode 100755
index 000000000000..0e3d566095dc
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_columns_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/2d_columns_stacked.ods b/testautomation/chart2/optional/input/ods/2d_columns_stacked.ods
new file mode 100755
index 000000000000..aa336e6b5675
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/2d_columns_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/3d_lines_deep.ods b/testautomation/chart2/optional/input/ods/3d_lines_deep.ods
new file mode 100755
index 000000000000..935743967998
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/3d_lines_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/3d_pies_normal.ods b/testautomation/chart2/optional/input/ods/3d_pies_normal.ods
new file mode 100755
index 000000000000..e9744be8a22f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/3d_pies_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/areas_deep.ods b/testautomation/chart2/optional/input/ods/areas_deep.ods
new file mode 100755
index 000000000000..1b46933caacb
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/areas_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/areas_percent.ods b/testautomation/chart2/optional/input/ods/areas_percent.ods
new file mode 100755
index 000000000000..1852aba1b34f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/areas_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/areas_stacked.ods b/testautomation/chart2/optional/input/ods/areas_stacked.ods
new file mode 100755
index 000000000000..6fa37c09c281
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/areas_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_deep.ods b/testautomation/chart2/optional/input/ods/bars_deep.ods
new file mode 100755
index 000000000000..8c7f783085e8
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_cones.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_cones.ods
new file mode 100755
index 000000000000..1fa0961b3328
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_cones.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_cones_deep.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_cones_deep.ods
new file mode 100755
index 000000000000..15cacdd74eb5
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_cones_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_cones_percent.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_cones_percent.ods
new file mode 100755
index 000000000000..c541078f546a
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_cones_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids.ods
new file mode 100755
index 000000000000..b6e318cf64fa
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_deep.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_deep.ods
new file mode 100755
index 000000000000..2b803bef7d96
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_percent.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_percent.ods
new file mode 100755
index 000000000000..d6691f364e45
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_stacked.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_stacked.ods
new file mode 100755
index 000000000000..aa398472ae09
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_pyramids_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_horizontal_stacked_cones.ods b/testautomation/chart2/optional/input/ods/bars_horizontal_stacked_cones.ods
new file mode 100755
index 000000000000..30d4d212f305
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_horizontal_stacked_cones.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_normal.ods b/testautomation/chart2/optional/input/ods/bars_normal.ods
new file mode 100755
index 000000000000..ab347ca91d08
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_percent.ods b/testautomation/chart2/optional/input/ods/bars_percent.ods
new file mode 100755
index 000000000000..60e8bd419c46
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_stacked.ods b/testautomation/chart2/optional/input/ods/bars_stacked.ods
new file mode 100755
index 000000000000..07561d1ce18b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_tube.ods b/testautomation/chart2/optional/input/ods/bars_tube.ods
new file mode 100755
index 000000000000..413c6a8b7877
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_tube.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_tubes_deep.ods b/testautomation/chart2/optional/input/ods/bars_tubes_deep.ods
new file mode 100755
index 000000000000..fa4e40a643d9
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_tubes_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_tubes_percent.ods b/testautomation/chart2/optional/input/ods/bars_tubes_percent.ods
new file mode 100755
index 000000000000..06f9ef3c6cf4
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_tubes_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/bars_tubes_stacked.ods b/testautomation/chart2/optional/input/ods/bars_tubes_stacked.ods
new file mode 100755
index 000000000000..9e1799d2fe21
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/bars_tubes_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cones.ods b/testautomation/chart2/optional/input/ods/columns_cones.ods
new file mode 100755
index 000000000000..244f4a64796d
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cones.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cones_deep.ods b/testautomation/chart2/optional/input/ods/columns_cones_deep.ods
new file mode 100755
index 000000000000..7d8590521be1
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cones_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cones_percent.ods b/testautomation/chart2/optional/input/ods/columns_cones_percent.ods
new file mode 100755
index 000000000000..4c9929d2e7c9
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cones_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cones_stacked.ods b/testautomation/chart2/optional/input/ods/columns_cones_stacked.ods
new file mode 100755
index 000000000000..52e0d8bc811a
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cones_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cylinder.ods b/testautomation/chart2/optional/input/ods/columns_cylinder.ods
new file mode 100755
index 000000000000..6f60dabc72f5
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cylinder.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cylinder_deep.ods b/testautomation/chart2/optional/input/ods/columns_cylinder_deep.ods
new file mode 100755
index 000000000000..6d05c3839e67
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cylinder_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cylinder_percent.ods b/testautomation/chart2/optional/input/ods/columns_cylinder_percent.ods
new file mode 100755
index 000000000000..0e6219083d0d
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cylinder_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_cylinder_stacked.ods b/testautomation/chart2/optional/input/ods/columns_cylinder_stacked.ods
new file mode 100755
index 000000000000..0ef322eeab81
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_cylinder_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_deep.ods b/testautomation/chart2/optional/input/ods/columns_deep.ods
new file mode 100755
index 000000000000..671adc2cd1bc
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_normal.ods b/testautomation/chart2/optional/input/ods/columns_normal.ods
new file mode 100755
index 000000000000..779f498f4cb4
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_percent.ods b/testautomation/chart2/optional/input/ods/columns_percent.ods
new file mode 100755
index 000000000000..0792da4ee2fe
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_pyramids.ods b/testautomation/chart2/optional/input/ods/columns_pyramids.ods
new file mode 100755
index 000000000000..ed7f0c9b100a
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_pyramids.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_pyramids_deep.ods b/testautomation/chart2/optional/input/ods/columns_pyramids_deep.ods
new file mode 100755
index 000000000000..8b645c0ef65f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_pyramids_deep.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_pyramids_percent.ods b/testautomation/chart2/optional/input/ods/columns_pyramids_percent.ods
new file mode 100755
index 000000000000..227d767dbdb8
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_pyramids_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_pyramids_stacked.ods b/testautomation/chart2/optional/input/ods/columns_pyramids_stacked.ods
new file mode 100755
index 000000000000..21d805226a6c
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_pyramids_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/columns_stacked.ods b/testautomation/chart2/optional/input/ods/columns_stacked.ods
new file mode 100755
index 000000000000..1c1e4db7c567
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/columns_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_b-spline.ods b/testautomation/chart2/optional/input/ods/lines_b-spline.ods
new file mode 100755
index 000000000000..2464a7cd8991
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_b-spline.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_b-spline_with_symbols.ods b/testautomation/chart2/optional/input/ods/lines_b-spline_with_symbols.ods
new file mode 100755
index 000000000000..8b6eb5183b8f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_b-spline_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_cubic_spline.ods b/testautomation/chart2/optional/input/ods/lines_cubic_spline.ods
new file mode 100755
index 000000000000..18225f287c6b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_cubic_spline.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_cubic_spline_with_symbols.ods b/testautomation/chart2/optional/input/ods/lines_cubic_spline_with_symbols.ods
new file mode 100755
index 000000000000..af78f25b730f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_cubic_spline_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_normal.ods b/testautomation/chart2/optional/input/ods/lines_normal.ods
new file mode 100755
index 000000000000..8d8bac6e26f6
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_percent.ods b/testautomation/chart2/optional/input/ods/lines_percent.ods
new file mode 100755
index 000000000000..442ff79a0c37
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_percent_with_symbols.ods b/testautomation/chart2/optional/input/ods/lines_percent_with_symbols.ods
new file mode 100755
index 000000000000..eba0abb625a6
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_percent_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_stacked.ods b/testautomation/chart2/optional/input/ods/lines_stacked.ods
new file mode 100755
index 000000000000..e56af744c592
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_stacked_with_symbols.ods b/testautomation/chart2/optional/input/ods/lines_stacked_with_symbols.ods
new file mode 100755
index 000000000000..bdb045617c8b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_stacked_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/lines_symbols.ods b/testautomation/chart2/optional/input/ods/lines_symbols.ods
new file mode 100755
index 000000000000..63a1793c5695
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/lines_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_normal.ods b/testautomation/chart2/optional/input/ods/net_normal.ods
new file mode 100755
index 000000000000..51a93cceef3f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_percent.ods b/testautomation/chart2/optional/input/ods/net_percent.ods
new file mode 100755
index 000000000000..66d9e5dac017
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_percent.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_percent_with_symbols.ods b/testautomation/chart2/optional/input/ods/net_percent_with_symbols.ods
new file mode 100755
index 000000000000..07d8eac46f8f
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_percent_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_stacked.ods b/testautomation/chart2/optional/input/ods/net_stacked.ods
new file mode 100755
index 000000000000..933d1590dfa9
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_stacked.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_stacked_with_symbols.ods b/testautomation/chart2/optional/input/ods/net_stacked_with_symbols.ods
new file mode 100755
index 000000000000..529d97f765c5
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_stacked_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/net_symbols.ods b/testautomation/chart2/optional/input/ods/net_symbols.ods
new file mode 100755
index 000000000000..47e2c2fcab37
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/net_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/pies_normal.ods b/testautomation/chart2/optional/input/ods/pies_normal.ods
new file mode 100755
index 000000000000..2019ca4de8fc
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/pies_normal.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/pies_offset1.ods b/testautomation/chart2/optional/input/ods/pies_offset1.ods
new file mode 100755
index 000000000000..7a413717b281
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/pies_offset1.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/pies_offset2.ods b/testautomation/chart2/optional/input/ods/pies_offset2.ods
new file mode 100755
index 000000000000..aa879680e962
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/pies_offset2.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/pies_rings.ods b/testautomation/chart2/optional/input/ods/pies_rings.ods
new file mode 100755
index 000000000000..4103e6826132
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/pies_rings.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/stockchart_type1.ods b/testautomation/chart2/optional/input/ods/stockchart_type1.ods
new file mode 100755
index 000000000000..c04cf3b26423
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/stockchart_type1.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/stockchart_type2.ods b/testautomation/chart2/optional/input/ods/stockchart_type2.ods
new file mode 100755
index 000000000000..17192c26a2d7
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/stockchart_type2.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/stockchart_type3.ods b/testautomation/chart2/optional/input/ods/stockchart_type3.ods
new file mode 100755
index 000000000000..d826155f2f65
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/stockchart_type3.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/stockchart_type4.ods b/testautomation/chart2/optional/input/ods/stockchart_type4.ods
new file mode 100755
index 000000000000..5e501519df84
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/stockchart_type4.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_b-spline.ods b/testautomation/chart2/optional/input/ods/xy_chart_b-spline.ods
new file mode 100755
index 000000000000..7a2164686578
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_b-spline.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_b-spline_with_symbols.ods b/testautomation/chart2/optional/input/ods/xy_chart_b-spline_with_symbols.ods
new file mode 100755
index 000000000000..99475516a4a0
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_b-spline_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline.ods b/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline.ods
new file mode 100755
index 000000000000..a5acb4fc1c6b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline_with_symbols.ods b/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline_with_symbols.ods
new file mode 100755
index 000000000000..4baec96aed0b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_cubic_spline_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_lines_only.ods b/testautomation/chart2/optional/input/ods/xy_chart_lines_only.ods
new file mode 100755
index 000000000000..1011023b7aa4
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_lines_only.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_lines_with_symbols.ods b/testautomation/chart2/optional/input/ods/xy_chart_lines_with_symbols.ods
new file mode 100755
index 000000000000..78287f44f574
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_lines_with_symbols.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/ods/xy_chart_symbols_only.ods b/testautomation/chart2/optional/input/ods/xy_chart_symbols_only.ods
new file mode 100755
index 000000000000..f4db70209e4b
--- /dev/null
+++ b/testautomation/chart2/optional/input/ods/xy_chart_symbols_only.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/randomData.ods b/testautomation/chart2/optional/input/randomData.ods
new file mode 100755
index 000000000000..925a86f8a49b
--- /dev/null
+++ b/testautomation/chart2/optional/input/randomData.ods
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_areas_normal.sxc b/testautomation/chart2/optional/input/sxc/2d_areas_normal.sxc
new file mode 100755
index 000000000000..ab5dd29583ae
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_areas_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_areas_percent.sxc b/testautomation/chart2/optional/input/sxc/2d_areas_percent.sxc
new file mode 100755
index 000000000000..6916219fa143
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_areas_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_areas_stacked.sxc b/testautomation/chart2/optional/input/sxc/2d_areas_stacked.sxc
new file mode 100755
index 000000000000..e4fe98a1dee3
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_areas_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_bars_normal.sxc b/testautomation/chart2/optional/input/sxc/2d_bars_normal.sxc
new file mode 100755
index 000000000000..2369bd0e969e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_bars_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_bars_percent.sxc b/testautomation/chart2/optional/input/sxc/2d_bars_percent.sxc
new file mode 100755
index 000000000000..c824832c859c
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_bars_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_bars_stacked.sxc b/testautomation/chart2/optional/input/sxc/2d_bars_stacked.sxc
new file mode 100755
index 000000000000..6b8d6086bce9
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_bars_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_columns.sxc b/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_columns.sxc
new file mode 100755
index 000000000000..bf573430e041
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_columns.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_stacked_columns.sxc b/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_stacked_columns.sxc
new file mode 100755
index 000000000000..4c77436af381
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_columns_lines_and_stacked_columns.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_columns_normal.sxc b/testautomation/chart2/optional/input/sxc/2d_columns_normal.sxc
new file mode 100755
index 000000000000..485938995250
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_columns_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_columns_percent.sxc b/testautomation/chart2/optional/input/sxc/2d_columns_percent.sxc
new file mode 100755
index 000000000000..4db5741102d6
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_columns_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/2d_columns_stacked.sxc b/testautomation/chart2/optional/input/sxc/2d_columns_stacked.sxc
new file mode 100755
index 000000000000..2a564bb25102
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/2d_columns_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/3d_lines_deep.sxc b/testautomation/chart2/optional/input/sxc/3d_lines_deep.sxc
new file mode 100755
index 000000000000..477ec0340dc8
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/3d_lines_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/3d_pies_normal.sxc b/testautomation/chart2/optional/input/sxc/3d_pies_normal.sxc
new file mode 100755
index 000000000000..77697ab3b28b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/3d_pies_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/areas_deep.sxc b/testautomation/chart2/optional/input/sxc/areas_deep.sxc
new file mode 100755
index 000000000000..9e9d03add2b1
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/areas_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/areas_percent.sxc b/testautomation/chart2/optional/input/sxc/areas_percent.sxc
new file mode 100755
index 000000000000..907f6c65c1fb
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/areas_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/areas_stacked.sxc b/testautomation/chart2/optional/input/sxc/areas_stacked.sxc
new file mode 100755
index 000000000000..b6532d15b57e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/areas_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_deep.sxc b/testautomation/chart2/optional/input/sxc/bars_deep.sxc
new file mode 100755
index 000000000000..f359777754ad
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_cones.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones.sxc
new file mode 100755
index 000000000000..da42284992a0
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_deep.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_deep.sxc
new file mode 100755
index 000000000000..f1d8a29de3e2
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_percent.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_percent.sxc
new file mode 100755
index 000000000000..cd7fa1504398
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_cones_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids.sxc
new file mode 100755
index 000000000000..1b893e632963
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_deep.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_deep.sxc
new file mode 100755
index 000000000000..a6bc1035d3a0
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_percent.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_percent.sxc
new file mode 100755
index 000000000000..49df7edfbbd9
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_stacked.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_stacked.sxc
new file mode 100755
index 000000000000..006914bc5f1b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_pyramids_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_horizontal_stacked_cones.sxc b/testautomation/chart2/optional/input/sxc/bars_horizontal_stacked_cones.sxc
new file mode 100755
index 000000000000..340c5022a15f
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_horizontal_stacked_cones.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_normal.sxc b/testautomation/chart2/optional/input/sxc/bars_normal.sxc
new file mode 100755
index 000000000000..376dceb7e453
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_percent.sxc b/testautomation/chart2/optional/input/sxc/bars_percent.sxc
new file mode 100755
index 000000000000..23aa49beee9b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_stacked.sxc b/testautomation/chart2/optional/input/sxc/bars_stacked.sxc
new file mode 100755
index 000000000000..65f51089bd5d
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_tube.sxc b/testautomation/chart2/optional/input/sxc/bars_tube.sxc
new file mode 100755
index 000000000000..597bcd4b78c2
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_tube.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_tubes_deep.sxc b/testautomation/chart2/optional/input/sxc/bars_tubes_deep.sxc
new file mode 100755
index 000000000000..99a57cfa8b3e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_tubes_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_tubes_percent.sxc b/testautomation/chart2/optional/input/sxc/bars_tubes_percent.sxc
new file mode 100755
index 000000000000..9f380b773ade
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_tubes_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/bars_tubes_stacked.sxc b/testautomation/chart2/optional/input/sxc/bars_tubes_stacked.sxc
new file mode 100755
index 000000000000..785494e63b1b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/bars_tubes_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cones.sxc b/testautomation/chart2/optional/input/sxc/columns_cones.sxc
new file mode 100755
index 000000000000..a9c30a8162ef
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cones.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cones_deep.sxc b/testautomation/chart2/optional/input/sxc/columns_cones_deep.sxc
new file mode 100755
index 000000000000..e7752e61313b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cones_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cones_percent.sxc b/testautomation/chart2/optional/input/sxc/columns_cones_percent.sxc
new file mode 100755
index 000000000000..3b070374a1de
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cones_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cones_stacked.sxc b/testautomation/chart2/optional/input/sxc/columns_cones_stacked.sxc
new file mode 100755
index 000000000000..ed78861c0cdb
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cones_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cylinder.sxc b/testautomation/chart2/optional/input/sxc/columns_cylinder.sxc
new file mode 100755
index 000000000000..6c088275ba78
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cylinder.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cylinder_deep.sxc b/testautomation/chart2/optional/input/sxc/columns_cylinder_deep.sxc
new file mode 100755
index 000000000000..e5c686296111
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cylinder_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cylinder_percent.sxc b/testautomation/chart2/optional/input/sxc/columns_cylinder_percent.sxc
new file mode 100755
index 000000000000..69f60c5da039
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cylinder_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_cylinder_stacked.sxc b/testautomation/chart2/optional/input/sxc/columns_cylinder_stacked.sxc
new file mode 100755
index 000000000000..0e12cc60884e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_cylinder_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_deep.sxc b/testautomation/chart2/optional/input/sxc/columns_deep.sxc
new file mode 100755
index 000000000000..ab5ca7786370
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_normal.sxc b/testautomation/chart2/optional/input/sxc/columns_normal.sxc
new file mode 100755
index 000000000000..16c290525b0f
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_percent.sxc b/testautomation/chart2/optional/input/sxc/columns_percent.sxc
new file mode 100755
index 000000000000..c1df514a8401
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_pyramids.sxc b/testautomation/chart2/optional/input/sxc/columns_pyramids.sxc
new file mode 100755
index 000000000000..74fb0626c34c
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_pyramids.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_pyramids_deep.sxc b/testautomation/chart2/optional/input/sxc/columns_pyramids_deep.sxc
new file mode 100755
index 000000000000..1e4b7d3d0894
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_pyramids_deep.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_pyramids_percent.sxc b/testautomation/chart2/optional/input/sxc/columns_pyramids_percent.sxc
new file mode 100755
index 000000000000..756328be651d
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_pyramids_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_pyramids_stacked.sxc b/testautomation/chart2/optional/input/sxc/columns_pyramids_stacked.sxc
new file mode 100755
index 000000000000..e63eca4c6dbc
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_pyramids_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/columns_stacked.sxc b/testautomation/chart2/optional/input/sxc/columns_stacked.sxc
new file mode 100755
index 000000000000..385bb61adf5c
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/columns_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_b-spline.sxc b/testautomation/chart2/optional/input/sxc/lines_b-spline.sxc
new file mode 100755
index 000000000000..9ae37f5f2710
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_b-spline.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_b-spline_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/lines_b-spline_with_symbols.sxc
new file mode 100755
index 000000000000..49b2aa51c7d3
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_b-spline_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_cubic_spline.sxc b/testautomation/chart2/optional/input/sxc/lines_cubic_spline.sxc
new file mode 100755
index 000000000000..6d644b8c9143
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_cubic_spline.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_cubic_spline_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/lines_cubic_spline_with_symbols.sxc
new file mode 100755
index 000000000000..a3e97a939aa3
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_cubic_spline_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_normal.sxc b/testautomation/chart2/optional/input/sxc/lines_normal.sxc
new file mode 100755
index 000000000000..f86c92c3930e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_percent.sxc b/testautomation/chart2/optional/input/sxc/lines_percent.sxc
new file mode 100755
index 000000000000..b569c4386d48
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_percent_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/lines_percent_with_symbols.sxc
new file mode 100755
index 000000000000..0db3d31a87c2
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_percent_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_stacked.sxc b/testautomation/chart2/optional/input/sxc/lines_stacked.sxc
new file mode 100755
index 000000000000..9ee264e1a4a0
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_stacked_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/lines_stacked_with_symbols.sxc
new file mode 100755
index 000000000000..31f0e0b25e35
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_stacked_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/lines_symbols.sxc b/testautomation/chart2/optional/input/sxc/lines_symbols.sxc
new file mode 100755
index 000000000000..ed4cd005d3da
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/lines_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_normal.sxc b/testautomation/chart2/optional/input/sxc/net_normal.sxc
new file mode 100755
index 000000000000..b2c743bcc4a5
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_percent.sxc b/testautomation/chart2/optional/input/sxc/net_percent.sxc
new file mode 100755
index 000000000000..470bb6159fb7
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_percent.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_percent_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/net_percent_with_symbols.sxc
new file mode 100755
index 000000000000..531c2ba2bffc
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_percent_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_stacked.sxc b/testautomation/chart2/optional/input/sxc/net_stacked.sxc
new file mode 100755
index 000000000000..b9b394c96c26
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_stacked.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_stacked_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/net_stacked_with_symbols.sxc
new file mode 100755
index 000000000000..4452396dd5df
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_stacked_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/net_symbols.sxc b/testautomation/chart2/optional/input/sxc/net_symbols.sxc
new file mode 100755
index 000000000000..95b281278d68
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/net_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/pies_normal.sxc b/testautomation/chart2/optional/input/sxc/pies_normal.sxc
new file mode 100755
index 000000000000..8e4e16bcda57
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/pies_normal.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/pies_offset1.sxc b/testautomation/chart2/optional/input/sxc/pies_offset1.sxc
new file mode 100755
index 000000000000..f3aad332ff4e
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/pies_offset1.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/pies_offset2.sxc b/testautomation/chart2/optional/input/sxc/pies_offset2.sxc
new file mode 100755
index 000000000000..87a3e8aa8e21
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/pies_offset2.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/pies_rings.sxc b/testautomation/chart2/optional/input/sxc/pies_rings.sxc
new file mode 100755
index 000000000000..35f1a62b6105
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/pies_rings.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/stockchart_type1.sxc b/testautomation/chart2/optional/input/sxc/stockchart_type1.sxc
new file mode 100755
index 000000000000..3171dd3f27dd
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/stockchart_type1.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/stockchart_type2.sxc b/testautomation/chart2/optional/input/sxc/stockchart_type2.sxc
new file mode 100755
index 000000000000..fbb79d452749
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/stockchart_type2.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/stockchart_type3.sxc b/testautomation/chart2/optional/input/sxc/stockchart_type3.sxc
new file mode 100755
index 000000000000..27d23cce0264
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/stockchart_type3.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/stockchart_type4.sxc b/testautomation/chart2/optional/input/sxc/stockchart_type4.sxc
new file mode 100755
index 000000000000..d5ffa43c9f53
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/stockchart_type4.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_b-spline.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_b-spline.sxc
new file mode 100755
index 000000000000..7f389fa11a21
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_b-spline.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_b-spline_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_b-spline_with_symbols.sxc
new file mode 100755
index 000000000000..fb371cd3a767
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_b-spline_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline.sxc
new file mode 100755
index 000000000000..cfcca1e86de2
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline_with_symbols.sxc
new file mode 100755
index 000000000000..a545222de37d
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_cubic_spline_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_lines_only.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_lines_only.sxc
new file mode 100755
index 000000000000..73c0868ed3ad
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_lines_only.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_lines_with_symbols.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_lines_with_symbols.sxc
new file mode 100755
index 000000000000..c6014942b630
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_lines_with_symbols.sxc
Binary files differ
diff --git a/testautomation/chart2/optional/input/sxc/xy_chart_symbols_only.sxc b/testautomation/chart2/optional/input/sxc/xy_chart_symbols_only.sxc
new file mode 100755
index 000000000000..de39abd4ed1b
--- /dev/null
+++ b/testautomation/chart2/optional/input/sxc/xy_chart_symbols_only.sxc
Binary files differ