adds ticks around multi-word titles in chart references

Issue #99 resolved
aceMueller
created an issue

attached change set built on 424 from fork on same; test case included; if a sheet has a multiple word title (sheet name), and a chart is embedded on that sheet, Excel opens it just fine (Excel 2007 on XP), but if you then change the data values in the columns, the changes ARE NOT REFLECTED IN THE CHART. But if the title is in ticks in the reference, then the changes are reflected. (And in fact, if one does this manually in Excel, one notices that the references in the chart data definition have ticks around the sheet names.) While I suspect that any title could be encased in ticks, but I don't know that, so this fix was the minimally invasive fix to a demonstrable problem.

Comments (1)

  1. Log in to comment