in reply to Bulletpoints in spreadsheet being converted to double quotes

G'day viffer,

Some additional information would be helpful.

What is the format of your spreadsheet:

It's somewhat unclear exactly what conversion is taking place. Is your '• content' being converted to '" content', '"content"', or something else. A link to a minimal sample of your input file, as well as showing us (a representative part of) the contents of @arr, would be useful.

The documentation for Spreadsheet::ParseExcel would suggest that $cell->unformatted() might be appropriate; however, the source code for that method shows:

sub unformatted { my $self = shift; return $self->{Val}; }

It's entirely possible that by ignoring the published interface, and circumventing the OO encapsulation, that you've caused some problem(s) which may be hard to track down.

Anyway, once you've supplied the information requested above, we may have a better idea.

-- Ken