summaryrefslogtreecommitdiffhomepage
path: root/lib
AgeCommit message (Collapse)Author
2022-07-21Prevent Excel from crashing when multiple data columns are added to PivotTableKnut Stenmark
Excel will crash unless both `colFields` and `colItems` are declared in the PivotTable xml. First `field` of `colFields` needs to be set to -2 to tell Excel that the value columns comes from individual columns and not groups. I do not know why `colItems` are needed, but when set, the Excel document opens without crashing.
2022-07-12Add `hideDropDown` alias for `showDropDown` setting, as the latter is ↵Koza
confusing to use (because its logic seems inverted).
2022-07-09Add pivot table option to sort headers (#143)James Lam
2022-06-05Implement “rounded corners” setting for chartsStefan
Until now this setting was not present in the generated XML. According to the ECMA spec the setting defaults to true, so charts always had rounded corners. Now rounded corners can be disabled explicitly.
2022-06-01Implement “plot visible only” setting for chartsStefan
Until now this setting was hardcoded to `true`. The setting affects whether data from hidden cells (cells width zero height or width) is used when plotting the chart.
2022-05-23Fix default values in docsStefan
2022-05-18Completely hide chart titles if blankStefan
Before this change, a chart with a blank title would show up in Excel with a default title like “Chart title” or “Diagrammtitel”. It was not possible to completely hide a chart title: Setting it to an empty space would override Excel’s default, but the empty title did still occupy vertical space. Per OOXML standard the `title` element is optional, so omitting it if the title is blank looks like the right thing to do and seems to work correctly in Excel.
2022-05-18Implement `Title#empty?`Stefan
This is primarily a refactoring, but exposing it as a public method seems useful.
2022-05-18Fix missing cell reference for chart title when cell emptyStefan
Before this change, creating a chart title referencing an empty cell would lose the cell reference. If the cell was later set to a non-blank value (either during generating the file, or while editing it in a spreadsheet app), the chart title would stay blank.
2022-04-07Sort archive entries for correct MIME detection with file commandytjmt
2022-03-02instance_values -> instance_values_forpjskennedy
2022-03-02Update references to use new class methodpjskennedy
2022-03-02Remove monkey patch on Objectpjskennedy
2022-02-23Version bump to 3.2.0 [skip ci]Noel Peden
2022-02-07Validate name option to be non-empty string when passed.Josef Šimánek
2022-02-07Merge branch 'master' into feature/manageable-scatter-markersOleg Yakovenko
2022-02-06Allow border style to accept an Array (#117)Weston Ganger
Co-authored-by: Noel Peden <[email protected]>
2022-02-06Autowidth cell calculation is now configurableTobias Egli
On the workbook you can now configure the font_scale_divisor and the bold_font_multiplier to get better results for the automatic cell width calculationb
2022-02-05Merge branch 'master' into improve_range_errorNoel Peden
2022-01-28Fix invalid xml when pivot table created with more than one column in data fieldWeston Ganger
2022-01-24Refractor to use constant based error messagesWeston Ganger
2021-12-29Fix Worksheet#name_to_cell bug which returned reversed row/col indexesWeston Ganger
2021-12-28Return output stream in binmodeDan DeBruler
2021-09-22Version bump to 3.1.1 [skip ci]Noel Peden
2021-07-25Fix gap width validator for bar charts (#108)Zsolt Kozaroczy
`gap_width` and `gap_depth` now allow only integers in the range of 0–500. The previous behaviour (requiring a percentage value) was according to the current version of the OOXML spec, but Excel seems to rely on an older version, where the gap amount was required to be a simple integer. Also, `gapDepth` is only allowed in 3D bar charts, so it is now no longer available for 2D bar charts.
2021-07-24Add overlap to bar charts (#107)Zsolt Kozaroczy
2021-05-31Fix typo in row.rbPascal Andermatt
2021-04-26Add option to define a series color for the BarSeries (#81)Zsolt Kozaroczy
2021-04-26Optimize Axlsx.cell_range (#94)Oleg Yakovenko
Optimize Axlsx.cell_range by using minmax_by instead of sorting the cells (the sorted cells are not used for anything else in this method).
2021-03-28Version bump to 3.1.0Noel Peden
2021-03-27Replace mimemagic with marcel (#95)Jorne Kandziora
Mimemagic requires users to download or install additional files. Rails used Marcel as an abstration layer on this library. Marcel was updated to another file matching database. Following Rails in this matter will remove the need for users to do additional work, just to use caxlsx.
2021-03-19Implement :offset option for worksheet#add_row (#87)Agustin Gomez
2021-03-19Add support for format in pivot tables (#79)Knut I. Stenmark
2021-03-05feature: useless assignment removedOleg Yakovenko
2021-03-05feature: helper method naming adjustmentOleg Yakovenko
2021-03-05feature: spec fixOleg Yakovenko
2021-03-05feature: handle default marker symbolOleg Yakovenko
2021-03-02feature: respect marker preferences without color specificationOleg Yakovenko
2021-03-01feature: marker symbol management for scatter seriesOleg Yakovenko
2021-03-01feature: scatter series should respect marker preference of parent chartOleg Yakovenko
2021-02-17Merge pull request #57 from rylwin/change-serialize-signatureNoel Peden
Deprecate using `#serialize` with boolean argument
2021-02-12Merge pull request #77 from rfdonnelly/fix-special-char-in-table-headerNoel Peden
Fix special characters in table header
2021-02-03Fix special characters in pivot table cache definitionRob Donnelly
2021-02-03Fix special characters in table headerRob Donnelly
2021-01-05Bump version 3.0.4Noel Peden
2021-01-05Merge pull request #71 from artplan1/add-date-typeNoel Peden
Allow to set cell type to `date`
2021-01-05Merge pull request #70 from chi-deutschland/fix-worksheet-title-length-ruleNoel Peden
Fix worksheet title length enforcement
2020-12-10Fix calculation of worksheet name lengthLuka Lüdicke
- The previous change caused unnecessary issues - We approximate that Excel calculates the character length with UTF-16 - Fixes https://github.com/caxlsx/caxlsx/issues/67
2020-12-07Version bump to 3.0.3Noel Peden
2020-12-03Extend cell_type_from_value with sanity checksToms Mikoss