Bug 151845 - When typing =ifs statements into CALC, the formula changes when opening in Excel.
Summary: When typing =ifs statements into CALC, the formula changes when opening in Ex...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.1.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-31 17:14 UTC by Criminalintent@comcast.net
Modified: 2023-03-02 09:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Criminalintent@comcast.net 2022-10-31 17:14:56 UTC
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:
.
Comment 1 Buovjaga 2023-03-02 09:53:45 UTC
I reproduced by saving as xlsx and opening in office.com, but I don't know enough about the topic, so I will not change the status.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e32dfaf15563372ffae6e0da53998e20068ebf81
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 1 March 2023