Ask Your Question

CALC: how to copy style from a cell to another one [closed]

asked 2017-01-31 12:05:42 +0100

marcopic gravatar image

I have a table with two columns: one for text and one for numbers (numbers and text are related to one another) I have created a conditional color gradient for column of numbers Now I want to copy the style of that column in the column of text so the cells of each row has the same style.

How can I do?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-23 03:24:30.437444

1 Answer

Sort by » oldest newest most voted

answered 2017-01-31 14:57:41 +0100

karolus gravatar image


There is no way to extend this special kind of CF to Neighbour-Columns, not in GUI nor through the API.

You have to reimplement the whole Functionality by Script bound to Sheet-event →→Content changed

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-01-31 12:05:42 +0100

Seen: 156 times

Last updated: Jan 31 '17