Having a problem when righting Persian numbers

Hi.
I’m trying to write a phrase in a cell and everything goes well but when I click enter and it goes out of cell, order of my phrase changes.

additional information:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 8; OS: Linux 6.6; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fa-IR (en_US.UTF-8); UI: en-US
7.6.4-2
Calc: threaded

like:
Screenshot_20240104_202735

to
image

You need to make the cell right to left (RTL). This is different from right/left alignment.
To do so, select the cell, right click and then:
Format Cells > Alignment > Text Direction: Right-to-Left (RTL)
Also, make sure that you are using numbers 0…9 instead of Persian presentation fomrs ۰…۹. You can get Persian numerals by using context mode in:
Tools > Options > Complex Text Layout > General Options > Numerals: Context