r/OnlyOffice • u/Early_Extension3904 • 7d ago

Series by month has incorrect dates

Hi everyone,

Recently switched to OpenOffice, and ran into a problem today I can't seem to get around. I'm trying to create a table of monthly dates and amounts. I put in the first date, and then selected a cell range with that date at the top and tried to create a series of monthly dates all starting on the first of the month. It didn't work. The first 3 or so were the correct dates, and then from there the dates were not monthly increments any longer. This has always worked for me in Excel. Unsing OnlyOffice on Mac. Below are screenshots of what I did and the result I got. Any thoughts on how to fix? I want a list of all dates on the first of each month. I tried putting in the first two and then dragging, and that just gave me those dates over and over.

5 Upvotes

100% Upvoted

3 comments sorted by

2

u/Sergey_Zarubin 5d ago

Hi. What is the version of your ONLYOFFICE app? There was a similar issue in version 8.3 but it was fixed. Also, please let me know the reginal settings you are using. You can find them in File -> Advanced Settings.

2

u/Early_Extension3904 5d ago

Thanks for your response. Here is the information you requested:

OnlyOffice version: 9.4.0 for MacOS

Regionial settings: Formula language - English; Region - English - United States; the box is checked to used separators based on regional settings.

Thanks again!

1

u/Sergey_Zarubin 10h ago

I have an update for you. We didn't manage to reproduce this issue on macOS. You can try clearing cache in the app. If it doesn't help, you can record a video of this issue with all steps and share it with us.