[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 --- Comment #8 from Rafael Lima --- In my opinion, we do not need to add Calc features into Writer to automatically color tables. All we need is a Copy - Paste from Calc to Writer that pastes borders, background colors and font formats. This way the user would be able to prepare a table in Calc and paste it into Writer as a table (not as an OLE object). Pasting as an OLE object is not a good solution due to bugs 97423, 99953 and 135891. Also, OLE objects are very cumbersome to edit later in a document when compared to actual tables. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 V Stuart Foote changed: What|Removed |Added Keywords||needsDevAdvice Status|REOPENED|NEW CC||jl...@mail.com, ||vmik...@collabora.com, ||vstuart.fo...@utsa.edu --- Comment #7 from V Stuart Foote --- Agree, OLE delivers all facets of a Calc sheet for use in a Writer session (on page, in a Frame or in a Section). But the ask for filter import (via copy/paste) to preserve direct formatting (or Styling) applied to cells of a Calc sheet is a reasonable enhancement. Just not clear how involved the filter work actually is. Needs dev advice. GSOC worthy? Easy hackable? @Miklos, Justin -- opinions? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #6 from Heiko Tietze --- I'm afraid it's not so simple. Anyway, the OLE solution is IMO sufficient. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Sion changed: What|Removed |Added Ever confirmed|0 |1 Status|RESOLVED|REOPENED Resolution|WONTFIX |--- --- Comment #5 from Sion --- They are 2 different programs, correct observation. But the table in Writer could very well have similar behaviors as the tables in Calk, at least in this regard, and besides that, the code is already written in Calc, so it should be very little problems to just copy it over, rename some variables or whatever is needed, and have it function just fine even in Writer. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||6685 Status|UNCONFIRMED |RESOLVED CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #4 from Heiko Tietze --- Writer is not Calc and you cannot have all functionality. But what you can do is to insert the sheet as Calc object with Edit > Paste Special or shift+ctrl+V. The default has changed around 6.4 for bug 116685. So clearly by design and NAB/WF. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 --- Comment #3 from Sion --- Agree, that everything should be paste-able. It would also solve another related problem I have. (Maybe I should open another ticket for this problem?) I have a field with data that is not compatible with the Color Scale function: it is a field with times, it was originally measured in minutes, but I didn't like it, so I translated that field to be more readable, but it is incompatible now: ex: Old time: 230 (minutes) New time: 3h 50m (my "translation") I would like to use the "Old time" field to generate the background colors, (then "lock" the colors?), and then "paste" those colors into the "New time" field, without changing the colors in the new field. I think there is some very roundabout way to do this, I saw something about mapping letters to numbers, so it was possible to sort fields by text, or something like that, so maybe it is possible to map "3h 50m" to the value "230", but as said, it is a VERY roundabout way. Another solution would be to type the "New Time" field as: "3h 50m (230)" and then use a Regular-Expression to extract the "230" part of that text & use that for sorting. Or a 3rd solution, would be to use a different "Source Column" (= "Old Time"), and use that column to generate the colors, and then have a "Destination Column" (= "New Time") where the colors is inserted. Maybe it can be written with a similar syntax as eg. VLOOKUP() or ROUND() or similar functions? Something like: BACKGROUND_COLOR(source_range; target_range) or something like that? (But again, maybe I should open another ticket for this problem?) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Rafael Lima changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Rafael Lima changed: What|Removed |Added Blocks||103100 Keywords||needsUXEval Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103100 [Bug 103100] [META] Writer table bugs -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #2 from Rafael Lima --- Created attachment 180880 --> https://bugs.documentfoundation.org/attachment.cgi?id=180880=edit Screenshots showing the problem Confirmed with Version: 7.3.3.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.3-0ubuntu0.22.04.1 Calc: threaded I would say that all formatting applied in Calc should be pasted into Writer. See in the attached image a Calc table in the left and how it gets pasted into Writer (in the right side). Note that only the bold format gets pasted. Everything else is ignored. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149661] [Feature request] Automatic table-background-coloring ported from Calc to Writer.
https://bugs.documentfoundation.org/show_bug.cgi?id=149661 --- Comment #1 from Sion --- Optionally (or additionally?) It would be useful to be able to (special-)copy the values AND background from Libre Calc & paste it into a Libre Writer Table, so the background colors are preserved too. -- You are receiving this mail because: You are the assignee for the bug.
