LibreOffice should better improve the intuitive usability of the most used basic functions than adding more and more enhancements. LibreOffice is a good program, but it's peculiarities sometimes make me crazy and let me think of choosing another office program.
1. I want to disable the ugly grey field-shading of hyperlinks in CALC. The special color of the text foreground (visited and unvisited links) would to be enough to mark hyperlinks (like in in other spreadsheet programs). If I un-check ("ON") in the check box at "Tools > Options > Appearence > Textdocument > Field Shadings" there is no change (BUG ?). I do not want to choose a different color in the color setting box, I want always the same color as the background of the cells (transparent background).
See also http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=32519, http://de.openoffice.info/viewtopic.php?f=2&t=8983 (german)
2. Why there is no quick function to delete a hyperlink (e.g. in right-click context-menu). Instead you have to use "Format > Clear Direct Formating". I think, nobody would intuitely get access to this solution, which does not only delete the hyperlink but all formating (colors) of the cell.
Wolfgang: Could you please attach an example document displaying the problem?
Created attachment 81951 [details]
example for hyperlink with grey background
Wilhelm, here it is.
I think, if I uncheck Custom Colors, Box "On", Field shadings, there should be NO grey or other color background for the link.
If this is no bug,
how can I get rid of the field shading (color) in CALC.
This is a annoyance that many users have.
To set the color of the field shading white is NO solution, if the cell has another background than white.
This appears to be a bit of an awkward bug. It is evidently a very old problem inherited from the original OOo code. Related AOO bug is https://issues.apache.org/ooo/show_bug.cgi?id=37988 which references v1.1.3. As such I am setting the status to NEW as I feel this is a confirmed issue, it is merely the solution that is unconfirmed.
I believe that the way in which hyperlinks are handled in Calc, needs to be made consistent with how they are handled in Writer i.e., via styles-based formatting. This would require implementing character styles in Calc.
By way of comparison, a hyperlink in Writer is controlled by the character styles Internet Link and Visited Internet Link. Unchecking the option in question (or using CTRL+F8) in Writer does remove the grey highlighting of, for example, a cross-reference field, but does not affect the appearance of a hyperlink. It is probably also worth noting that the option is listed beneath the Text Document, rather than Spreadsheet, section.
The term "field" in particular seems to cover a broad range of possibilities with regard to shading. For example, certain Unicode characters like Zero Width Space (U+200b) and No Break Space (U+00a0) are currently included. These Appearance options probably require a reworking.
*** Bug 89271 has been marked as a duplicate of this bug. ***
Any chance of seeing this solved in the near future?
I have checked in Apache OpenOffice Calc 4.1.1 and they have solved this bug.
Are you going to sove it in LibreOffice Calc?
Workaround: use the function HYPERLINK() instead of automatic recognition of hyperlinks.
Best regards. JBF
This could work if I whould create the document.
But in my case, I receive documents already created by others using Microsoft Excel Office.
These excel documents have hundreds of links and I get updated documents every week.
I thank you for geting envolved in this issue!
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
Nothing changed in LO 188.8.131.52.0+ and master, both build at home under Ubuntu
Set as enhancement because this field shading is there by design.
Set version to inherited from OOo because it was already the case in OOo and LO did not change that.
Best regards. JBF
Just want to confirm that I also have this problem. Calc version 184.108.40.206 on Windows 10.
I confirm for point 2 of firstname.lastname@example.org. I was to open a bug but by looking in Bugzilla with "Calc" "Hyperlink", I came across this bug. And I found the solution exposed long version by email@example.com!
Again, want to confirm this. Field shading is impossible to remove. I cannot believe it doesn't bother more people. Deleting a link from context menu would be very handy.
Tried on mac and ubuntu, version 6.0
*** Bug 119825 has been marked as a duplicate of this bug. ***
@Heiko, I thought you could be interested in this issue...
(In reply to Xisco Faulí from comment #15)
> @Heiko, I thought you could be interested in this issue...
Will have a look
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":
Resolves: tdf#66545 display URL fields non-shaded in Calc
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Thank you, Eike, for your patch to close this old bug!
Now I see complains coming that the shading isn't an option to activate/deactivate.
*** Bug 83296 has been marked as a duplicate of this bug. ***
Solved. Ferified on:
Build ID: 3846561f79cf9065abd9ca83c9fbfbe7e52e28e2
CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk3;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-10-21_02:45:54
Locale: en-US (ro_RO.UTF-8); Calc: threaded
OMG. Thank you so much for FINALLY getting rid of this decade old aggravating bug! These kind of details are the reason some people don't fully switch to LibreOffice. I've been reluctant to switch until this was fixed and forgot to re-check this thread last year. I'll update to 6.3.3 now! Thanks Eike Rathke!