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

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

回答済み
デモをリクエスト

If I create a new spreadsheet and enter a figure like "8.76%" into a cell, this will be displayed as 9% by default.

While that doesn't seem ideal (to me), this isn't my real issue. My question is, when I select the Decimals drop-down where "0" is displayed, the list of options shows that "Auto" is the default:

So is "Auto" the actual default for the precision for an entered percentage, but I've overridden this setting somewhere? And/or is there a way to change this so that the default actually is "Auto"? Or am I misunderstanding the label?

0

コメント

5件のコメント

日付 投票
  • 正式なコメント
    Isabel Messore

    For any users who may have come across this thread, a quick update!

    Value Format Styles (VFS), part of our Dynamic Table Management suite, is Generally Available (GA) across all environments!

    You can now use the Style Guide Editor to define, save, and manage default value formats (including Percent, Number, Currency, Accounting, Date, and Period) across spreadsheets and tables. File owners can also lock format styles to prevent unauthorized cell-level overrides and use the VFS overlay to review applied styles across their files.

  • 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

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