summaryrefslogtreecommitdiffhomepage
path: root/examples
AgeCommit message (Collapse)Author
2023-10-19Merge pull request #307 from kiskoza/escape-formulas-by-defaultZsolt Kozaroczy
Escape formulas by default
2023-10-09Link chart series colors example properlyOriol Blanc
2023-10-02Update examples to unescape formulasKoza
2023-08-15Added sorting to the AutoFilter class - add sort conditions to the xml (#286)rikweelvoormedia
--------- Co-authored-by: SarahVanHaute <[email protected]> Co-authored-by: Geremia Taglialatela <[email protected]>
2023-04-13Fix typos regarding "escape formulas" in readme and exampleStefan
2023-04-12Merge pull request #186 from tablecheck/escape-formulas-improvementZsolt Kozaroczy
escape_formulas - add settings for global, workbook, worksheet, row and cell levels
2023-04-12Add extrenal image to the examplesKoza
2023-03-31Add settings for escape_formulas at global, workbook, worksheet, row and ↵johnnyshields
cell levels.
2022-11-02Improve BorderCreator argsWeston Ganger
2022-10-12Add example images, Fix axlsx_styler checkWeston 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-17Clarify Hyperlinks Example for Internal LinksWeston Ganger
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-07-09Improve font exampleStefan Daschek
2022-07-09Improve list validation exampleStefan Daschek
2022-06-05Add example for defining print area (#134)Stefan
2022-06-01Add missing screenshot for panes_exampleStefan
Fixes #135
2022-04-14Add row outline options exampleToms Mikoss
2022-04-10Fix borders exampleKoza
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
2021-11-22Correcting typoVladimir Támara Patiño
2021-07-24Add overlap to bar charts (#107)Zsolt Kozaroczy
2021-04-26Add option to define a series color for the BarSeries (#81)Zsolt Kozaroczy
2021-03-19Implement :offset option for worksheet#add_row (#87)Agustin Gomez
2021-03-19Number format in pivot tables: update changelog and pivot table exampleStefan
2021-03-19Add conditional formatting example for text equalityKoza
2020-09-11Restructure examples folder (#47)Zsolt Kozaroczy
Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files.
2020-02-07Remove global variables from example #32 (#41)Zsolt Kozaroczy
2019-12-20Add option to protect against formula injection attacks (#34)Gabriel Morcote
Caxlsx used to treat cell values beginning with an equal sign as formula by default. This can be dangerous if the input data is user generated or coming from other untrusted sources (see https://www.owasp.org/index.php/CSV_Injection for details). This commit adds a new option `escape_formulas` that can be used with `#add_row` and on instances of `Cell`. If set to true, cell values beginning with an equal sign are treated as normal strings (and will be displayed literally by Excel and co.)
2018-02-22chore(examples): include examples for customized locking and single print ↵randym
area specification with defined names
2018-02-15chore(examples): do more crazy in the data_validation examplerandym
2018-02-15chore(examples): update data validation example to show raw list validationrandym
2015-07-04Merge branch 'example' of https://github.com/shifakhan/axlsx into ↵Jonathan Tron
shifakhan-example
2015-07-04Add test, fix example with tab color generation and fix a but due to a typoJonathan Tron
2015-07-04Merge branch 'worksheet_tab_colour' of https://github.com/shifakhan/axlsx ↵Jonathan Tron
into shifakhan-worksheet_tab_colour
2015-07-03Remove lowercase extension testmarc
It is no longer needed because now detection is though mime type
2015-07-03Validates whether an image is acceptable through mime typemarc
image/jpeg, image/png & image/gif are considered the allowed mime types for an image. mimemagic gem is added as dependency in order to do the checking. Added tests to check against three supported mime types. A fake jpg fixture (created with 'touch' command) has been added to test that extension is no longer used.
2015-05-23Option to change tab colorshifakhan
2015-05-04Added example of conditional formatting to match text in cellsshifakhan
2015-03-14Merge pull request #367 from axelson/patch-1Jurriaan Pruis
Add usage information to row_column_style example
2014-12-23Add usage information to row_column_style exampleJason Axelson
2014-10-15Added an example of row heightRishi
An example for changing the row height was missing. I thought it would make sense to have this in example as well. I needed the option and I have to look at the code to how to do it. I think it would help others.
2014-08-01Add example and test for auto filters on multiple worksheet (refs #338)Jonathan Tron
2014-03-06Fix conditional_formatting example filegeruhl
- change profitable hex color code to a legal 6 digit # (428751 = green) - "wb" and "sheet" are not created in this example, change to "book" and "ws"
2014-03-01Implemented RichText (multiple text runs)Jurriaan Pruis
and added multiline autowidth for both RichText and normal strings
2013-09-30Fix image anchor swapping and update readme.Randy Morgan
2013-09-30add name attribute to cell to create defined names for a single cell. ↵Randy Morgan
https://github.com/randym/axlsx/issues/241