in reply to Is it possible to use back references across worksheets with Excel::Template?

Looking through the code and the test cases for Excel::Template it looks like backref can only access references in the same worksheet scope.

As an alternative you could look at Spreadsheet::WriteExcel::FromXML or Spreadsheet::WriteExcel itself which doesn't have this limitation.

--
John.

  • Comment on Re: Is it possible to use back refrences across worksheets with Excel::Template?

Replies are listed 'Best First'.
Re^2: Is it possible to use back refrences across worksheets with Excel::Template?
by normskib (Initiate) on Oct 12, 2011 at 20:21 UTC

    Thanks for the feedback John

    I'm used to using HTML::Template so Excel::Template was an easy transition for me but I'm now beginning to see some of it's limitations.