How to change the order of text editing in cells in calc

Somehow I ended up with a template for Hebrew, with columns going from right to left, and cell editing going from right to left. I managed to change the template so that the columns go from left to right, but still, when entering text in a cell, what looks like a paragraph mark appears, and editing can only happen right to left. How in the world can I change that, and then have it be part of the default template?