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)


1062
1063
1064
# File 'lib/fast_excel/binding/chart.rb', line 1062

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)


1098
1099
1100
# File 'lib/fast_excel/binding/chart.rb', line 1098

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

#set_invert_if_negative ⇒ nil

Returns:

  • (nil)


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

def set_invert_if_negative()
  Libxlsxwriter.chart_series_set_invert_if_negative(self)
end

#set_labels ⇒ nil

Returns:

  • (nil)


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

def set_labels()
  Libxlsxwriter.chart_series_set_labels(self)
end

#set_labels_font(font) ⇒ nil

Parameters:

Returns:

  • (nil)


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

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

#set_labels_leader_line ⇒ nil

Returns:

  • (nil)


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

def set_labels_leader_line()
  Libxlsxwriter.chart_series_set_labels_leader_line(self)
end

#set_labels_legend ⇒ nil

Returns:

  • (nil)


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

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)


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

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)


1164
1165
1166
# File 'lib/fast_excel/binding/chart.rb', line 1164

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_percentage ⇒ nil

Returns:

  • (nil)


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

def set_labels_percentage()
  Libxlsxwriter.chart_series_set_labels_percentage(self)
end

#set_labels_position(position) ⇒ nil

Parameters:

  • position (Integer)

Returns:

  • (nil)


1176
1177
1178
# File 'lib/fast_excel/binding/chart.rb', line 1176

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

#set_labels_separator(separator) ⇒ nil

Parameters:

  • separator (Integer)

Returns:

  • (nil)


1170
1171
1172
# File 'lib/fast_excel/binding/chart.rb', line 1170

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

#set_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1092
1093
1094
# File 'lib/fast_excel/binding/chart.rb', line 1092

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

#set_marker_fill(fill) ⇒ nil

Parameters:

Returns:

  • (nil)


1133
1134
1135
# File 'lib/fast_excel/binding/chart.rb', line 1133

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

#set_marker_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1127
1128
1129
# File 'lib/fast_excel/binding/chart.rb', line 1127

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

#set_marker_pattern(pattern) ⇒ nil

Parameters:

Returns:

  • (nil)


1139
1140
1141
# File 'lib/fast_excel/binding/chart.rb', line 1139

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

#set_marker_size(size) ⇒ nil

Parameters:

  • size (Integer)

Returns:

  • (nil)


1121
1122
1123
# File 'lib/fast_excel/binding/chart.rb', line 1121

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

#set_marker_type(type) ⇒ nil

Parameters:

  • type (Integer)

Returns:

  • (nil)


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

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

#set_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


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

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)


1086
1087
1088
# File 'lib/fast_excel/binding/chart.rb', line 1086

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)


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

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

#set_points(points) ⇒ Symbol from _enum_error_

Parameters:

Returns:



1145
1146
1147
# File 'lib/fast_excel/binding/chart.rb', line 1145

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

#set_smooth(smooth) ⇒ nil

Parameters:

  • smooth (Integer)

Returns:

  • (nil)


1151
1152
1153
# File 'lib/fast_excel/binding/chart.rb', line 1151

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

#set_trendline(type, value) ⇒ nil

Parameters:

  • type (Integer)
  • value (Integer)

Returns:

  • (nil)


1210
1211
1212
# File 'lib/fast_excel/binding/chart.rb', line 1210

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

#set_trendline_equation ⇒ nil

Returns:

  • (nil)


1222
1223
1224
# File 'lib/fast_excel/binding/chart.rb', line 1222

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)


1217
1218
1219
# File 'lib/fast_excel/binding/chart.rb', line 1217

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)


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

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

#set_trendline_line(line) ⇒ nil

Parameters:

Returns:

  • (nil)


1245
1246
1247
# File 'lib/fast_excel/binding/chart.rb', line 1245

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

#set_trendline_name(name) ⇒ nil

Parameters:

  • name (String)

Returns:

  • (nil)


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

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

#set_trendline_r_squared ⇒ nil

Returns:

  • (nil)


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

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)


1072
1073
1074
# File 'lib/fast_excel/binding/chart.rb', line 1072

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