Set Home| Set Favorite|

WPS Office Forum

 Forgot password?
 Register
Search
Author: nrajevac

Regional settings in Windows

[ Promote this link! ]
Post time: 2013-06-04 01:22:46
| Show all posts
Well, Office 2013 is out. Problem still there....
Post time: 2013-07-16 12:39:57
| Show all posts
Hey, any news for fix of this giant problem?
Post time: 2013-07-17 05:00:56
| Show all posts
There are two guide about Change Number Formatting with Decimal Places and Thousands Separators, and How to Set Current Date Format?
Maybe it is useful. http://help.ksosoft.com/spreadsheets/134-change-number-formatting-with-decimal-places-and-thousands-separators.html
http://help.ksosoft.com/spreadsheets/133-how-to-set-current-date-format.html
Post time: 2013-07-22 03:11:54
| Show all posts
Tools that update decimal formating, sometime still not stable. Sometimes it change into point by it self. How to solve this problem? Thanks
 Author| Post time: 2013-08-05 08:33:52
| Show all posts
OK, this is kind of a hack. It does allow you to use "," as decimal symbol, but it still does not inherit Windows Regional Settings.
I also need to be able to input date in format "d/m/yy", but when I do so, Spreadsheets switches between "d" and "m": if I enter "2/8/13" (2nd of August), it displays it as "8/2/13" (8th of February).
So, if I want dates to be displayed correctly in my language (day-month-year), I need to enter them incorrectly (month-day-year).
Am I missing some setting in Spreadsheet options maybe?
Post time: 2013-08-14 22:37:13
| Show all posts

Change Number formatting

Rain replied at 2013-07-17 05:00
There are two guide about Change Number Formatting with Decimal Places and Thousands Separators, and ...
There is decimal separator in Spreadsheet settings. But that's just decimal separator. No thousand separator, $ is used for currency by default, dates only western etc. Everything should be used from regional settings, including currency symbol, unless another symbol is pre set in cell in spreadsheet file.  And Kingsoft Office should not change anything in system settings.

Also when pressing decimal separator button on numreical keypad Spreadsheet should always enter local decimal separator, not just dot or comma regarding  of selected keyboard layout.



Post time: 2013-09-02 09:27:08
| Show all posts
hi, regs,
the Link is ok now. try it again.
Post time: 2013-10-02 14:58:27
| Show all posts
Edited by fastreport at 2013-10-02 15:03

I must add myself to the list.
I too am experiencing this issue, the software changes my regional settings for decimal from "," to "." and for thousands from "." to ",", effectively swapping them, also the date format becames different too.
Problem is it should get those as set by windows; so going back to any other program has those changed, which is bad. I'm sad to see it's an old lasting issue, about a year.
Your product compatibility is excellent, the interface is nice too, but it's not like someone would change the regional setting after any usage, and for what I know I don't see the need of having an office suite changing the regional setting upon startup.
Post time: 2014-05-19 20:03:52
| Show all posts
I've got the same problem. Every time I open Spreadsheets, the regional settings of my system are changed (adds comma every third letter - FROM "123 456 789" to "123,456,789". I'm on a Norwegian Bokmål (nb) system, Windows 8.1. I've got the latest version of the Office suite.

This is a dealbreaker for me, because other operation critical software relies on the systems regional settings, which are changed every time I open a spreadsheet. (I haven't tried the word processor yet).

Why is this happening, and when can we expect it to get fixed? Other than this, the suite seems great, from what I've seen so far.
Post time: 2014-06-13 17:16:01
| Show all posts
Recent version doesn't fix this de facto critical bug as well.

http://yadi.sk/d/X56JhaN8QSJ4v
http://yadi.sk/d/7yMFB_UUQSJkS
You have to log in before you can reply Login | Register

Points Rules

Dark room|Mobile|Archiver|WPS Office   

2019-07-20 01:26 GMT+8 , !processed_in! 0.196302 !seconds!, 15 !queries! .

Powered by Discuz! X3.2

Release 20151208, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 469, © 2009-2019 codersclub.org

!fastreply! To Top !return_list!