summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx
AgeCommit message (Collapse)Author
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-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-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
2020-11-27Add casting to dateArtem Kozaev
Add tests
2020-11-27Allow to set cell type to `date`Artem Kozaev
2020-08-29Update #serialize to accept 3 argumentsRyan Winograd
2020-08-28Update doc to reflect preferred new public interfaceRyan Winograd
2020-08-24Explosion explosion fixed - issue 58Noel Peden
2020-08-20Deprecate using `#serialize` with boolean argumentRyan Winograd
Update `Axlsx::Package#serialize` to accept the second argument as a boolean (being deprecated) or an options hash. In order to transition toward using keyword arguments for `Axlsx::Package#serialize`, change the documented method signature to an options hash, while still parsing the second argument as `confirm_valid` if a boolean is provided (in which case we also warn the user that a boolean argument is deprecated).
2020-08-19Add option to `#serialize` with system zip commandRyan Winograd
Add a `:zip_command` option to `Axlsx::Package#serialize` that allows the user to specify an alternate command to use to perform the zip operation on the XLSX file contents. The default zip operation is provided by RubyZip. On large documents users may experience faster zip times using a zip binary. Resolves #55
2020-07-27Fix type detection for floats with out-of-rage exponents (#54)Stefan Daschek
Prior to this change, strings like "1e12345" would be interpreted as float values, regardless of the actual value of the exponent (which easily could be out of range for Ruby). In case the exponent was greater than `Float::MAX_10_EXP` (usually 308), this would result in a cell of type `:float` containing the literal string `"Infinity"`. Excel can not parse such cells and therefore gives a “corrupt data” error. In case the exponent was less than `Float::MIN_10_EXP` (usually -307) the cell would contain `0.0`. This does not result in Excel throwing an error, but probably isn't the expected result either. Note that this problem is quite likely to happen when creating a worksheet with hexadecimal strings, because e.g. "1234e567" is a perfectly valid hex value. The additional range check of the exponent introduces a slight performance overhead, so I decided to split the code path: I presume parsing floats with exponents < 100 (or no exponents at all) is way more common, so this code path behaves exactly like before. Only in the case of a 3 digit exponent the additional range check is introduced.
2020-07-16Version bump to 3.0.2 [skip ci]Noel Peden
2020-07-16Binary image read for issue #51Noel Peden
2020-07-14Set column width to the maximum allowed value (#53)Sergey Ponomarev
Maximum column width limit in MS Excel is 255 characters https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 If this value is exceeded, MS Excel gets stuck and doesn't allow column resizing.