Bug 81778 - EDITING: Cannot place/use MOD(A1,...
Summary: EDITING: Cannot place/use MOD(A1,...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.5.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-26 12:12 UTC by selesium
Modified: 2014-07-26 17:11 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

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.