You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/08/21 09:58:05 UTC
[Issue 101573] Open xlsx with multiline formula in a cell
https://bz.apache.org/ooo/show_bug.cgi?id=101573
d.jankovics+bz.apache.org@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |d.jankovics+bz.apache.org@g
| |mail.com
--- Comment #4 from d.jankovics+bz.apache.org@gmail.com ---
to reproduce:
- open a new sheet in MS Excel
- fill cell A1 with: 1
- fill cell B1 with: 2
- fill cell C1 with: 3
- add formula to D1: =A1+B1 (here use Alt+Enter to add a new line within the
cell) +C1
- Excel calculates 6 to cell D1
- save the file, open it with OO Calc
- Calc calculates 3 to cell D1 (because processing only the first line of the
multiline formula)
i use Excel 2013 (15.0.4953.1000 MSO 64-bit) and OO 4.1.3, Rev. 1761381 on
windows 7.
--
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.