This patch release of Xdata addresses problems with the format() function and adds pass-thru of the indent-to-here character.
Changes
- Fixed a problem where native indent-to-here characters (#30) were being stripped from imported text.
- Added negative and zero sections to format()‘s format string, which now allows
"positive numbers;negative numbers;zero values"(where sections are separated by semicolons). For example,format("0", "#,###;(#,###);zero")would produce"zero". - Fixed the format() function to strip leading zeros, such that
format("0","#,###")now returns""rather than"0". To preserve leading zeros, use a placeholder 0 (zero). - Fixed a problem with the format() function where different forms of zero (like 0, 0.00 and -0) weren’t being formatted the same.