From fb7b437a2c75075c6ff99e441a0cf22428b2ebdc Mon Sep 17 00:00:00 2001
From: Rob Donnelly <rfdonnelly@gmail.com>
Date: Wed, 3 Feb 2021 13:08:22 -0800
Subject: Fix special characters in pivot table cache definition

---
 lib/axlsx/workbook/worksheet/pivot_table_cache_definition.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/axlsx/workbook/worksheet/pivot_table_cache_definition.rb b/lib/axlsx/workbook/worksheet/pivot_table_cache_definition.rb
index f136b663..969b0bf2 100644
--- a/lib/axlsx/workbook/worksheet/pivot_table_cache_definition.rb
+++ b/lib/axlsx/workbook/worksheet/pivot_table_cache_definition.rb
@@ -53,7 +53,7 @@ module Axlsx
       str <<   '</cacheSource>'
       str << (  '<cacheFields count="' << pivot_table.header_cells_count.to_s << '">')
       pivot_table.header_cells.each do |cell|
-        str << (  '<cacheField name="' << cell.value << '" numFmtId="0">')
+        str << (  '<cacheField name="' << cell.clean_value << '" numFmtId="0">')
         str <<     '<sharedItems count="0">'
         str <<     '</sharedItems>'
         str <<   '</cacheField>'
-- 
cgit v1.2.3