From d74e85d1ac03954ce1d687fb1245cbee38c4f718 Mon Sep 17 00:00:00 2001 From: Koza Date: Mon, 2 Oct 2023 13:52:34 +0200 Subject: Update examples to unescape formulas --- examples/basic_formula_example.md | 2 ++ examples/cached_formula_example.md | 2 ++ examples/column_outlines_example.md | 2 ++ examples/complex_example.md | 2 ++ examples/defined_name_example.md | 2 ++ examples/row_outlines_example.md | 2 ++ 6 files changed, 12 insertions(+) diff --git a/examples/basic_formula_example.md b/examples/basic_formula_example.md index d19288fb..5a6eb878 100644 --- a/examples/basic_formula_example.md +++ b/examples/basic_formula_example.md @@ -7,6 +7,8 @@ You could insert formulas ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook diff --git a/examples/cached_formula_example.md b/examples/cached_formula_example.md index e5b82264..47855b59 100644 --- a/examples/cached_formula_example.md +++ b/examples/cached_formula_example.md @@ -7,6 +7,8 @@ When you add a formula in Excel, it immediately calculates its value and store i ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook diff --git a/examples/column_outlines_example.md b/examples/column_outlines_example.md index 6d402af5..5e2557e4 100644 --- a/examples/column_outlines_example.md +++ b/examples/column_outlines_example.md @@ -7,6 +7,8 @@ If you have a list of data that you want to group and summarize, you can create ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook diff --git a/examples/complex_example.md b/examples/complex_example.md index 4f395b02..c0c8d7f4 100644 --- a/examples/complex_example.md +++ b/examples/complex_example.md @@ -7,6 +7,8 @@ This is a complex example with a worksheet full of data. ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook diff --git a/examples/defined_name_example.md b/examples/defined_name_example.md index ce998263..b2dd3a80 100644 --- a/examples/defined_name_example.md +++ b/examples/defined_name_example.md @@ -7,6 +7,8 @@ You could use defined names in formulas ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook diff --git a/examples/row_outlines_example.md b/examples/row_outlines_example.md index baa48cfe..78c0d55a 100644 --- a/examples/row_outlines_example.md +++ b/examples/row_outlines_example.md @@ -7,6 +7,8 @@ If you have a list of data that you want to group and summarize, you can create ```ruby require 'axlsx' +Axlsx.escape_formulas = false + p = Axlsx::Package.new wb = p.workbook -- cgit v1.2.3