Do you want to: Suggest a feature / Report a bug / Ask a how-to question
OS version: Nobara Linux 42 (Fedora42)
App version: 9.1.0
Downloaded from: flatpak
Additional information:
In spreadsheets, when I open a worksheet with dates as the header in a table, and I want to add a value, it completely changes the current row, modifying the values as if a DATEVALUE() function had just been executed.
This is not what is intended, since the default format I provided is, therefore, that the added new value should take the following format:
Format: Date
Regional settings: French - France
Format: 15/04/2006
Also, if I change the current cell to a “Date” format with the same parameters as above before entering the value, it makes no difference.
*I haven’t tried it on an online version of OnlyOffice.
*This bug does not appear to be reproducible on LO, since their spreadsheet does not allow adding a new value to a table like on Excel or OO.
Can you provide a screenshot of such table? It’d be even better to have a sample file for analysis.
In general, do I understand that you are referring to tables like the ones created with “Format as table template” button and that have dates in the “header” row?
However, as a new member, I’m unable to upload files (videos, spreadsheets, or screenshots).
But to reproduce the issue, you can create a table. Then, use dates as headers. By adding a date to the cell next to a header to add a column to the table, the column’s format changes completely, and this also changes all the headers.
I have a sample file or video if needed (but I can’t upload it here because I’m a new member).