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.8k stars 1.08k forks source link

Calc is changing column with and date format in saved and reopend spreadsheet #2026

Open Codeleiche opened 1 year ago

Codeleiche commented 1 year ago

This issue is unique.

Operating System

Linux (DEB package)

Version information

72.1.36

Expected Behavior

When saving the spreadsheet with specific format (column with, date format) after reopening the sheet should be the same. This happs while saving as ods.

Actual Behavior

The sheet changes after reopening, columns are getting smaller and date format gets changed (from 03.08 a 2022,August,03).

Reproduction Steps

Additional information

Video of the behavior:

onlyoffice_date_problem.webm

My regiononal settings are:

Formula language: English Region: Germany (Deutsch) Dictionary language: Spanisch (Español)

Spreadsheet was impoted from libreoffice

VladimirProkofiev52 commented 1 year ago

Hello!, @Codeleiche We are aware of this issue, Bug 59931 in our private issue tracker. Problem can be reproduced in DocumentServer. Thank you for report.

Codeleiche commented 1 year ago

Thank you for working on it! is it something with more or less priority? I just copied all sheets to a new document and the problem got fixed by itself.