Calc: rotate text in a cell, based on a value in a different?

Greetings,

Is it possible to rotate text in a cell, based on a specified angle in another cell?

I have in mind placing an arrow (like Dingbats U+2799: ➙) in cell A1, and an angle in cell B1.

For example, U+2799 points to the right (“east”).

If I put 0 in B1, I’d like the arrow to point down (“south”),

Put 90 in B1, have the arrow point left (“west”).

Put 225 in B1, have the arrow point “NE”.

And, basically point in any direction, from 0 to 360, starting with 0 as south, and proceding clockwise from there, based on the angle in degrees specified as a value in cell B1.

Apparently, excel can do this, using visual basic, according to this thread:

rotate text using rotation value

Is this possible in LO calc?

Yes, you can write/use macros in LibreOffice…
.
But for less values like 0, 45, 90, 135, 180 I would use a “regular” IF or conditional formatting.

2 Likes