Using a standard western setup, in regards to .fods format fo:text-align="right" is not right-aligned, but fo:text-align="end" is.
This can be reproduced as follows:
1. Open a blank calc sheet in a std western setup
2. Enter some distinctive text in the first cell eg aaa
3. Save as a .fods then close it
4. Open the resulting file in notepad and search for your distinctive text then note the style id then jump to its style def using the find feature.
You'll see that right-aligning in Calc has been saved as fo:text-align="end". This will open correctly but (with it not open in Calc) if you now in notepad edit "end" to be "right" then save and open it in Calc, it will be left aligned. The spec does quite reasonably give "right" as a valid value.
Cheers, David