https://bugs.documentfoundation.org/show_bug.cgi?id=149661
--- Comment #3 from Sion <sebbes...@gmail.com> --- 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.
