The time cell saved from libreoffice can not show correctly in wps

type 8:30 in libreoffice calc and save as xlsx. It shows in libreoffice ↓


then opened in wps ↓

even I change the format to time

How do I do?

File a bug to WPS?

Please upload the problematic file. Let’s see how the file looks in MS Excel.

time.xlsx (5.1 KB)
It must be a normal xlsx file create by libreoffice

And in Excel, cell A1 displays a number.
Reason: when saving the file, Calc was set to show formulas in cells:
Menu / View / Show Formula.
Open the file, turn off formula display and resave the file.

2 Likes

It works, thank you!