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.92k stars 1.1k forks source link

Use dot as decimal separator for spreedsheet #675

Open wouterVE opened 5 years ago

wouterVE commented 5 years ago

Do you want to request a feature

What is the current behavior? We're using a Azerty keyboard (Belgian point). When using the dot (.) on the numeric keypad, spreadsheet shows a dot. When entering decimal numbers using the dot, spreadsheet don't recognize this as a number but as text instead.

What is the expected behavior? An option (probably build in the regional settings) to change this behavior so that entering a number using the numeric dot (.) shows a comma (,).

Example: Entering 1.23 shows as 1,23

Explanation: In our region we use , as decimal separator and . as thousand separator

Rita-Bubnova commented 5 years ago

Hello, @wouterVE. What OS do you use as client? What localization do you use in Spreadsheet Editor (File > Advanced Settings)?

wouterVE commented 5 years ago

Hi @Rita-Bubnova I'm using windows 10 1803 with the following regional settings: 2019-10-30_08h30_56 Keyboard layout is Azerty Belgian Point as mentioned earlier.

In spreadsheet I'm using regional settings = Nederlands 2019-10-30_08h32_15

Rita-Bubnova commented 5 years ago

Thank you. The problem you described far greater that it can be seemed at first. I created an issue 43413 to discuss it with our team.

wouterVE commented 5 years ago

You're welcome. Thanks for creating an enhancement for this. If any help needed, please feel free to ask. kr wouter

Danteba commented 4 years ago

I'm having the same problem. This is the biggest obstacle to being able to use the onlyoffice in my language (spanish). Is a BIG problem for us.

ShockwaveNN commented 3 years ago

@stevearbour I think this may help, but please if got any more question - create new separate issue

Thatoo commented 3 years ago

I face the same problemwith an azerty keyboard both on onlyoffice dsktop and onlyoffice on the cloud... It is a major issue actually.

xtreemrage commented 2 years ago

I have the same issue, I use my numeric keypad a lot with spreadsheet. When I use the dot key, it does not convert it to a comma like libreoffice. When Will this be implemented in onlyoffice?

@Rita-Bubnova Do you have some more information regarding this issues? This is the only reason I still use libreoffice.

ShockwaveNN commented 2 years ago

@xtreemrage Sorry, currently there is no news

If you really need this implemented ASAP - it's better to contact sales@onlyoffice.com