summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
-rw-r--r--CHANGELOG.md1
-rw-r--r--examples/pivot_table_example.md2
2 files changed, 2 insertions, 1 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md
index 9d951aae..1ed85f1e 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -2,6 +2,7 @@ CHANGELOG
---------
- **Unreleased**
+ - [PR #79](https://github.com/caxlsx/caxlsx/pull/79) - Add support for format in pivot tables
- **January.5.21**: 3.0.4
- [PR #72](https://github.com/caxlsx/caxlsx/pull/72) - Relax Ruby dependency to allow for Ruby 3. This required Travis to be upgraded from Ubuntu Trusty to Ubuntu Bionic. rbx-3 was dropped.
diff --git a/examples/pivot_table_example.md b/examples/pivot_table_example.md
index 21176a73..8dd12955 100644
--- a/examples/pivot_table_example.md
+++ b/examples/pivot_table_example.md
@@ -27,7 +27,7 @@ wb.add_worksheet(name: 'Basic Worksheet') do |sheet|
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.data = [ref: 'Sales', num_fmt: 4]
pivot_table.pages = ['Region']
end
end