https://bugs.documentfoundation.org/show_bug.cgi?id=151845
Bug ID: 151845
Summary: When typing =ifs statements into CALC, the formula
changes when opening in Excel.
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: criminalint...@comcast.net
Description:
First Issue:
When typing the following =ifs() statement into Calc, Excel changes it. Then,
when I open the same spreadsheet back into Calc and remove the change, the
formula changes a second time into something that resembles an array formula.
Original: =IFS(D149>F149,">",D149<F149,"<",D149=F149,"=")
Excel's Change: =@IFS(D149>F149,">",D149<F149,"<",D149=F149,"=")
If I remove the @ from the function, Calc changes it to:
{=IFS(D149>F149,">",D149<F149,"<",D149=F149,"=")}
On occasion, Excel then removes the function all together and just replaces it
with the best fit text answer. I'm not sure if anything can be done so Excel
won't change the formula when moving the spreadsheet back and forth. Also, if
I accidentally end the original ifs statement with a ,"") Calc office doesn't
catch it as an error (I presume because it hasn't reached that argument).
Second Issue:
Libre office freezes when my macbook wakes up from sleeping. I am given the
spinning pinwheel of death (SPOD) and have no alternative, but to force quit
the application. To Libre Office's credit, the document recovery feature has
never failed to return my documents to their original conditions. I have
addressed the issue by restricting my macbook from sleeping, but it happens
very frequently.
Third Issue (EDITING):
While typing text into a Calc, I frequently find that the cursor will freeze in
place. This does not seem to happen when I am typing in an empty cell, but
only when I am overtyping in a cell that already contains text. If I am not
paying attention while typing, the effect of the stuck cursor is that every
letter already contained in the cell will be deleted back into the cursor. For
example, I am currently studying statistics and building calculators to
manually produce various analyses. This means that I am labeling quite a
number of cells to ensure the data is notated properly. On many occasions I
find myself needing to modify the text in these cells. When I click on the
offending text and begin typing a correction, I frequently find that the cursor
will not move as I type. Instead, it will add letters one at a time that are
each overwritten by the subsequent letter. Simultaneous to that, the remainder
of the existing text disappears one character at a time (as if I am deleting
it). Once I realize that it's happening again, I've found that clicking into
another cell, then clicking back will fix the problem and I can type normally.
I have had this problem on both my previous MacBook Air and my new MacBook Pro
(Both with Silicon chips). Both with clean installations of Libre. I really
hope that was clear because I can't figure out another way to explain it.
Actual Results:
.
Expected Results:
.
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
.
--
You are receiving this mail because:
You are the assignee for the bug.
