Behavior of shape, when switching spreadsheet to right-to-left

Hi all,

this is a question for those, who use Calc with RTL (right-to-left) sheets.

If someone has entered a shape into a left-to-right sheet, and then decides to switch to right-to-left (that is in menu Sheet), should the geometry of the shape be mirrored?
Example: I insert an arrow, which points to right in a left-to-right sheet. Then I switch the sheet to right-to-left. Should the arrow now point to left?

Currently the behavior depends on whether the shape is anchored to page or to cell. If the arrow is anchored to cell, it keeps it geometry and still points right. If the arrow is anchored to page, then it will point left after switching to RTL.

I consider it a bug, that the behavior depends on anchor, and would fix it. But what is the desired behavior?

Kind regards
Regina

Sorry, wrong list. Should have gone to discuss@documentfoundation.org

Kind regards
Regina