Date Picker Plugin - Do not override cell formatting

[abbasou]

Date Picker plugin overrides cell format with its own default format when inserting date. Plugin should insert text only, not changing any format.

[Dmitry-Kov]

Hi @abbasou,

Thanks for the detailed report and the screenshot!

We looked into this together with the team, and it turns out to be expected behavior rather than a bug. The Date Picker plugin inserts an actual date value into the cell — and a date value naturally comes with a date number format, so the cell ends up formatted as a date. That's standard spreadsheet behavior for dates.

When you type a date manually, the cell may stay as text, which is why the two cases look different.

The plugin doesn't currently have an "insert as plain text, keep my format" mode. If preserving your own cell format matters for your workflow, let us know the exact scenario and we'll be happy to consider it as a feature request.

I'll close this as working-as-intended for now, but feel free to reopen or comment if you run into a specific problem. Thanks again!

[abbasou]

@Dmitry-Kov,
This behavior seems unnecessarily opinionated; that is, it imposes it's own opinion that all dates should be Arial, size 10, right aligned, etc. regardless of user preference.

This is not standard behavior throughout OnlyOffice Desktop Editors. If I format an empty cell with font, size, fill, text color, etc. and then type in a date, OnlyOffice will recognize the input as a date and treat it as such. I can then choose different date formats, such as long date, short date, etc. and the style will not change.

But if I then use the plugin to insert a different date, all formatting is cleared and reverted to the plugin's "default" Arial, size 10, black, no fill, etc. To the user, this behavior is not "expected". Please reconsider.

[Dmitry-Kov]

@abbasou,

Good news — and thanks again for pushing on this.

You were right. The team confirmed the plugin shouldn't be overriding the cell's style, and they've implemented a fix: the Date Picker now preserves your existing formatting (font, size, color, fill, alignment) and only inserts the date value. It's been verified internally — styles stay in the cells, no console errors.

The change is currently on a separate branch and hasn't been released yet. I'll update this issue once it's merged into a public build, so you'll know when it lands.

The team is also considering adding an option to switch between the two behaviors (apply the plugin's default style vs. keep your custom style), but the core fix — no longer overriding your formatting — is already done.

Thanks again for the clear report and the follow-up!

[abbasou]

Just checking back in to see if there's been any movement on this in the last 2 months?

[Dmitry-Kov]

Hello @abbasou,

We’ve updated the Date Picker plugin and added the Keep cell formatting option. Please update the plugin and check the result. Let us know if it works as expected in your scenario.