| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2019-12-20 | Add 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-22 | chore(examples): include examples for customized locking and single print ↵ | randym | |
| area specification with defined names | |||
| 2018-02-15 | chore(examples): do more crazy in the data_validation example | randym | |
| 2018-02-15 | chore(examples): update data validation example to show raw list validation | randym | |
| 2015-07-04 | Merge branch 'example' of https://github.com/shifakhan/axlsx into ↵ | Jonathan Tron | |
| shifakhan-example | |||
| 2015-07-04 | Add test, fix example with tab color generation and fix a but due to a typo | Jonathan Tron | |
| 2015-07-04 | Merge branch 'worksheet_tab_colour' of https://github.com/shifakhan/axlsx ↵ | Jonathan Tron | |
| into shifakhan-worksheet_tab_colour | |||
| 2015-07-03 | Remove lowercase extension test | marc | |
| It is no longer needed because now detection is though mime type | |||
| 2015-07-03 | Validates whether an image is acceptable through mime type | marc | |
| 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-23 | Option to change tab color | shifakhan | |
| 2015-05-04 | Added example of conditional formatting to match text in cells | shifakhan | |
| 2015-03-14 | Merge pull request #367 from axelson/patch-1 | Jurriaan Pruis | |
| Add usage information to row_column_style example | |||
| 2014-12-23 | Add usage information to row_column_style example | Jason Axelson | |
| 2014-10-15 | Added an example of row height | Rishi | |
| 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-01 | Add example and test for auto filters on multiple worksheet (refs #338) | Jonathan Tron | |
| 2014-03-06 | Fix conditional_formatting example file | geruhl | |
| - 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-01 | Implemented RichText (multiple text runs) | Jurriaan Pruis | |
| and added multiline autowidth for both RichText and normal strings | |||
| 2013-09-30 | Fix image anchor swapping and update readme. | Randy Morgan | |
| 2013-09-30 | add name attribute to cell to create defined names for a single cell. ↵ | Randy Morgan | |
| https://github.com/randym/axlsx/issues/241 | |||
| 2013-09-29 | Adds examples for hiding sheets and workbook view | Randy Morgan | |
| These examples show using hidden and very hidden to manage worksheet visibility as well as using the active_tab attribute of a workbook#view in order to specify which tab should be showing when the sheet is opened. | |||
| 2013-09-27 | Fix example.rb | patorash | |
| 2013-09-27 | smooth line for line chart | patorash | |
| 2013-09-26 | extended examples and smooth lines for line chart | Randy Morgan | |
| 2013-09-13 | Fixes for anchor swapping when adding images. - Two -> One swap still pending. | Randy Morgan | |
| 2013-09-13 | Page Breaks - round one | Randy Morgan | |
| This sets up the basic col and row break creation and serialization. You can specify either a string reference like "C7" or provide an Axlsx::Cell instance to specify the break point. Serialization is working cleanly but excel does not automatically render those breaks yet. You need to switch to page preview mode. | |||
| 2013-08-17 | add uppercase file for image file checking tests | Randy Morgan | |
| 2013-07-12 | WIP single/dual anchors for images | Randy Morgan | |
| 2013-06-23 | added sparse array transposition with blocks for rows/cols switching and ↵ | Randy Morgan | |
| some docs updates for release prep | |||
| 2013-04-28 | Show whitespace preservation in basic worksheet example. | Randy Morgan | |
| 2013-04-28 | Updated mbcs example to use Arial Unicode MS | Randy Morgan | |
| This font may not be avilalbe in all renderes. | |||
| 2013-04-28 | Refactored and renamed space preservation | Randy Morgan | |
| preserve_spaces has been moved to the workbook and renamed xml_space as that provides a good reference for people trying to figure out what it does, and let's the author specify space preservation for serializations using the shared strings table as well as the default inline serialization in cells. | |||
| 2013-04-18 | Added colors to examples for charts | Randy Morgan | |
| Colors are required by OpenOffice, and LibreOffice, and syntactically correct regardless so we should be putting them in. | |||
| 2013-04-04 | Added support for specifying between/notBetween formula in an array. | Noel Peden | |
| 2013-03-17 | Fixed LineChart and refactored chart axes management | Randy Morgan | |
| 2013-03-16 | First run at 'hidden' comments WIP | Randy Morgan | |
| The xml is genrated correcty, but the comment still shows until it is selected once in the excel ui - so I must be missing something. | |||
| 2013-02-04 | Completed missing docs and pre-release prep | Randy Morgan | |
| 2013-01-10 | update outline_level_rows and outline_level_columns example. | Randy Morgan | |
| 2012-12-15 | Added methods to simplify outlining with specs | Randy Morgan | |
| worksheet#outline_rows worksheet#outline_columns | |||
| 2012-12-14 | Added formula_values options and specs for sheet format pr. | Randy Morgan | |
| This lets cache formula values and specify the default row height so that iOS and Max OSX previews render properly | |||
| 2012-12-04 | Created ios preview example | Randy Morgan | |
| This shows that shared_strings are required. Formula parsing is still outstanding. https://github.com/randym/axlsx/issues/149 | |||
| 2012-11-28 | Added example of overriding data types | Randy Morgan | |
| 2012-11-27 | Merge pull request #148 from alexrothenberg/pivot_table | Randy Morgan (@morgan_randy) | |
| Create a simple Pivot Table | |||
| 2012-11-27 | Merge pull request #147 from raiis/master | Randy Morgan (@morgan_randy) | |
| Different left/right border style | |||
| 2012-11-28 | Better way hot to override borders style. | raiis | |
| 2012-11-27 | Can configure a pivot table when creating it | Alex Rothenberg | |
| see examples/pivot_table.rb wb.add_worksheet(:name => "Data Sheet") do |sheet| sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region'] 30.times { sheet.add_row [month, year, type, sales, region] } sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table| pivot_table.rows = ['Month', 'Year'] pivot_table.columns = ['Type'] pivot_table.data = ['Sales'] pivot_table.pages = ['Region'] end end | |||
| 2012-11-27 | Create a simple Pivot Table | Alex Rothenberg | |
| * an example can be run with `ruby examples/pivot_table.rb` * right now you cannot set options on the pivot table to make it useful (coming soon...) | |||
| 2012-11-26 | Added individual border override options. | raiis | |
| 2012-11-25 | moved sheet view example into examples.rb | Randy Morgan | |
| 2012-11-25 | Cleaned up examples directory | Randy Morgan | |
| 2012-11-25 | Cleaned up gemspec and removed pdf export example | Randy Morgan | |
 |
index : caxlsx | |
| Caxlsx | realtradam |
| summaryrefslogtreecommitdiffhomepage |