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

Reply via email to