https://bugs.freedesktop.org/show_bug.cgi?id=47369
Bug #: 47369
Summary: : Function ABS is unusable in Ukrainian interface
because of prohibited symbol in identifier translation
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 58520
--> https://bugs.freedesktop.org/attachment.cgi?id=58520
This sheet contains only one formula in cell A1: =ABS(0). Any editing in
Ukrainian interface causes #NAME error.
Problem description:
I can not use ABS function with Ukrainian interface in LibO Calc 3.4.3...3.5.1.
It is impossible to insert it to formula because of prohibited character in
it's Ukrainian name.
When I try to open any document with ABS function in LibreOffice Calc with
Ukrainian interface this function name "Абсолютний номер" has prohibited 11-th
symbol - space. Any editing of cell causes #NAME error.
Steps to reproduce:
1. If You have no Ukrainian interface please download and install it from
LibreOffice site:
http://download.documentfoundation.org/libreoffice/stable/3.5.1/deb/x86_64/LibO_3.5.1_Linux_x86-64_langpack-deb_uk.tar.gz
WARNING!!!...! By installing these packages You automatically switch your
language to Ukrainian! If your system have no support You may see empty menus
and dialogues or bird's language! To restore English after reproducing a bug I
successfully try terminal command:
sudo apt-get remove libobasis3.5-uk*.*
2. Download and open attached AbsTest.ods.
3. If your interface is not Ukrainian switch it to Ukrainian: Tools-Options;
select in the left panel Language Setting-Languages and in the right panel User
Interface - Ukrainian.
4. Select a cell A1. The formula is =Абсолютний номер(0)
5. Edit it and add +0 at the end of formula: =Абсолютний номер(0)+0
Current behavior:
#Name
Expected behavior:
0
6. To restore English interface use in terminal:
sudo apt-get remove libobasis3.5-uk*.*
I propose POSSIBLE SOLUTIONS:
1. Change internal identifier to ABS in Ukrainian language packet.
2. Correct internal identifier to remove prohibited space, for example, АБС,
АБСЗНАЧ etc.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:10.0.2) Gecko/20100101
Firefox/10.0.2
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs