Description: on editing a cell calc applied unwanted fonts, it was very difficult to change them back, may be it's 'standard', it's a 'feature', or just erroneous options set by me or by default, it's been driving me nuts to try, try, try again and again to correct a wrong applied font in one cell ... on confirmation with enter calc jumped back to the 'old' formatting and display, the solution is - as i assume - that calc does something like 'alike-search' or 'similarity-search', and applied the font setting from other instances (the same text in other cells). As i couldn't change plenty cells at one time and as calc 'remembered' something after deleting all theese cells, the final workaround was: - delete all wrongly formatted cells from the file, - close the file, - create a temporary file and a cell with the right content and formatting in this file, - open the affected sheet, - copy and paste the newly created cell from the temporary sheet, any hints appreciated, filed as a bug in an attempt to try to beware other users to waste their time - it would make sense to implement a message or warning 'attention, there was an automatic adaption, do you want to take it? or use your original input?' reg. b. Steps to Reproduce: actually i'm too short in time to investigate about reproductivity ... Actual Results: fonts obstinate changed by the program Expected Results: when a user applies a font it should be respected by the program Reproducible: Always User Profile Reset: No Additional Info: Version: 6.3.0.0.alpha1 (x64) Build ID: 547edd20e527fb02900f6174973770d26306e2e7 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc:
solution: all? (almost most) unwanted formatting changes and changes of content can be undone by hitting ctrl-z after the change, calc performs and stores two different steps, first the change by the user, then the change be 'prettyfying', 'similarity search' or whatever, with the first 'ctrl-z' after that the user can undo unwanted automatic changes, with the second 'ctrl-z' his input is undone, nice feature!, but!!! there should be some more hints on this behaviour, preferably it should be turned off on a fresh install, and only be activated on user request, otherwise - as it is now - it may take plenty of time of a user to investigate why the program doesn't follow his intention ... reg. b.