Bug 137193

Summary: Calc gridlines disappear on formula cells
Product: LibreOffice Reporter: Bill <home>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: buzea.bogdan, miguelangelrv
Priority: medium    
Version: 6.0.1.1 release   
Hardware: Other   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Calc worksheet

Description Bill 2020-10-01 17:51:26 UTC 
Description:
When I enter =IF((B2+F2)>B2, F2-B2,"") in column h, the gridlines immediately disappear. If I remove the formula, gridlines reappear. If I past the formula anywhere, gridlines disappear. A formula without the if operator doesn't do this. Can I prevent gridlines from disappearing? 

Actual Results:
Enter a formula containing the if operator.

Expected Results:
Gridlines immediately disappear.


Reproducible: Always


User Profile Reset: No



Additional Info:
Gridlines should remain stable.
Comment 1 m_a_riosv 2020-10-02 17:24:20 UTC 
Please attach a sample file where it happens.
Comment 2 Bill 2020-10-02 17:54:03 UTC 
Created attachment 166043 [details]
Calc worksheet

I should also have said that the lines disappear around the formula cells only, the rest of the sheet is unaffected.
Comment 3 BogdanB 2020-10-02 19:50:59 UTC 
Bill, please:

Select columns F G and H and press Ctrl+M

or

Select columns F G and H and go to Format - Clear Direct Formatting.


Waiting for your answer if this solved your problem.
Comment 4 Bill 2020-10-02 20:08:41 UTC 
That did solve it, thank you. What exactly does ctl-m do?
Comment 5 BogdanB 2020-10-02 20:32:05 UTC 
It removes all the formatting you have done and now creating problems.

Ctrl+M it's a shortcut for "Clear Direct Formatting"