https://bugs.documentfoundation.org/show_bug.cgi?id=99789
--- Comment #5 from Ahamed <[email protected]> ---
Hi all,
This problem is posing a going back to MS excel in my office. After an
herculian effort only I could change the mood of the staff in my office towards
Libreoffice.
We need a lot of calculations for the day2day office work. At times, the cell
shows only the equation. It does not get updated. If we double click the
precedent cells are high lighted with colour bands. It behaves as a text cell.
There is no ' character before the = sign.
I can repeat this like this,
0. let in the cell A3 there is an equation "=A1+A2" (of course no double
quotes) gives the correct result by adding A1 and A2
1.put a ' character in the eqn. before = sign
2.convert the cell A3 to text using format cells
3.then remove the ' character ... it shows instead of the function value, the
function as a text.
4.trying to convert back from text to number format does not yield the result..
it shows the eqn. rather than the value
Pl. let me know what is the workaround for this. I am using Linux and 4.3.3.2
under debian. In my office MS Winodws 8.0 with LibreOffice 5.2 also have the
same problem.
Rasheed
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
