https://bugs.documentfoundation.org/show_bug.cgi?id=115078
--- Comment #28 from Mike Kaganski <mikekagan...@hotmail.com> --- (In reply to Heiko Tietze from comment #24) > ... I wonder if it was > better located at the cell style. Doing so makes it possible to have normal > input and dedicated templates or a cell style / numbering format attribute > for the accountant task. However, the attributes are usually stored in the > document and without standardization we cannot do that. No. This asked feature is completely about a specific person's habits. it is intended to reduce load by utilizing muscle memory, and not requiring to concentrate on some detail that gets done automatically. As such: 1. It is *NOT* imposed on other potential users of the document. Other users are free to not use this feature, and have all reasons so get angry, when suddenly, when *they* type '123', it automatically converts to '1.23'. 2. It is *NOT* expected to depend on file, or on specific column - just because that would mean that the user *has to* concentrate on details, and switch their muscle memory depending on file, column, or a specific cell. It is definitely a per-user-profile setting, orthogonal to any "mask-like" possible features. A possible code pointer to implement this feature would be ScInputHandler::EnterHandler (sc/source/ui/app/inputhdl.cxx), which (or the functions called from it) would check that the input text has only numbers and plus/minus (but no decimal / group separators; no formulas, percents, etc.), and the resulting data is numeric; then it would multiply the end result by respective 10^n. At least that would be the function, where I would start my research - which events happen when I finished entering the data. -- You are receiving this mail because: You are the assignee for the bug.
