However, Spreadsheet::WriteExcel has been known to have issues, especially when working with Spreadsheet::ParseExcel, primarily with formulas.

"Issues" might scare away the punters. ;-)

The situation is as follows. Excel writes a formula in two parts. The RPN binary encoding of the formula and the result of the calculation. Spreadsheet::WriteExcel only writes the encoded formula part because it wouldn't be possible to the calculate, a priori, the result of arbitrarily complex expressions. Equally Spreadsheet::ParseExcel only reads the result part of a formula because it isn't in a position to evaluate the formula. Therefore, when Spreadsheet::ParseExcel reads a formula written by Spreadsheet::WriteExcel it only sees a blank result.

In the circumstances this is a best effort by both modules and most users would be unaffected by it.

John.
--

In reply to Re: Re: Re: Excel Spreadsheet Data Set by jmcnamara
in thread Excel Spreadsheet Data Set by rob_au

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.