If I set cell to coin with Shekel sign then the sign is place in right side of number (14 ₪) but its need to be in left side (₪ 14). Platform: Ubuntu 11.10, Gnome 3.2.1
I can not reproduce this issue on WindowsXP 64bit with English (USA) language (LibreOffice 3.5.0rc3). On properties currency format for ILS Hebrew format code displayed as "[$₪-40D] #,##0.00;[RED][$₪-40D] -#,##0.00" (on cell values displayed as "₪ 14"). Please correct me if I use wrong format.
I can confirm the issue on LibO 3.5.0 on Debian GNU/Linux. The problem occurs only when using a right-to-left interface and doesn't happen with the left-to-right interface.
Created attachment 68768 [details] test document
Created attachment 68769 [details] How the test document looks with RTL interface
A workaround which I'm not sure is the right solution would be to add an LRM before the ₪ sign making it behave like the dollar sign.
Lior Kaplan committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dcbf9238ba3354aafbcbfa0c15980587cf31fe96 fdo#46807: Add LRM before Shekel sign, forcing it to appear left of numbers The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lior Kaplan committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=680b58efa54d5c5b773a7c2d57b3a27453c6a5a2&g=libreoffice-3-6 fdo#46807: Add LRM before Shekel sign, forcing it to appear left of numbers It will be available in LibreOffice 3.6.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.