| Summary: | EDITING: Cannot place/use MOD(A1,... | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | selesium |
| Component: | Spreadsheet | Assignee: | 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: | ||
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.
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