summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx
AgeCommit message (Collapse)Author
2023-04-08Fix space-related offensesGeremia Taglialatela
- Layout/SpaceAfterComma - Layout/SpaceAroundEqualsInParameterDefault - Layout/SpaceAroundOperators - Layout/SpaceBeforeBlockBraces - Layout/SpaceInsideBlockBraces - Layout/SpaceInsideHashLiteralBraces - Layout/SpaceInsideParens
2023-04-08Fix offenses related to trailing commasGeremia Taglialatela
2023-04-08Fix EmptyLines related offensesGeremia Taglialatela
2023-04-08Fix Layout/SpaceBeforeFirstArg offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceBeforeFirstArg -a ```
2023-04-08Fix Layout/MultilineOperationIndentation offensesGeremia Taglialatela
``` rubocop --only Layout/MultilineOperationIndentation -a ```
2023-04-08Fix an indentation issue manuallyGeremia Taglialatela
Also regenerate config
2023-04-07Fix Layout/SpaceInsideArrayLiteralBrackets offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceInsideArrayLiteralBrackets -a ```
2023-04-07Fix Layout/SpaceAroundKeyword offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceAroundKeyword -a ```
2023-04-07Fix Layout/SpaceAroundBlockParameters offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceAroundBlockParameters -a ```
2023-04-07Fix Layout/FirstArrayElementIndentation offenseGeremia Taglialatela
``` rubocop --only Layout/FirstArrayElementIndentation -a ```
2023-04-07Fix Layout/EmptyLinesAroundBlockBody offensesGeremia Taglialatela
``` rubocop --only Layout/EmptyLinesAroundBlockBody -a ```
2023-04-07Fix Layout/ElseAlignmentGeremia Taglialatela
Manually fixed
2023-04-07Fix Layout/BlockAlignment offensesGeremia Taglialatela
Manually fixed
2023-04-06Fix Layout/EmptyLinesAroundAttributeAccessorGeremia Taglialatela
``` rubocop --only Layout/EmptyLinesAroundAttributeAccessor -a ```
2023-04-06Fix Layout offenses related to access modifiersGeremia Taglialatela
``` rubocop --only Layout/EmptyLinesAroundAccessModifier,Layout/AccessModifierIndentation -a ```
2023-04-06Fix Layout/CommentIndentation offensesGeremia Taglialatela
``` rubocop --only Layout/CommentIndentation -a ```
2023-04-06Fix Layout/EmptyLineBetweenDefs offensesGeremia Taglialatela
``` rubocop --only Layout/EmptyLineBetweenDefs -a ```
2023-04-06Fix Layout/EmptyLines offensesGeremia Taglialatela
``` rubocop --only Layout/EmptyLines -a ```
2023-04-06Fix Style/Encoding offensesGeremia Taglialatela
``` rubocop --only Style/Encoding -a ```
2023-04-06Fix Layout/LeadingEmptyLines offensesGeremia Taglialatela
``` rubocop --only Layout/LeadingEmptyLines -a ```
2023-04-06Fix Layout/TrailingEmptyLines offensesGeremia Taglialatela
``` rubocop --only Layout/TrailingEmptyLines -a ```
2023-04-06Remove Layout/TrailingWhitespace offensesGeremia Taglialatela
``` rubocop --only Layout/TrailingWhitespace -a ```
2023-04-06Fix Layout/EndOfLine offensesGeremia Taglialatela
``` rubocop --only Layout/EndOfLine ``` Manually fixed
2023-04-03Escape array formulasjohnnyshields
2023-04-02`escape_formulas` should handle all [OWASP-designated formula ↵johnnyshields
prefixes](https://owasp.org/www-community/attacks/CSV_Injection).
2023-03-31Add settings for escape_formulas at global, workbook, worksheet, row and ↵johnnyshields
cell levels.
2022-11-02Improve BorderCreator argsWeston Ganger
2022-10-22Fix bug in BorderCreator when second arg is nilWeston Ganger
2022-10-21Version bump to 3.3.0 [skip ci]Koza
2022-10-21Merge pull request #156 from basefarm/pivot_multiple_data_columnsNoel Peden
Prevent Excel from crashing when multiple data columns added to PivotTable
2022-10-12Resolve all TODOsWeston Ganger
2022-10-09ImprovementsWeston Ganger
2022-10-09Cleanup Stylesheet#add_stylesWeston Ganger
2022-10-09Remove active_support dependency from axlsx_stylerWeston Ganger
2022-09-29Merge axlsx_styler gem into caxlsxWeston Ganger
2022-09-26Make sure all examples and docs use binary mode for reading / writing XLSX filesStefan
Not using binary mode can cause encoding issues, see #138.
2022-09-23Improve documentation for `Worksheet#styles`Stefan Daschek
Closes #166
2022-09-21Update lib/axlsx/util/constants.rbStefan Daschek
Co-authored-by: Geremia Taglialatela <[email protected]>
2022-09-21Update lib/axlsx/workbook/worksheet/worksheet.rbStefan Daschek
Co-authored-by: Geremia Taglialatela <[email protected]>
2022-09-21Move worksheet name forbidden chars to a constantGeremia Taglialatela
2022-09-21Add worksheet name max length to a constantGeremia Taglialatela
Close #163
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.