Bug 81778

Summary: EDITING: Cannot place/use MOD(A1,...
Product: LibreOffice Reporter: selesium
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO --- QA Contact:
Severity: normal    
Priority: medium CC: serval2412
Version: 4.2.5.2 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard: BSA
i915 platform: i915 features:

Description selesium 2014-07-26 12:12:03 UTC
Problem description: 
I try to use the formula to do modulus on the cell A1, but LibreOffice replaces A1 by A10. This happens every time, in every cell.
Steps to reproduce:
1. Open Spreadsheet
2. Edit a cell
3. Type '=MOD(A1,2)' (or another number than 2)
4. confirm edit in any way

Current behavior:
The content of the cell is replaced by '=MOD(A10,2)'. Yielding 'Err:509' probably because A10 is an empty cell.

Expected behavior:
The cell keeps its content and calculates the modulus of A1.
Note that for other cells than A1, spreadsheet behaves as it should.
              
Operating System: Windows 8
Version: 4.2.5.2 release
Comment 1 Julien Nabet 2014-07-26 17:11:05 UTC
What UI language do you use?
It works for me with a semicolon instead of a colon,
=MOD(A1;2)
(in Tools/options/LODev/Formula, you must use ";" as separator for function, which seems to be the default)

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.