XML parses HRef inccorectly

E

ennetws

I am trying to write XML spreadsheet documents programmatically. However,
there seems to be a bug when Excel reads the XML spreadsheet and parse the
HRef attribute of a Cell.

I am having this problem for relative paths. If I have
'Parent/Child/file.txt' and I assign an HRef attribute for it Excel on
Windows machines adds extra folders to the path resulting in
'Parent/Child/Parent/Child/file.txt'.

This looks like a bug. I tried opening the same XML spreadsheet on the Mac
version of Excel and it works fine. I tried opening it on OpenOffice Calc and
it works perfectly. I tried adding dots and slashes to the path but nothing
worked.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding custom menus to existing excel application 0
Converting data format from .xsl to .xml 0
XML Spreadsheet and Calculation Mode 0
use vba to open pdf then save as xml 6
A Look At XPath 0
Exporting to .txt converts single quotes to double quotes 4
XML in Worksheet w/o Looping 0
Populate Excel 2003 Spreadsheet with XML Data 0

Top