Bug 47369

Summary: : Function ABS is unusable in Ukrainian interface because of prohibited symbol in identifier translation
Product: LibreOffice Reporter: Viktor Mileikovskyi <v_mil>
Component: CalcAssignee: Andras Timar <timar74>
Status: RESOLVED FIXED    
Severity: normal CC: markus.mohrhard, timar74, timar, v_mil
Priority: medium    
Version: 3.5.1 release   
Hardware: Other   
OS: All   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: This sheet contains only one formula in cell A1: =ABS(0). Any editing in Ukrainian interface causes #NAME error.

Description Viktor Mileikovskyi 2012-03-15 10:35:42 UTC
Created attachment 58520 [details]
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
Comment 1 Viktor Mileikovskyi 2012-03-15 10:47:42 UTC
OOPS! Use 3-rd step (switching interface) before opening a file. Simply open LibO Calc and switch UI language. After switching interface it is necessary to close LibO Calc.

Russian interface works normally. It uses ABS function without any translation.
Comment 2 Andras Timar 2012-03-15 14:50:55 UTC
I fixed it in Pootle, it will be in 3.5.2.