Charts can't handle international numbers (comma-separated decimals)
Operating system version
Mac OSX 10.6.6
Description of the issue
chart object doesn't handle International decimal numbers, separated by comma ",", instead charts ignores the comma and reads a decimal i.e. "2,1" as "21".
Steps to reproduce the problem
- open a FM file with
> File Option > Text > "Ask whenever settings are different"
- look at a chart based on decimal numbers.
- In Mac OSX system's settings, go to "international > formats > numbers" and set decimal separator to comma ",". You can leave the window open.
- switch back to Filemaker's open file showing a chart. Have the file use "systems settings" if asked. have the window's contents get refreshed. See decimal numbers automagically and transform to use "," as separator as expected. (the data formatting settings of number fields should be "general"). Look at the chart and see how the chart's bars jump wildly as the chart now ignores the "," decimal separator in the numbers based on!
- go back to MacOS and switch systems format settings back.
Exact text of any error message(s) that appear
File options > Text > "use current system's settings"
operating system's number format: "2.345.678,9" (comma as decimal separator)