Bug 89271

Summary: Enhancement: Deactivate field shading of links in Spreadsheets
Product: LibreOffice Reporter: enemarcel
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: enhancement CC: raal
Priority: medium    
Version: unspecified   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Different cell background makes the field shading hide the cell background.

Description enemarcel 2015-02-09 21:10:02 UTC
Created attachment 113264 [details]
Different cell background makes the field shading hide the cell background.

From Calc Menu - Tools - Options - LibreOffice - Appearance - Text Document - Field shadings, I can change the field shading color of a link but I can not cancel this feature although there is a check buton that produce no results if unchecked.
I can only "hide" the "Field Shadings" by choosing the same color as the cell background color but if I change the background color to a different one, then the field shading of the link becomes visible again. 
I attach an example in order to understand what I mean.

This could be solved by adding a trasparent option in the color settings(right to the "Field Shadings") or by deactivating the shadings when unchecking the "Field Shadings" button.
Comment 1 A (Andy) 2015-02-09 23:08:27 UTC
Changed to Enhancement request, but I myself have no opinion yet to it and therefore I left it still as Unconfirmed for other users.
Comment 2 raal 2015-02-10 07:44:05 UTC
Hello enermarcel,

Thank you for reporting the bug. Can you see if bug 66545 is similar to your problem so that I can mark your report as a duplicate of it? (Later bugs are generally marked as duplicates of earlier bugs).
Comment 3 enemarcel 2015-02-10 07:50:47 UTC
The reason why I request this is because I use spreadsheets often with one sheet being summary with links for 500 to 700 other sheets in the same document. When I solve one of the pages, I mark it down with a different color but because of the links have a different collor (the Field Shadings), wich shows above the collor of the celles I mark, the marking it's difficult to spot.

This feature is present in Microsoft Excel or Google Spreadsheets.
Comment 4 enemarcel 2015-02-10 08:12:31 UTC
(In reply to raal from comment #2)
> Hello enermarcel,
> 
> Thank you for reporting the bug. Can you see if bug 66545 is similar to your
> problem so that I can mark your report as a duplicate of it? (Later bugs are
> generally marked as duplicates of earlier bugs).

Sorry, I didn't found it before writing my own request down. Yes, it's the same think, unfortunately. I can't believe this problem is so old. I just lost my morale.
This make's me think that people do not use Calc other then for some minor thinks. Maybe because it's bean more then a year and still not solved, it's easiear to just give up and find other alternatives.

You can mark it as duplicate.
Comment 5 raal 2015-02-10 08:20:52 UTC

*** This bug has been marked as a duplicate of bug 66545 ***