AnsweredAssumed Answered

Charts can't handle international numbers (comma-separated decimals)

Question asked by wirsberg on Jan 23, 2011
Latest reply on Feb 24, 2011 by TSGal

Summary

Charts can't handle international numbers (comma-separated decimals)

Product

FileMaker Pro

Version

11v2

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.

Expected result

2.1

Actual result

21

Exact text of any error message(s) that appear

none

Configuration information

File options > Text > "use current system's settings"

operating system's number format: "2.345.678,9" (comma as decimal separator)

Workaround

none

FM11-Charts-error.png

Outcomes