Loading...
 
Skip to main content

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

  • Tracker item actions
List all trackers List items
Status
Open
Subject
Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart
Version
15.x
16.x
17.x
Category
  • Conflict of two features (each works well independently)
  • Error
  • Dogfood on a *.tiki.org site
  • Less than 30-minutes fix
  • Support request
Feature
Charts and Data Visualization
Import-Export
Spreadsheet
Resolution status
New
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro
Rating
(0)
Description

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

Reproduced when attempting to export sheet4 in doc.t.o, which is part of the sample charts generated from the tiki spreadsheet feature:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=4

When exported (as csv with comma, and utf8) the content is like:

Copy to clipboard
Chart Type,Example,Chart,Data,Month,Year Vertical Bar,"=BARCHART(D2:D13),<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1,4,Jan,2001 Horizontal Bar,"=HBARCHART(D2:D13),<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116,,6,Feb,2002 Pie,"=LINECHART(D2:D8, F2:F6)",<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A,7.2,Mar,2003 Line,"=PIECHART(D2:D8, E2:E8)",<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5,7.5,Apr,2004 ,,,8.2,May,2005 ,,,9.1,Jun,2006 ,,,14.1,Jul,2007 ,,,16,Aug,2008 ,,,17.9,Sep,2009 ,,,22,Oct,2010 ,,,30,Nov,2011 ,,,32,Dec,2012 ,,,,, ,,,,,


And in my honest opinion, it should be something like:

Copy to clipboard
Chart Type,Example,Chart,Data,Month,Year Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001 Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002 Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003 Pie,"=PIECHART(D2:D8, E2:E8)",=PIECHART(D2:D8, E2:E8),7.5,Apr,2004 ,,,8.2,May,2005 ,,,9.1,Jun,2006 ,,,14.1,Jul,2007 ,,,16,Aug,2008 ,,,17.9,Sep,2009 ,,,22,Oct,2010 ,,,30,Nov,2011 ,,,32,Dec,2012 ,,,,, ,,,,,
Files
  1. Export Sheet4
  2. Export Sheet4 Orig
Importance
8
Easy to solve?
8
Priority
64
Demonstrate Bug on Tiki 19+
Please demonstrate your bug on show2.tiki.org
Demonstrate Bug (older Tiki versions)
Ticket ID
6264
Created
Friday 27 January, 2017 11:24:55 UTC
by Xavier de Pedro
LastModif
Saturday 06 July, 2024 10:21:44 UTC


Show PHP error messages