https://bugs.documentfoundation.org/show_bug.cgi?id=154137
--- Comment #1 from ady <[email protected]> --- The following tip might help, but it may also need some adjustment. Introducing a static value for DATE and/or TIME can (potentially) be achieved by adequate keyboard shortcuts (when using the classic English USA QUERTY keyboard layout). Insert current date (static): [CTRL]+[;] Insert current time (static, i.e. timestamp): [CTRL]+[SHIFT][;] You can also: 1. Enter edit mode (F2) 2. [CTRL]+[;] 3. [SPACE] bar (for example) 4. [CTRL]+[SHIFT][;] 5. [ENTER] Introducing any of the above in one cell allows you to use it "statically", i.e. it will not get updated unless you change it manually. Then you can use that cell in other formulas. These keyboard shortcuts might not work with other keyboard layouts (bug?), but you can go to menu Tools > Customize > Keyboard and adapt it to your needs. Independently of the requested functions, the correct functionality of the mentioned keyboard shortcuts (or alternative ones) for non-QUERTY(USA) layouts / languages should be checked and corrected if necessary (because it does not always work as users expect). -- You are receiving this mail because: You are the assignee for the bug.
