Description: Table in Writer has negative currency cell values formatted to 'Automatic' as red. Cell formula = cell a * cell b Scenario A: All positive > cell values black before and after Save == OK Scenario B1: Negative values a=1, b=-1: target cell text coloured *and* automatic red. Scenario B2 later *in same session*, set b=1. Now target cell text black and automatic == OK. Scenario C1: do B1 again and Save. Scenario C2: Open file & set b=1. Target cell format is now coloured red and *not* automatic. This isn't obvious when working and screws it for the recipient. Steps to Reproduce: as description Actual Results: calculated cell formatted to fixed red after Save Expected Results: calculated cell formatted to automatic black after Save Reproducible: Always User Profile Reset: No Additional Info: not messed-up on Save. This has been consistent over several iterations of LO
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 146695 [details] Table in Writer as requested
Andrew, please write exact steps according to sample. Sample should be minimal test case and correspond fully to steps. Sorry for asking, but if not consistent, we spend too much time finding out what you report.
Dear AndrewB, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Now working as expected thanks
(In reply to AndrewB from comment #5) > Now working as expected thanks Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.