https://bugs.documentfoundation.org/show_bug.cgi?id=165209
--- Comment #3 from Jonny Grant <[email protected]> --- Thank you for the link. Yes, that seems to be the workaround. Calc unexpectedly changes the currency format from $ (USD) to £ (GBP) without any clear reason or logic. Attempts to manually set the correct formatting do not fully resolve the issue. Expected Behaviour: Calc should not change the currency format arbitrarily. Setting the language to English (USA) should retain the $ currency symbol. Users should not have to manually adjust formatting multiple times to display the correct currency. Calc should just "Detect special numbers" and retain the $. Raises a few issues/bugs 1. No reason or logic for Calc to change currency from $ to £ 2. Given (1) bug, I set to English (USA), and still bug (1) occurs. 3. Given (1) and (2) why I need to manually scroll and set that column to "US English", which then loads and removes the $ sign, so I am left with numbers and no $. -- You are receiving this mail because: You are the assignee for the bug.
