Date Format - Doesn't work when selected

DocSpace Cloud
1

Ask a how-to question
Hi, I am using cloud based Only Office and on the excel I am trying to format cells so they result in a date format when the content is entered and if the wrong information is selected (i.e text) then it shows an error message. I have selected number format and then the date I want but after I select it, I can still enter anything I want in the cell. It has occasionally worked when I have done it however after doing it once, if I delete and try to re-enter the information it will then allow me to enter any format I want…can someone advise what I am doing wrong :slight_smile:

I am using Firefox browser

2

Hello，
Please provide a screen recording showing step-by-step issue reproduction

3

I think my issue is somewhat similar and I can provide the screen grab of the same.

Steps:

  1. Add date into a column in the format MM/DD/YY
  2. Now copy another date in a different format and paste it right under the first one.
  3. Try adding the different combinations MM/DD/YYYY, DD-MM-YYYY etc
  4. Select all the dates and format them to a desired date.

Expected Result : The dates need to be formatted to the selected formatting
Actual Result : The dates remain unchanged

Additionally when I double click the cell for editing and then click away it formats correctly.

Edit: Unfortunately as a new user I am unable to upload attachments.

4

@joe1
Now you should be able to upload files. Please provide the screen recording of the issue reproduction for reference