![]() ![]() ![]() (In reply to Jean-Baptiste Faure from comment #46) The government document may say one thing, but nobody that I know follows that any more.Įither way, the format in both Open Office and Excel are aligned to what is in Windows whereas Libre Office is not and there is not an easy way to change it. Or perhaps a step further and look at the South African government's own websites such as South African Revenue Services (CGT).aspx or the South African Reserve Bank at īear in mind that unlike in Germany, the South African government is no longer good at maintaining and enforcing standards, or even adapting to international standards. Perhaps as a reference you could look at some of the main South African finance websites such as or .za and see if you can find a comma separator used anywhere there. Since then and in the 20 years that I have been working in finance, I have never seen a comma used as a decimal separator. I recall when I was in school over 25 years ago that the teachers specifically told us that we were to change from comma to point notation since that is more aligned with international standards and the electronic equipment that we were using. A quick glance at Wikipedia says that both commas and points are used. > correct but others and specifically the ZA government don't, see bug 119613. > It uses an older set of builtin locale data that *you* consider to be > It does not take formatting from the Windows settings. > formatting works correctly since it takes it from my Windows settings. > (In reply to Eike Rathke from comment #40) (In reply to Eike Rathke from comment #42) The year is 2020, and I still have to use Notepad++ to tweak data into a format that is "compatible" with Calc. In case of Calc, I expect the cell formatting to determine how LO interprets the input. If any interpretation/conversion of data is being performed, it should be done so according to a user chosen format. Users can neither change how input is interpreted, or prevent the interpretation in the first place. Once interpreted, the original input is lost. The point of this bug report is that LO interprets numbers a certain way. And in my own country, yyyymmdd is not uncommon either. At my workplace, we get data from countries such as England. ![]() I live in one of the many countries that use dd.mm.yy as the date format. I bet you haven't experienced right-hand traffic either -) Personally, I write the date : 20200630 (yyyymmdd). It is completely common to use this way to write a date where I live.įor me it is obvious that it should be a Libreoffice parameter, since in the same country, different people will use different way to write a date. > that's hard to convince LibreOffice to agree toĬome to Switzerland, and you will see most date written in the form dd/mm/yyyy or dd/yy/mm. Of course it should be changed globally for the locale, but I imagine > Tools Options, to change the default DD/MM/YY > I'll put a £100 GBP bug bounty on a fix for this. > in my whole life here, I've never seen anyone type or write a date as > Every CSV file I load in United Kingdom locale shows "01/07/20" etc the CSV (In reply to Jonny Grant from comment #30) Default locale dependent date acceptance patterns are generated build time, but it is possible to add more or modify them in this edit box. Calc spreadsheet and Writer table cell input needs to match locale dependent date acceptance patterns before it is recognized as a valid date. Specifies the date acceptance patterns for the current locale. You can change the default settings - Tools>Options>Language Settings>Languages> If this checkbox is not activated, the character that your keyboard driver software provides is inserted. If this checkbox is activated, the character shown after "Same as locale setting" is inserted when you press the key on the number pad. Specifies to use the decimal separator key that is set in your system when you press the respective key on the number pad. You can change the default settings - Tools>Options>Language Settings>Languages>Decimal separator key.ĭecimal separator key - Same as locale setting having a "." as decimal separator but having the date in ![]() They should also be customizable independently ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |