クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

Why do percentages with decimals default to 0 decimals, even though "Auto" is labeled the default?

回答済み
0

コメント

4件のコメント

  • Linda Walter

    Thanks for raising this Andrew. I should have thought to do this a long time ago as well. I have that same question/problem in that I want the default to be 0 for numbers, but it always defaults to 2, even though auto is showing 0.  (This is the same problem for currency as well.)

    0
  • Andrew McKenzie

    Exactly right Linda Walter; I've observed that one too but forgot about it. I compared this to Excel, which also forces exactly two decimals (only) onto Numbers, so maybe some of this is intended to match Excel's behavior? Although the percentage behavior is still different:

    Either way, the use of "Default" in the labels seems confusing/wrong for both types.

    0
  • Isabel Messore

    Hi Andrew McKenzie,

    Really solid question here. While I'm sure there are a myriad of thoughtful reasons why value formatting was set up the way that it was originally, we've opted to solve this problem by putting more control over how value formatting works in the hands of file owners via Value Format Styles (beta).

    VFS allows users to specify the defaults of each value format from the style guide editor. VFS is in beta today and will be launched later this year. If you think this beta feature would be a good fit for you, please let me know and I can coordinate the process of getting you added to the beta program!

    0
  • Andrew McKenzie

    Thanks Isabel Messore—and, yes, we would be interested in joining the VFS beta if possible.

    0

サインインしてコメントを残してください。