search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.9k stars 1.1k forks source link

Spreadsheet: number format changes unintended #3003

Open Nzara opened 2 days ago

Nzara commented 2 days ago

This issue is unique.

Operating System of DocumentServer

Docker

Version information

8.2.1.38

Expected Behavior

Number format of a cell sticks to definition

Actual Behavior

Number format of a cell changes unintentionally to date

Reproduction Steps

Example 1

  1. In spreadsheet app

  2. Select a cell

  3. Set Number Format to fraction

  4. Enter data '.5' -> '1/2'

  5. Enter data '1/2' -> '1-Feb' / Number Format now date

  6. Enter data '.5' -> '0-Jan' / Number Format still date

    Example 2

  7. In profile change language to Deutsch (Deutschland)

  8. In the spreadsheet app:

  9. Set Number format to Number (Zahlenformat: Zahl)

  10. Enter data '0,5' -> '0,50' / formatted as number

  11. Enter data '0.5' -> '0,5' / formatted as text

  12. Enter data '1.5' -> '1-Mai' / formatted as date

  13. Enter data '0.5' -> '1-Jan' / formatted as date

Additional information

Operating System of DocumentServer unknown, entry forced by mandatory field

Dmitry-Kov commented 9 hours ago

Hi @Nzara,

I can confirm - this is bug, issue #69449. When some fixes will be done we'll text you here in this issue. Thank you for the report!