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
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.