[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 sdc.bla...@youmail.dk changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||1322 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 sdc.bla...@youmail.dk changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=44 ||189 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 sdc.bla...@youmail.dk changed: What|Removed |Added CC||sdc.bla...@youmail.dk --- Comment #13 from sdc.bla...@youmail.dk --- (In reply to Telesto from comment #12) > Lets add the documentation department. See comment 9 and 11 What exactly needs to be changed/added? IIUC something is needed for WRITER, but could not decipher what the "something" is from comment 9 and comment 11. Also any suggestions about "where"? Perhaps here?: https://help.libreoffice.org/7.2/en-US/text/shared/01/05020400.html -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Thomas Lendo changed: What|Removed |Added Blocks||120200 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=120200 [Bug 120200] [META] Update or correct help for features -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Telesto changed: What|Removed |Added OS|Linux (All) |All Component|Calc|Documentation Status|RESOLVED|NEW Resolution|WONTFIX |--- CC||olivier.hallot@libreoffice. ||org --- Comment #12 from Telesto --- Lets add the documentation department. See comment 9 and 11 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 --- Comment #11 from Luke Kendall --- Because I've learned from this that the hyperlink style does not work like it does in Writer (and Draw?), it's okay by me if you resolve this as Won't Fix. I do think that other users may fall into the same trap I did. Maybe that's something that could be addressed by adding to the documentation. As I said in comment 4, in response to comment 3, I couldn't find a way to apply the formatting directly to have a visible effect on the colour. That might mean the ability to set the colour is misleading (but maybe it does work that way when applied from a formula)? Anyway, I just thought I'd make that observation. I'm happy for you to decide. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX Status|NEW |RESOLVED Severity|normal |enhancement --- Comment #10 from Heiko Tietze --- Okay, you got me convinced. Hyperlink cell style is meaningful so this request is WF. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456
--- Comment #9 from Mike Kaganski ---
(In reply to Heiko Tietze from comment #7)
> Sorry, but I don't get the point of cell formatting with hyperlink style.
> Sure, I can enter www.foo.bar and undo the auto formatting (links are shown
> in lighter blue without underlining) and apply the cell style.
No it's not for this use case at all. The style is not for a random cell where
you put an URL, and artificially disable URL recognition. It's (as other styles
in Calc) for potentially huge ranges of cells with structured data (here:
formulas).
Imagine a spreadsheet with goods of this company; in column A, there's an ID;
then its name in B, price in C, and clickable URL in D. How would those URLs in
D be created? There are maybe tens of thousands of rows - would you type
"http://www.thisfictionalcompany.com/?id=1234; by hand ten thousand times? No,
you will use a formula which would take the id from A, like this (in D2):
> =HYPERLINK("http://www.thisfictionalcompany.com/?id=; & A2; "Click to see
> full description for " & B2)
Try this formula yourself, and see how it creates a clickable cell ("Ctrl+Click
to go to ..."), which you can expand (copy to 1000s of rows) in usual Calc's
ways (e.g., auto-filling, etc) - but it doesn't get coloured as hyperlink!
Are you suggesting to apply direct formatting to those 1000s of cells? The
style is to select D, and apply the style. Is it wrong?
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 --- Comment #8 from Telesto --- (In reply to Heiko Tietze from comment #7) > My take: remove Hyperlink cell style from Calc. I agree -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #7 from Heiko Tietze --- Sorry, but I don't get the point of cell formatting with hyperlink style. Sure, I can enter www.foo.bar and undo the auto formatting (links are shown in lighter blue without underlining) and apply the cell style. But this example is very much artificial. My take: remove Hyperlink cell style from Calc. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456
--- Comment #6 from Mike Kaganski ---
In Calc, the "hyperlink" cell style is intended for the cases where Calc does
*not* apply the hyperlink formatting automatically: e.g., for a column of
formulas like '=HYPERLINK("www.example.org?q=")'. Setting that column to
that style helps the formatting, and is perfectly logical.
But for automatically applied text run formatting, the colors are taken from
Options->LibreOffice->Application Colors (Unvisited/Visited links). I don't
know if there's a way to define the other properties of hyperlink text - but I
don't expect spreadsheet to provide too flexible ways to format parts of cells,
which is anyway only possible manually on per-cell basis, while in all other
aspects, spreadsheet documents are about bulk operations involving same
formulas, formatting, etc in thousands of cells... (But yes, if this is out of
user control at least in some way, like the formatting applied automatically,
it's not good.)
Actually I would love to see "Application Colors" to transform into
"Application Formatting", with each element presenting not only color, but also
other applicable properties, e.g. font and background. Then defining the look
and feel of an auto-applied hyperlink formatting could be done in a single
place. (But it's an off-topic, I realize.)
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com, ||mikekagan...@hotmail.com --- Comment #5 from Heiko Tietze --- If it was Writer I would immediately switch from direct formatting to character style. But Calc does not have a text style, only the whole cell can be formatted as hyperlink. Meaning content like "Click here http:\\foo.org" would be formatted as a whole. Eike, Mike: what do you think? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 --- Comment #4 from Luke Kendall --- I couldn't find a way to apply the style manually to check that. I tried selecting the text and then double clicking Hyperlink style in the Manage Styles dialogue. I tied selecting Fill Format mode in the MS dialogue and clicking on the cell. When I do either of those things, the underline style chosen in the text style is applied. But the colour is not. So maybe it is a genuine bug. And yes, I'm referring to Calc, nott Writer. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Telesto changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #3 from Telesto --- Not sure what the idea was with the Hyperlink style.. a hyperlink is created automatic, but the style isn't attached to it.. You have to apply it manually (and will work after all) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Telesto changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from Telesto --- OK checked Calc Not working in 7.1 nor in 6.0 style is not present in Version: 5.3.0.2 Build ID: 5ad7b2889021c491af62f7930a4b1cb631392f16 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; Locale: nl-NL (nl_NL); Calc: group and older versions -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134456] Hyperlink colours cannot be changed by changing Hyperlink style
https://bugs.documentfoundation.org/show_bug.cgi?id=134456 Telesto changed: What|Removed |Added CC||tele...@surfxs.nl --- Comment #1 from Telesto --- This is about Writer, I assume.. As the component is set to Calc -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
