Question

The SpreadSheetPlugin's REPLACE function mishandles strings with trailing zeroes. The result of $REPLACE(70, 2, 1) is "70," while the result of $REPLACE(71, 2, 1) is "7."

I'm running v10197 of the Plugin which isn't, I know, the latest, but the release notes for v15270 mention nothing about this bug. (I will work with my admin to get v15270 installed anyway.)

Environment

-- RobStewart - 23 Jul 2008

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Hey Rob,

there is a bug registered and confirmed on that issue. See Item5471 in the Bugs web. So for the moment, we can do nothing else but wait.

I changed the status of your request to ClosedUnanswered. Please feel free to change it again and/or add your experience to the existing bug report.

-- SebastianKlus - 23 Jul 2008