Bug 161787 - On opening Excel spreadsheet with function and intersection character (space " " for Excel), change to intersection character (exclamation mark "!" for Calc)
Summary: On opening Excel spreadsheet with function and intersection character (space ...
Status: RESOLVED DUPLICATE of bug 160371
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-26 03:13 UTC by Óvári
Modified: 2024-06-26 03:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Please see sheet2 cells C16 and D16 showing Err:509 (17.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-06-26 03:20 UTC, Óvári 		Details
Excel Sheet2 cells C16 and D16 (113.60 KB, image/png)
2024-06-26 03:21 UTC, Óvári 		Details
Calc Sheet2 Cells C16 and D16 with Err:509 (137.04 KB, image/png)
2024-06-26 03:22 UTC, Óvári 		Details
Fixed (294.37 KB, image/png)
2024-06-26 03:42 UTC, Óvári 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Óvári 2024-06-26 03:13:47 UTC 
Description:
On opening Excel spreadsheet with function and intersection character (space " " for Excel) should change intersection character (exclamation mark "!" for Calc).



Steps to Reproduce:
1. Excel spreadsheet, Sheet2:
(a) Cell C16:
=INDIRECT(B16) INDIRECT(C15)
(b) Cell D16:
=INDIRECT(B16) INDIRECT(C15)>5000

Actual Results:
(a)
Displayed: {=INDIRECT(B16) INDIRECT(C15)}
Value: Err:509

(b)
Displayed: {=INDIRECT(B16) INDIRECT(C15)>5000}
Value: Err:509

Expected Results:
Currently:

(a)
Displayed: {=INDIRECT(B16)!INDIRECT(C15)}
Value: 7,131

(b)
Displayed: {=INDIRECT(B16)!INDIRECT(C15)>5000}
Value: TRUE

When Calc supports Dynamic Arrays:

(a)
Displayed: =INDIRECT(B16)!INDIRECT(C15)
Value: 7,131

(b)
Displayed: =INDIRECT(B16)!INDIRECT(C15)>5000
Value: TRUE


Reproducible: Always


User Profile Reset: No

Additional Info:
Attachments to follow.

Thank you
Comment 1 Óvári 2024-06-26 03:20:03 UTC 
Created attachment 194959 [details]
Please see sheet2 cells C16 and D16 showing Err:509

https://help.libreoffice.org/latest/en-US/text/scalc/05/02140000.html

Error Code: 509
Message: Missing operator
Explanation: Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.

Perhaps need to check saving in Excel, then Calc, then Excel?

Thank you
Comment 2 Óvári 2024-06-26 03:21:29 UTC 
Created attachment 194960 [details]
Excel Sheet2 cells C16 and D16
Comment 3 Óvári 2024-06-26 03:22:31 UTC 
Created attachment 194961 [details]
Calc Sheet2 Cells C16 and D16 with Err:509
Comment 4 Óvári 2024-06-26 03:26:32 UTC 
(In reply to ady from bug 161470 comment 9)
> The intersect operator (a space character in Excel, the exclamation "!"
> character in Calc) is not new, and it is already supported in Calc.
Thank you for your comment. Created new issue.
Comment 5 ady 2024-06-26 03:32:19 UTC 
Already solved for upcoming LO 24.2.5 and LO 25.2 alpha in tdf#160371.

*** This bug has been marked as a duplicate of bug 160371 ***
Comment 6 Óvári 2024-06-26 03:42:30 UTC 
Created attachment 194962 [details]
Fixed

(In reply to ady from comment #5)
> Already solved for upcoming LO 24.2.5 and LO 25.2 alpha in tdf#160371.
> 
> *** This bug has been marked as a duplicate of bug 160371 ***

Thank you

Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community
Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded