def setAxisRange(self, axis_name, min_val=None, max_val=None, plot_sheetname=None):
"""
Generic routine used by setXrange, setYrange and setY2range. (Not called by User)
Set the Axis range of the named plot to min_val, max_val.
* If no plot_sheetname is provided, use the latest plot (if any).
* If no min_val is provided, ignore it.
* If no max_val is provided, ignore it.
"""
# use latest plot_sheetname if no name is provided
if plot_sheetname is None:
plot_sheetname = self.ordered_plotL[-1]
plotSheetObj = self.plot_sheet_objD[plot_sheetname]
chart_obj = plotSheetObj.chart_obj
nsOD = chart_obj.rev_nsOD
auto_styles = chart_obj.find('office:automatic-styles')
minmax_style,ipos_minmax_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'%s'%axis_name}, nth_match=0)
#print( 'FOUND: ipos_minmax_style = ', ipos_minmax_style )
chart_prop = minmax_style.find( NS('style:chart-properties', nsOD) )
if not min_val is None:
chart_prop.set( NS('chart:minimum', nsOD), '%g'%min_val )
self.add_tag( NS('chart:minimum', nsOD), chart_obj )
if not max_val is None:
chart_prop.set( NS('chart:maximum', nsOD), '%g'%max_val )
self.add_tag( NS('chart:maximum', nsOD), chart_obj )
def setAxisRange(self,
axis_name,
min_val=None,
max_val=None,
plot_sheetname=None):
"""
Generic routine used by setXrange, setYrange and setY2range. (Not called by User)
Set the Axis range of the named plot to min_val, max_val.
* If no plot_sheetname is provided, use the latest plot (if any).
* If no min_val is provided, ignore it.
* If no max_val is provided, ignore it.
"""
# use latest plot_sheetname if no name is provided
if plot_sheetname is None:
plot_sheetname = self.ordered_plotL[-1]
plotSheetObj = self.plot_sheet_objD[plot_sheetname]
chart_obj = plotSheetObj.chart_obj
nsOD = chart_obj.rev_nsOD
auto_styles = chart_obj.find('office:automatic-styles')
minmax_style, ipos_minmax_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': '%s' % axis_name},
nth_match=0)
#print( 'FOUND: ipos_minmax_style = ', ipos_minmax_style )
chart_prop = minmax_style.find(NS('style:chart-properties', nsOD))
if not min_val is None:
chart_prop.set(NS('chart:minimum', nsOD), '%g' % min_val)
self.add_tag(NS('chart:minimum', nsOD), chart_obj)
if not max_val is None:
chart_prop.set(NS('chart:maximum', nsOD), '%g' % max_val)
self.add_tag(NS('chart:maximum', nsOD), chart_obj)
def build_chart_object_content(chart_obj, plotSheetObj):
"""When chart_obj is input, it still holds values from the original template"""
chart = chart_obj.find('office:body/office:chart/chart:chart')
plotSheetObj.chart_obj = chart_obj
nsOD = chart_obj.rev_nsOD
doc = plotSheetObj.document
def set_new_tag(elem, shortname, value):
"""
Adds shortname to qnames and sets attrib variable on elem
shortname format is "chart:symbol-type"
"""
doc.add_tag(NS(shortname, nsOD), plotSheetObj.chart_obj)
elem.set(NS(shortname, nsOD), value)
title = chart.find('chart:title/text:p', nsOD)
#print( 'title.text = ',title.text)
title.text = plotSheetObj.title
plot_area = chart.find('chart:plot-area', nsOD)
#print( 'plot_area =',plot_area )
axisL = plot_area.findall('chart:axis', nsOD)
#print( 'axisL =',axisL )
xaxis = None
yaxis = None
x2axis = None
y2axis = None
for axis in axisL:
dim_xy = axis.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}dimension')
dim_name = axis.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}name')
#print( 'dim_xy =',dim_xy )
if dim_xy == 'x' and dim_name == 'primary-x':
xaxis = axis
if dim_xy == 'y' and dim_name == 'primary-y':
yaxis = axis
# ODDLY... Excel uses capital X in "secondary-X" label
#if dim_xy == 'x' and dim_name.startswith('secondary'):
# x2axis = axis
if dim_xy == 'y' and dim_name.startswith('secondary'):
y2axis = axis
xtitle = xaxis.find('chart:title/text:p', nsOD)
ytitle = yaxis.find('chart:title/text:p', nsOD)
xUnitsStr, yUnitsStr, y2UnitsStr = get_all_units_on_chart(plotSheetObj)
if plotSheetObj.showUnits:
xtitle.text = plotSheetObj.xlabel + xUnitsStr
else:
xtitle.text = plotSheetObj.xlabel
if plotSheetObj.showUnits and plotSheetObj.ycolL:
ytitle.text = plotSheetObj.ylabel + yUnitsStr
else:
ytitle.text = plotSheetObj.ylabel
# Look for secondary y axis
if plotSheetObj.ycol2L:
y2title = y2axis.find('chart:title/text:p', nsOD)
if plotSheetObj.showUnits:
y2title.text = plotSheetObj.y2label + y2UnitsStr
else:
y2title.text = plotSheetObj.y2label
chart_seriesL = plot_area.findall('chart:series', nsOD)
y_series = None
y2_series = None
for c_series in chart_seriesL:
axis_name = c_series.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}attached-axis')
if axis_name == 'primary-y':
y_series = c_series
if axis_name == 'secondary-y':
y2_series = c_series
#print( 'y2_series =',y2_series )
# =============== Primary Y Axis =========================
series_label_cell_address = y_series.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address')
#print( 'series_label_cell_address =',series_label_cell_address)
series_value_cell_range = y_series.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address'
)
#print( 'series_value_cell_range =',series_value_cell_range)
ycol = plotSheetObj.ycolL[0]
col_letter = get_col_letters_from_number(ycol)
sht_name = plotSheetObj.ycolDataSheetNameL[0]
dataTableObj = doc.data_table_objD[sht_name]
val_cell_range = '%s.$%s$3:.$%s$%i' % (sht_name, col_letter, col_letter,
dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1' % (sht_name, col_letter)
y_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',
lab_cell)
y_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',
val_cell_range)
chart_domain = y_series.find('chart:domain', nsOD)
chart_data_point = y_series.find('chart:data-point', nsOD)
#print( chart_domain.items())
#print( chart_data_point.items())
xcol = plotSheetObj.xcolL[0]
xcol_letter = get_col_letters_from_number(xcol)
xval_cell_range = '%s.$%s$3:.$%s$%i' % (sht_name, xcol_letter, xcol_letter,
dataTableObj.nrows)
chart_domain.set(
'{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',
xval_cell_range)
chart_data_point.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}repeated',
'%i' % (dataTableObj.nrows - 2, ))
# Look for logarithmic X Axis
if plotSheetObj.logx:
auto_styles = chart_obj.find('office:automatic-styles')
# Find "Axs0"
logx_style, ipos_logx_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'Axs0'},
nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
chart_prop = logx_style.find(NS('style:chart-properties', nsOD))
chart_prop.attrib = NS_attrib(
{
"chart:display-label": "true",
"chart:link-data-style-to-source": "true",
"chart:logarithmic": "true",
"chart:tick-marks-major-inner": "false",
"chart:tick-marks-major-outer": "true",
"chart:tick-marks-minor-inner": "true",
"chart:tick-marks-minor-outer": "true",
"chart:visible": "true"
}, nsOD)
# Find "GMa0"
logx_style, ipos_logx_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'GMa0'},
nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
stroke_style = logx_style.find(NS('style:graphic-properties', nsOD))
stroke_style.set(NS('draw:stroke', nsOD), 'solid')
del stroke_style.attrib[NS('draw:stroke-dash', nsOD)]
# Find "G0S0"
logx_style, ipos_logx_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'G0S0'},
nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
new_elem_1 = ET.SubElement(
auto_styles,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family',
'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name',
'GMi0')
]))
new_elem_2 = ET.SubElement(
new_elem_1,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill',
'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke',
'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash',
'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width',
'0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color',
'#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity',
'100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin',
'round')
]))
# Add minor grid to xaxis
new_elem_3 = ET.SubElement(
xaxis,
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class',
'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name',
'GMi0')
]))
if plotSheetObj.ycolL and len(plotSheetObj.ycolL) >= 1:
auto_styles = chart_obj.find('office:automatic-styles')
autostyleL = auto_styles.findall('style:style', nsOD)
ref_series_style = None
istyle_loc = 0
for iloc, astyle in enumerate(autostyleL):
if astyle.get(
'{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name'
) == 'G0S0':
ref_series_style = astyle
istyle_loc = iloc + 2
# graphic-properties
elem = ref_series_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.colorL[0]
if not c is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color",
c)
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color",
c)
w = plotSheetObj.lineThkL[0]
if not w is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width",
w)
if not plotSheetObj.showLineL[0]:
#elem.attrib.clear()
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
# we're showing the line, should it have a style???
i_style = plotSheetObj.lineStyleL[0]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD),
get_dash_a_name(i_style))
elem.set(NS("draw:stroke", nsOD), 'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
# .............. Failed Experiment ...................
#doc.add_tag(NS("draw:symbol-color", nsOD), plotSheetObj.chart_obj)
#elem.set(NS("draw:symbol-color", nsOD), "#999999")
#doc.add_tag(NS("draw:fill-color", nsOD), plotSheetObj.chart_obj)
#elem.set(NS("draw:fill-color", nsOD), "#999999")
#elem.set(NS("draw:fill", nsOD), "solid")
# chart-properties
elem = ref_series_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarkerL[
0]: # showMarkerL is guaranteed to have same dimension as ycolL
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"automatic")
else:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"none")
for at in [
NS("chart:symbol-name", nsOD),
NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)
]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLineL[0]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name",
plotSheetObj.markerTypeL[0])
hw = plotSheetObj.markerHtWdL[0]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
# Look for logarithmic scale on primary y
if plotSheetObj.logy:
#print( 'Got log y' )
# Find "Axs1"
logy_style, ipos_logy_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'Axs1'},
nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
chart_prop = logy_style.find(NS('style:chart-properties', nsOD))
chart_prop.set(NS("chart:logarithmic", nsOD), "true")
chart_prop.set(NS("chart:tick-marks-minor-inner", nsOD), "true")
chart_prop.set(NS("chart:tick-marks-minor-outer", nsOD), "true")
# Find "GMa1"
logy_style, ipos_logy_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'GMa1'},
nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
logy_style.set(NS("draw:stroke", nsOD), "dash")
# Find "G0S1"
logy_style, ipos_logy_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'G0S1'},
nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
new_elem_1 = ET.SubElement(
auto_styles,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family',
'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name',
'GMi1')
]))
new_elem_2 = ET.SubElement(
new_elem_1,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill',
'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke',
'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash',
'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width',
'0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color',
'#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity',
'100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin',
'round')
]))
# Add minor grid to yaxis
new_elem_3 = ET.SubElement(
yaxis,
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class',
'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name',
'GMi1')
]))
#print( ref_series_style.items())
nG0S = 1
for ycol in plotSheetObj.ycolL[1:]:
new_style = deepcopy(ref_series_style)
new_style.set(
'{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name',
'G0S%i' % nG0S)
elem = new_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.colorL[nG0S]
if not c is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color",
c)
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color",
c)
w = plotSheetObj.lineThkL[nG0S]
if not w is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width",
w)
if not plotSheetObj.showLineL[nG0S]:
#elem.attrib.clear()
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyleL[nG0S]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD),
get_dash_a_name(i_style))
elem.set(NS("draw:stroke", nsOD), 'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = new_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarkerL[
nG0S]: # showMarkerL is guaranteed to have same dimension as ycolL
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"automatic")
else:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"none")
for at in [
NS("chart:symbol-name", nsOD),
NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)
]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLineL[nG0S]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name",
plotSheetObj.markerTypeL[nG0S])
hw = plotSheetObj.markerHtWdL[nG0S]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
auto_styles.insert(istyle_loc, new_style)
istyle_loc += 1
new_chart_series = deepcopy(y_series)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name',
'G0S%i' % nG0S)
col_letter = get_col_letters_from_number(ycol)
sht_name = plotSheetObj.ycolDataSheetNameL[nG0S]
dataTableObj = doc.data_table_objD[sht_name]
val_cell_range = '%s.$%s$3:.$%s$%i' % (
sht_name, col_letter, col_letter, dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1' % (sht_name, col_letter)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',
lab_cell)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',
val_cell_range)
xcol = plotSheetObj.xcolL[nG0S]
xcol_letter = get_col_letters_from_number(xcol)
xval_cell_range = '%s.$%s$3:.$%s$%i' % (
sht_name, xcol_letter, xcol_letter, dataTableObj.nrows)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',
xval_cell_range)
#ipos = len(plot_area)-1
#plot_area.insert(ipos, new_chart_series )
insert_below_series_named('G0S%i' % (nG0S - 1, ), new_chart_series,
plot_area)
nG0S += 1
# =============== Secondary Y Axis =========================
# Look for secondary y axis
if (plotSheetObj.ycol2L is not None) and (len(plotSheetObj.ycol2L) > 0):
series_label_cell_address = y2_series.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address'
)
#print( 'Y2 series_label_cell_address =',series_label_cell_address)
series_value_cell_range = y2_series.get(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address'
)
#print( 'Y2 series_value_cell_range =',series_value_cell_range)
ycol = plotSheetObj.ycol2L[0]
col_letter = get_col_letters_from_number(ycol)
sht_name = plotSheetObj.ycol2_DataSheetNameL[0]
dataTableObj = doc.data_table_objD[sht_name]
val_cell_range = '%s.$%s$3:.$%s$%i' % (sht_name, col_letter,
col_letter, dataTableObj.nrows)
#print( 'Y2 val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1' % (sht_name, col_letter)
y2_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',
lab_cell)
y2_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',
val_cell_range)
chart_domain = y2_series.find('chart:domain', nsOD)
chart_data_point = y2_series.find('chart:data-point', nsOD)
#print( chart_domain.items())
#print( chart_data_point.items())
xcol = plotSheetObj.xcol2L[0]
xcol_letter = get_col_letters_from_number(xcol)
xval_cell_range = '%s.$%s$3:.$%s$%i' % (
sht_name, xcol_letter, xcol_letter, dataTableObj.nrows)
chart_domain.set(
'{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',
xval_cell_range)
chart_data_point.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}repeated',
'%i' % (dataTableObj.nrows - 2, ))
# Look for logarithmic scale on primary y
if plotSheetObj.log2y:
#print( 'Got log on secondary y' )
# Find "Axs2"
logy_style, ipos_logy_style = find_elem_w_attrib(
'style:style',
auto_styles,
nsOD,
attrib={'style:name': 'Axs2'},
nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
chart_prop = logy_style.find(NS('style:chart-properties', nsOD))
chart_prop.set(NS("chart:logarithmic", nsOD), "true")
chart_prop.set(NS("chart:tick-marks-minor-inner", nsOD), "true")
chart_prop.set(NS("chart:tick-marks-minor-outer", nsOD), "true")
# Make "GMi2"
new_elem_1 = ET.SubElement(
auto_styles,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family',
'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name',
'GMi2')
]))
# Looks better with only one set of y grids... Seems obvious now
if 0: #plotSheetObj.ycolL and (not plotSheetObj.logy):
new_elem_2 = ET.SubElement(
new_elem_1,
"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill',
'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke',
'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash',
'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width',
'0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color',
'#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity',
'100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin',
'round')
]))
# Add minor grid to yaxis
new_elem_3 = ET.SubElement(
y2axis,
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class',
'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name',
'GMi2')
]))
# If more than one curve on secondary y...
if len(plotSheetObj.ycol2L) >= 1:
auto_styles = chart_obj.find('office:automatic-styles')
autostyleL = auto_styles.findall('style:style', nsOD)
ref_series_style = None
istyle_loc = 0
for iloc, astyle in enumerate(autostyleL):
if astyle.get(
'{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name'
) == 'G1S0':
ref_series_style = astyle
istyle_loc = iloc + 2
elem = ref_series_style.find("style:graphic-properties",
nsOD)
c = plotSheetObj.color2L[0]
if not c is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color",
c)
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color",
c)
w = plotSheetObj.lineThk2L[0]
if not w is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width",
w)
if not plotSheetObj.showLine2L[0]:
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyle2L[0]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD),
get_dash_a_name(i_style))
elem.set(NS("draw:stroke", nsOD), 'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = ref_series_style.find("style:chart-properties",
nsOD)
if plotSheetObj.showMarkerL[
0]: # showMarkerL is guaranteed to have same dimension as ycol2L
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"automatic")
else:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"none")
for at in [
NS("chart:symbol-name", nsOD),
NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)
]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLine2L[0]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name",
plotSheetObj.markerType2L[0])
hw = plotSheetObj.markerHtWd2L[0]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
plotSheetObj.ref_series_style2 = ref_series_style
#print( ref_series_style.items())
nG1S = 1
for ycol in plotSheetObj.ycol2L[1:]:
new_style = deepcopy(ref_series_style)
new_style.set(
'{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name',
'G1S%i' % nG1S)
elem = new_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.color2L[nG1S]
if not c is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color",
c)
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color",
c)
w = plotSheetObj.lineThk2L[nG1S]
if not w is None:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width",
w)
if not plotSheetObj.showLine2L[nG1S]:
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyle2L[nG1S]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD),
get_dash_a_name(i_style))
elem.set(NS("draw:stroke", nsOD), 'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = new_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarker2L[
nG1S]: # showMarkerL is guaranteed to have same dimension as ycol2L
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"automatic")
else:
elem.set(
"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type",
"none")
for at in [
NS("chart:symbol-name", nsOD),
NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)
]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLine2L[nG1S]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name",
plotSheetObj.markerType2L[nG1S])
hw = plotSheetObj.markerHtWd2L[nG1S]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
auto_styles.insert(istyle_loc, new_style)
istyle_loc += 1
new_chart_series = deepcopy(y2_series)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name',
'G1S%i' % nG1S)
col_letter = get_col_letters_from_number(ycol)
sht_name = plotSheetObj.ycol2_DataSheetNameL[nG1S]
dataTableObj = doc.data_table_objD[sht_name]
val_cell_range = '%s.$%s$3:.$%s$%i' % (
sht_name, col_letter, col_letter, dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1' % (sht_name, col_letter)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',
lab_cell)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',
val_cell_range)
xcol = plotSheetObj.xcol2L[nG1S]
xcol_letter = get_col_letters_from_number(xcol)
xval_cell_range = '%s.$%s$3:.$%s$%i' % (
sht_name, xcol_letter, xcol_letter, dataTableObj.nrows)
new_chart_series.set(
'{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',
xval_cell_range)
ipos = len(plot_area) - 1
plot_area.insert(ipos, new_chart_series)
nG1S += 1
#plot_area._children.sort( key=lambda child: child.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name', '0') )
plotSheetObj.istyle_loc = istyle_loc
plotSheetObj.y_series = y_series
plotSheetObj.chart_obj = chart_obj
def build_chart_object_content( chart_obj, plotSheetObj ):
"""When chart_obj is input, it still holds values from the original template"""
chart = chart_obj.find('office:body/office:chart/chart:chart')
plotSheetObj.chart_obj = chart_obj
nsOD = chart_obj.rev_nsOD
doc = plotSheetObj.document
def set_new_tag(elem, shortname, value):
"""
Adds shortname to qnames and sets attrib variable on elem
shortname format is "chart:symbol-type"
"""
doc.add_tag(NS(shortname, nsOD), plotSheetObj.chart_obj)
elem.set(NS(shortname, nsOD), value)
title = chart.find('chart:title/text:p', nsOD)
#print( 'title.text = ',title.text)
title.text = plotSheetObj.title
plot_area = chart.find('chart:plot-area', nsOD)
#print( 'plot_area =',plot_area )
axisL = plot_area.findall('chart:axis', nsOD)
#print( 'axisL =',axisL )
xaxis = None
yaxis = None
x2axis = None
y2axis = None
for axis in axisL:
dim_xy = axis.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}dimension')
dim_name = axis.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}name')
#print( 'dim_xy =',dim_xy )
if dim_xy == 'x' and dim_name == 'primary-x':
xaxis = axis
if dim_xy == 'y' and dim_name == 'primary-y':
yaxis = axis
# ODDLY... Excel uses capital X in "secondary-X" label
#if dim_xy == 'x' and dim_name.startswith('secondary'):
# x2axis = axis
if dim_xy == 'y' and dim_name.startswith('secondary'):
y2axis = axis
xtitle = xaxis.find('chart:title/text:p', nsOD)
ytitle = yaxis.find('chart:title/text:p', nsOD)
xUnitsStr, yUnitsStr, y2UnitsStr = get_all_units_on_chart( plotSheetObj )
if plotSheetObj.showUnits:
xtitle.text = plotSheetObj.xlabel + xUnitsStr
else:
xtitle.text = plotSheetObj.xlabel
if plotSheetObj.showUnits and plotSheetObj.ycolL:
ytitle.text = plotSheetObj.ylabel + yUnitsStr
else:
ytitle.text = plotSheetObj.ylabel
# Look for secondary y axis
if plotSheetObj.ycol2L:
y2title = y2axis.find('chart:title/text:p', nsOD)
if plotSheetObj.showUnits:
y2title.text = plotSheetObj.y2label + y2UnitsStr
else:
y2title.text = plotSheetObj.y2label
chart_seriesL = plot_area.findall('chart:series', nsOD)
y_series = None
y2_series = None
for c_series in chart_seriesL:
axis_name = c_series.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}attached-axis')
if axis_name == 'primary-y':
y_series = c_series
if axis_name == 'secondary-y':
y2_series = c_series
#print( 'y2_series =',y2_series )
# =============== Primary Y Axis =========================
series_label_cell_address = y_series.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address')
#print( 'series_label_cell_address =',series_label_cell_address)
series_value_cell_range = y_series.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address')
#print( 'series_value_cell_range =',series_value_cell_range)
ycol = plotSheetObj.ycolL[0]
col_letter = get_col_letters_from_number( ycol )
sht_name = plotSheetObj.ycolDataSheetNameL[0]
dataTableObj = doc.data_table_objD[ sht_name ]
val_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,col_letter,col_letter,dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1'%(sht_name, col_letter)
y_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',lab_cell)
y_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',val_cell_range)
chart_domain = y_series.find('chart:domain', nsOD)
chart_data_point = y_series.find('chart:data-point', nsOD)
#print( chart_domain.items())
#print( chart_data_point.items())
xcol = plotSheetObj.xcolL[0]
xcol_letter = get_col_letters_from_number( xcol )
xval_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,xcol_letter,xcol_letter,dataTableObj.nrows)
chart_domain.set('{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',xval_cell_range)
chart_data_point.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}repeated','%i'%(dataTableObj.nrows-2,))
# Look for logarithmic X Axis
if plotSheetObj.logx:
auto_styles = chart_obj.find('office:automatic-styles')
# Find "Axs0"
logx_style,ipos_logx_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'Axs0'}, nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
chart_prop = logx_style.find( NS('style:chart-properties', nsOD) )
chart_prop.attrib = NS_attrib({ "chart:display-label":"true", "chart:link-data-style-to-source":"true",
"chart:logarithmic":"true", "chart:tick-marks-major-inner":"false", "chart:tick-marks-major-outer":"true",
"chart:tick-marks-minor-inner":"true", "chart:tick-marks-minor-outer":"true", "chart:visible":"true"}, nsOD)
# Find "GMa0"
logx_style,ipos_logx_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'GMa0'}, nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
stroke_style = logx_style.find( NS('style:graphic-properties', nsOD) )
stroke_style.set( NS('draw:stroke', nsOD), 'solid' )
del stroke_style.attrib[ NS('draw:stroke-dash', nsOD) ]
# Find "G0S0"
logx_style,ipos_logx_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'G0S0'}, nth_match=0)
#print( 'FOUND: ipos_logx_style = ', ipos_logx_style )
new_elem_1 = ET.SubElement(auto_styles,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family', 'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name', 'GMi0')]))
new_elem_2 = ET.SubElement(new_elem_1,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill', 'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke', 'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash', 'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width', '0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color', '#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity', '100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin', 'round')]))
# Add minor grid to xaxis
new_elem_3 = ET.SubElement(xaxis,"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class', 'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name', 'GMi0')]))
if plotSheetObj.ycolL and len(plotSheetObj.ycolL) >=1:
auto_styles = chart_obj.find('office:automatic-styles')
autostyleL = auto_styles.findall('style:style', nsOD)
ref_series_style = None
istyle_loc = 0
for iloc,astyle in enumerate(autostyleL):
if astyle.get('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name') == 'G0S0':
ref_series_style = astyle
istyle_loc = iloc + 2
# graphic-properties
elem = ref_series_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.colorL[0]
if not c is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color", c)
elem.set("{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color", c)
w = plotSheetObj.lineThkL[0]
if not w is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width", w)
if not plotSheetObj.showLineL[0]:
#elem.attrib.clear()
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
# we're showing the line, should it have a style???
i_style = plotSheetObj.lineStyleL[0]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD) ,get_dash_a_name( i_style ))
elem.set(NS("draw:stroke", nsOD) ,'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
# .............. Failed Experiment ...................
#doc.add_tag(NS("draw:symbol-color", nsOD), plotSheetObj.chart_obj)
#elem.set(NS("draw:symbol-color", nsOD), "#999999")
#doc.add_tag(NS("draw:fill-color", nsOD), plotSheetObj.chart_obj)
#elem.set(NS("draw:fill-color", nsOD), "#999999")
#elem.set(NS("draw:fill", nsOD), "solid")
# chart-properties
elem = ref_series_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarkerL[0]: # showMarkerL is guaranteed to have same dimension as ycolL
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "automatic")
else:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "none")
for at in [NS("chart:symbol-name", nsOD), NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLineL[0]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name", plotSheetObj.markerTypeL[0])
hw = plotSheetObj.markerHtWdL[0]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
# Look for logarithmic scale on primary y
if plotSheetObj.logy:
#print( 'Got log y' )
# Find "Axs1"
logy_style,ipos_logy_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'Axs1'}, nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
chart_prop = logy_style.find( NS('style:chart-properties', nsOD) )
chart_prop.set( NS("chart:logarithmic", nsOD), "true" )
chart_prop.set( NS("chart:tick-marks-minor-inner", nsOD), "true" )
chart_prop.set( NS("chart:tick-marks-minor-outer", nsOD), "true" )
# Find "GMa1"
logy_style,ipos_logy_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'GMa1'}, nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
logy_style.set( NS("draw:stroke", nsOD), "dash" )
# Find "G0S1"
logy_style,ipos_logy_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'G0S1'}, nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
new_elem_1 = ET.SubElement(auto_styles,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family', 'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name', 'GMi1')]))
new_elem_2 = ET.SubElement(new_elem_1,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill', 'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke', 'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash', 'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width', '0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color', '#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity', '100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin', 'round')]))
# Add minor grid to yaxis
new_elem_3 = ET.SubElement(yaxis,"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class', 'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name', 'GMi1')]))
#print( ref_series_style.items())
nG0S = 1
for ycol in plotSheetObj.ycolL[1:]:
new_style = deepcopy( ref_series_style )
new_style.set('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name', 'G0S%i'%nG0S )
elem = new_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.colorL[nG0S]
if not c is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color", c )
elem.set("{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color", c)
w = plotSheetObj.lineThkL[nG0S]
if not w is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width", w)
if not plotSheetObj.showLineL[nG0S]:
#elem.attrib.clear()
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyleL[nG0S]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD) ,get_dash_a_name( i_style ))
elem.set(NS("draw:stroke", nsOD) ,'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = new_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarkerL[nG0S]: # showMarkerL is guaranteed to have same dimension as ycolL
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "automatic")
else:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "none")
for at in [NS("chart:symbol-name", nsOD), NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLineL[nG0S]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name", plotSheetObj.markerTypeL[nG0S])
hw = plotSheetObj.markerHtWdL[nG0S]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
auto_styles.insert(istyle_loc, new_style )
istyle_loc += 1
new_chart_series = deepcopy( y_series )
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name','G0S%i'%nG0S)
col_letter = get_col_letters_from_number( ycol )
sht_name = plotSheetObj.ycolDataSheetNameL[nG0S]
dataTableObj = doc.data_table_objD[ sht_name ]
val_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,col_letter,col_letter,dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1'%(sht_name, col_letter)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',lab_cell)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',val_cell_range)
xcol = plotSheetObj.xcolL[nG0S]
xcol_letter = get_col_letters_from_number( xcol )
xval_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,xcol_letter,xcol_letter,dataTableObj.nrows)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',xval_cell_range)
#ipos = len(plot_area)-1
#plot_area.insert(ipos, new_chart_series )
insert_below_series_named('G0S%i'%(nG0S-1,), new_chart_series, plot_area)
nG0S += 1
# =============== Secondary Y Axis =========================
# Look for secondary y axis
if (plotSheetObj.ycol2L is not None) and (len(plotSheetObj.ycol2L)>0):
series_label_cell_address = y2_series.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address')
#print( 'Y2 series_label_cell_address =',series_label_cell_address)
series_value_cell_range = y2_series.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address')
#print( 'Y2 series_value_cell_range =',series_value_cell_range)
ycol = plotSheetObj.ycol2L[0]
col_letter = get_col_letters_from_number( ycol )
sht_name = plotSheetObj.ycol2_DataSheetNameL[0]
dataTableObj = doc.data_table_objD[ sht_name ]
val_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,col_letter,col_letter,dataTableObj.nrows)
#print( 'Y2 val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1'%(sht_name, col_letter)
y2_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',lab_cell)
y2_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',val_cell_range)
chart_domain = y2_series.find('chart:domain', nsOD)
chart_data_point = y2_series.find('chart:data-point', nsOD)
#print( chart_domain.items())
#print( chart_data_point.items())
xcol = plotSheetObj.xcol2L[0]
xcol_letter = get_col_letters_from_number( xcol )
xval_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,xcol_letter,xcol_letter,dataTableObj.nrows)
chart_domain.set('{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',xval_cell_range)
chart_data_point.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}repeated','%i'%(dataTableObj.nrows-2,))
# Look for logarithmic scale on primary y
if plotSheetObj.log2y:
#print( 'Got log on secondary y' )
# Find "Axs2"
logy_style,ipos_logy_style = find_elem_w_attrib('style:style', auto_styles, nsOD,
attrib={'style:name':'Axs2'}, nth_match=0)
#print( 'FOUND: ipos_logy_style = ', ipos_logy_style )
chart_prop = logy_style.find( NS('style:chart-properties', nsOD) )
chart_prop.set( NS("chart:logarithmic", nsOD), "true" )
chart_prop.set( NS("chart:tick-marks-minor-inner", nsOD), "true" )
chart_prop.set( NS("chart:tick-marks-minor-outer", nsOD), "true" )
# Make "GMi2"
new_elem_1 = ET.SubElement(auto_styles,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}style",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}family', 'chart'),
('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name', 'GMi2')]))
# Looks better with only one set of y grids... Seems obvious now
if 0:#plotSheetObj.ycolL and (not plotSheetObj.logy):
new_elem_2 = ET.SubElement(new_elem_1,"{urn:oasis:names:tc:opendocument:xmlns:style:1.0}graphic-properties",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill', 'none'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke', 'dash'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-dash', 'a4'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width', '0.01042in'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color', '#000000'),
('{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-opacity', '100%'),
('{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}stroke-linejoin', 'round')]))
# Add minor grid to yaxis
new_elem_3 = ET.SubElement(y2axis,"{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}grid",
attrib=OrderedDict([('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}class', 'minor'),
('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name', 'GMi2')]))
# If more than one curve on secondary y...
if len(plotSheetObj.ycol2L) >= 1:
auto_styles = chart_obj.find('office:automatic-styles')
autostyleL = auto_styles.findall('style:style', nsOD)
ref_series_style = None
istyle_loc = 0
for iloc,astyle in enumerate(autostyleL):
if astyle.get('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name') == 'G1S0':
ref_series_style = astyle
istyle_loc = iloc + 2
elem = ref_series_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.color2L[0]
if not c is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color", c)
elem.set("{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color", c)
w = plotSheetObj.lineThk2L[0]
if not w is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width", w)
if not plotSheetObj.showLine2L[0]:
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyle2L[0]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD) ,get_dash_a_name( i_style ))
elem.set(NS("draw:stroke", nsOD) ,'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = ref_series_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarkerL[0]: # showMarkerL is guaranteed to have same dimension as ycol2L
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "automatic")
else:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "none")
for at in [NS("chart:symbol-name", nsOD), NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLine2L[0]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name", plotSheetObj.markerType2L[0])
hw = plotSheetObj.markerHtWd2L[0]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
plotSheetObj.ref_series_style2 = ref_series_style
#print( ref_series_style.items())
nG1S = 1
for ycol in plotSheetObj.ycol2L[1:]:
new_style = deepcopy( ref_series_style )
new_style.set('{urn:oasis:names:tc:opendocument:xmlns:style:1.0}name', 'G1S%i'%nG1S )
elem = new_style.find("style:graphic-properties", nsOD)
c = plotSheetObj.color2L[nG1S]
if not c is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-color", c )
elem.set("{urn:oasis:names:tc:opendocument:xmlns:drawing:1.0}fill-color", c)
w = plotSheetObj.lineThk2L[nG1S]
if not w is None:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0}stroke-width", w)
if not plotSheetObj.showLine2L[nG1S]:
elem.set(NS("draw:fill", nsOD), "none")
elem.set(NS("draw:stroke", nsOD), "none")
else:
i_style = plotSheetObj.lineStyle2L[nG1S]
#print('i_style =', i_style)
if i_style > 0:
elem.set(NS("draw:stroke-dash", nsOD) ,get_dash_a_name( i_style ))
elem.set(NS("draw:stroke", nsOD) ,'dash')
else:
elem.set(NS("draw:stroke", nsOD), "solid")
elem = new_style.find("style:chart-properties", nsOD)
if plotSheetObj.showMarker2L[nG1S]: # showMarkerL is guaranteed to have same dimension as ycol2L
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "automatic")
else:
elem.set("{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}symbol-type", "none")
for at in [NS("chart:symbol-name", nsOD), NS("chart:symbol-width", nsOD),
NS("chart:symbol-height", nsOD)]:
if elem.get(at, None) is not None:
del elem.attrib[at]
# elem is chart-properties
if not plotSheetObj.showLine2L[nG1S]:
set_new_tag(elem, "chart:symbol-type", "named-symbol")
set_new_tag(elem, "chart:symbol-name", plotSheetObj.markerType2L[nG1S])
hw = plotSheetObj.markerHtWd2L[nG1S]
set_new_tag(elem, "chart:symbol-width", hw)
set_new_tag(elem, "chart:symbol-height", hw)
auto_styles.insert(istyle_loc, new_style )
istyle_loc += 1
new_chart_series = deepcopy( y2_series )
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name','G1S%i'%nG1S)
col_letter = get_col_letters_from_number( ycol )
sht_name = plotSheetObj.ycol2_DataSheetNameL[nG1S]
dataTableObj = doc.data_table_objD[ sht_name ]
val_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,col_letter,col_letter,dataTableObj.nrows)
#print( 'val_cell_range =',val_cell_range)
lab_cell = '%s.$%s$1'%(sht_name, col_letter)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}label-cell-address',lab_cell)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}values-cell-range-address',val_cell_range)
xcol = plotSheetObj.xcol2L[nG1S]
xcol_letter = get_col_letters_from_number( xcol )
xval_cell_range = '%s.$%s$3:.$%s$%i'%(sht_name,xcol_letter,xcol_letter,dataTableObj.nrows)
new_chart_series.set('{urn:oasis:names:tc:opendocument:xmlns:table:1.0}cell-range-address',xval_cell_range)
ipos = len(plot_area)-1
plot_area.insert(ipos, new_chart_series )
nG1S += 1
#plot_area._children.sort( key=lambda child: child.get('{urn:oasis:names:tc:opendocument:xmlns:chart:1.0}style-name', '0') )
plotSheetObj.istyle_loc = istyle_loc
plotSheetObj.y_series = y_series
plotSheetObj.chart_obj = chart_obj
