Module: Libxlsxwriter::ChartSeriesWrappers

Included in:
ChartSeries
Defined in:
lib/fast_excel/binding/chart.rb

Overview

Fields:

:categories ::

(SeriesRange) 

:values ::

(SeriesRange) 

:title ::

(ChartTitle) 

:line ::

(ChartLine) 

:fill ::

(ChartFill) 

:pattern ::

(ChartPattern) 

:marker ::

(ChartMarker) 

:points ::

(ChartPoint) 

:point_count ::

(Integer) 

:smooth ::

(Integer) 

:invert_if_negative ::

(Integer) 

:has_labels ::

(Integer) Data label parameters.

:show_labels_value ::

(Integer) 

:show_labels_category ::

(Integer) 

:show_labels_name ::

(Integer) 

:show_labels_leader ::

(Integer) 

:show_labels_legend ::

(Integer) 

:show_labels_percent ::

(Integer) 

:label_position ::

(Integer) 

:label_separator ::

(Integer) 

:default_label_position ::

(Integer) 

:label_num_format ::

(String) 

:label_font ::

(ChartFont) 

:x_error_bars ::

(SeriesErrorBars) 

:y_error_bars ::

(SeriesErrorBars) 

:has_trendline ::

(Integer) 

:has_trendline_forecast ::

(Integer) 

:has_trendline_equation ::

(Integer) 

:has_trendline_r_squared ::

(Integer) 

:has_trendline_intercept ::

(Integer) 

:trendline_type ::

(Integer) 

:trendline_value ::

(Integer) 

:trendline_forward ::

(Float) 

:trendline_backward ::

(Float) 

:trendline_value_type ::

(Integer) 

:trendline_name ::

(String) 

:trendline_line ::

(ChartLine) 

:trendline_intercept ::

(Float) 

:list_pointers ::

(ChartSeriesListPointers)

Instance Method Summary collapse

Instance Method Details

#set_categories(sheetname, first_row, first_col, last_row, last_col) ⇒ nil

Parameters:

  • sheetname (String)
  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:

  • (nil)


1078
1079
1080
# File 'lib/fast_excel/binding/chart.rb', line 1078

def set_categories(sheetname, first_row, first_col, last_row, last_col)
  Libxlsxwriter.chart_series_set_categories(self, sheetname, first_row, first_col, last_row, last_col)
end

#set_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


1114
1115
1116
# File 'lib/fast_excel/binding/chart.rb', line 1114

def set_fill(fill)
  Libxlsxwriter.chart_series_set_fill(self, fill)
end

#set_invert_if_negativenil

Returns:

  • (nil)


1119
1120
1121
# File 'lib/fast_excel/binding/chart.rb', line 1119

def set_invert_if_negative()
  Libxlsxwriter.chart_series_set_invert_if_negative(self)
end

#set_labelsnil

Returns:

  • (nil)


1172
1173
1174
# File 'lib/fast_excel/binding/chart.rb', line 1172

def set_labels()
  Libxlsxwriter.chart_series_set_labels(self)
end

#set_labels_font(font) ⇒ nil

Parameters:

Returns:

  • (nil)


1219
1220
1221
# File 'lib/fast_excel/binding/chart.rb', line 1219

def set_labels_font(font)
  Libxlsxwriter.chart_series_set_labels_font(self, font)
end

#set_labels_leader_linenil

Returns:

  • (nil)


1197
1198
1199
# File 'lib/fast_excel/binding/chart.rb', line 1197

def set_labels_leader_line()
  Libxlsxwriter.chart_series_set_labels_leader_line(self)
end

#set_labels_legendnil

Returns:

  • (nil)


1202
1203
1204
# File 'lib/fast_excel/binding/chart.rb', line 1202

def set_labels_legend()
  Libxlsxwriter.chart_series_set_labels_legend(self)
end

#set_labels_num_format(num_format) ⇒ nil

Parameters:

  • num_format (String)

Returns:

  • (nil)


1213
1214
1215
# File 'lib/fast_excel/binding/chart.rb', line 1213

def set_labels_num_format(num_format)
  Libxlsxwriter.chart_series_set_labels_num_format(self, num_format)
end

#set_labels_options(show_name, show_category, show_value) ⇒ nil

Parameters:

  • show_name (Integer)
  • show_category (Integer)
  • show_value (Integer)

Returns:

  • (nil)


1180
1181
1182
# File 'lib/fast_excel/binding/chart.rb', line 1180

def set_labels_options(show_name, show_category, show_value)
  Libxlsxwriter.chart_series_set_labels_options(self, show_name, show_category, show_value)
end

#set_labels_percentagenil

Returns:

  • (nil)


1207
1208
1209
# File 'lib/fast_excel/binding/chart.rb', line 1207

def set_labels_percentage()
  Libxlsxwriter.chart_series_set_labels_percentage(self)
end

#set_labels_position(position) ⇒ nil

Parameters:

  • position (Integer)

Returns:

  • (nil)


1192
1193
1194
# File 'lib/fast_excel/binding/chart.rb', line 1192

def set_labels_position(position)
  Libxlsxwriter.chart_series_set_labels_position(self, position)
end

#set_labels_separator(separator) ⇒ nil

Parameters:

  • separator (Integer)

Returns:

  • (nil)


1186
1187
1188
# File 'lib/fast_excel/binding/chart.rb', line 1186

def set_labels_separator(separator)
  Libxlsxwriter.chart_series_set_labels_separator(self, separator)
end

#set_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1108
1109
1110
# File 'lib/fast_excel/binding/chart.rb', line 1108

def set_line(line)
  Libxlsxwriter.chart_series_set_line(self, line)
end

#set_marker_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


1149
1150
1151
# File 'lib/fast_excel/binding/chart.rb', line 1149

def set_marker_fill(fill)
  Libxlsxwriter.chart_series_set_marker_fill(self, fill)
end

#set_marker_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1143
1144
1145
# File 'lib/fast_excel/binding/chart.rb', line 1143

def set_marker_line(line)
  Libxlsxwriter.chart_series_set_marker_line(self, line)
end

#set_marker_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


1155
1156
1157
# File 'lib/fast_excel/binding/chart.rb', line 1155

def set_marker_pattern(pattern)
  Libxlsxwriter.chart_series_set_marker_pattern(self, pattern)
end

#set_marker_size(size) ⇒ nil

Parameters:

  • size (Integer)

Returns:

  • (nil)


1137
1138
1139
# File 'lib/fast_excel/binding/chart.rb', line 1137

def set_marker_size(size)
  Libxlsxwriter.chart_series_set_marker_size(self, size)
end

#set_marker_type(type) ⇒ nil

Parameters:

  • type (Integer)

Returns:

  • (nil)


1131
1132
1133
# File 'lib/fast_excel/binding/chart.rb', line 1131

def set_marker_type(type)
  Libxlsxwriter.chart_series_set_marker_type(self, type)
end

#set_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


1094
1095
1096
# File 'lib/fast_excel/binding/chart.rb', line 1094

def set_name(name)
  Libxlsxwriter.chart_series_set_name(self, name)
end

#set_name_range(sheetname, row, col) ⇒ nil

Parameters:

  • sheetname (String)
  • row (Integer)
  • col (Integer)

Returns:

  • (nil)


1102
1103
1104
# File 'lib/fast_excel/binding/chart.rb', line 1102

def set_name_range(sheetname, row, col)
  Libxlsxwriter.chart_series_set_name_range(self, sheetname, row, col)
end

#set_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


1125
1126
1127
# File 'lib/fast_excel/binding/chart.rb', line 1125

def set_pattern(pattern)
  Libxlsxwriter.chart_series_set_pattern(self, pattern)
end

#set_points(points) ⇒ Symbol from _enum_error_

Parameters:

Returns:



1161
1162
1163
# File 'lib/fast_excel/binding/chart.rb', line 1161

def set_points(points)
  Libxlsxwriter.chart_series_set_points(self, points)
end

#set_smooth(smooth) ⇒ nil

Parameters:

  • smooth (Integer)

Returns:

  • (nil)


1167
1168
1169
# File 'lib/fast_excel/binding/chart.rb', line 1167

def set_smooth(smooth)
  Libxlsxwriter.chart_series_set_smooth(self, smooth)
end

#set_trendline(type, value) ⇒ nil

Parameters:

  • type (Integer)
  • value (Integer)

Returns:

  • (nil)


1226
1227
1228
# File 'lib/fast_excel/binding/chart.rb', line 1226

def set_trendline(type, value)
  Libxlsxwriter.chart_series_set_trendline(self, type, value)
end

#set_trendline_equationnil

Returns:

  • (nil)


1238
1239
1240
# File 'lib/fast_excel/binding/chart.rb', line 1238

def set_trendline_equation()
  Libxlsxwriter.chart_series_set_trendline_equation(self)
end

#set_trendline_forecast(forward, backward) ⇒ nil

Parameters:

  • forward (Float)
  • backward (Float)

Returns:

  • (nil)


1233
1234
1235
# File 'lib/fast_excel/binding/chart.rb', line 1233

def set_trendline_forecast(forward, backward)
  Libxlsxwriter.chart_series_set_trendline_forecast(self, forward, backward)
end

#set_trendline_intercept(intercept) ⇒ nil

Parameters:

  • intercept (Float)

Returns:

  • (nil)


1249
1250
1251
# File 'lib/fast_excel/binding/chart.rb', line 1249

def set_trendline_intercept(intercept)
  Libxlsxwriter.chart_series_set_trendline_intercept(self, intercept)
end

#set_trendline_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1261
1262
1263
# File 'lib/fast_excel/binding/chart.rb', line 1261

def set_trendline_line(line)
  Libxlsxwriter.chart_series_set_trendline_line(self, line)
end

#set_trendline_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


1255
1256
1257
# File 'lib/fast_excel/binding/chart.rb', line 1255

def set_trendline_name(name)
  Libxlsxwriter.chart_series_set_trendline_name(self, name)
end

#set_trendline_r_squarednil

Returns:

  • (nil)


1243
1244
1245
# File 'lib/fast_excel/binding/chart.rb', line 1243

def set_trendline_r_squared()
  Libxlsxwriter.chart_series_set_trendline_r_squared(self)
end

#set_values(sheetname, first_row, first_col, last_row, last_col) ⇒ nil

Parameters:

  • sheetname (String)
  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:

  • (nil)


1088
1089
1090
# File 'lib/fast_excel/binding/chart.rb', line 1088

def set_values(sheetname, first_row, first_col, last_row, last_col)
  Libxlsxwriter.chart_series_set_values(self, sheetname, first_row, first_col, last_row, last_col)
end