Issue 119572 - [From Symphony]Formula =True in xlsx display as 1 in Aoo
Summary: [From Symphony]Formula =True in xlsx display as 1 in Aoo
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2012-05-30 06:43 UTC by zongdj
Modified: 2024-01-21 11:33 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Attachments
formula sample (9.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-30 06:43 UTC, zongdj 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description zongdj 2012-05-30 06:43:00 UTC 
Created attachment 77791 [details]
formula sample

Build:
Aoo3.4

Steps:
1.Open the attached sample file in Aoo
2.Check the cell C6

Bug:
It display as 1, it should display as true.
Comment 1 Du Jing 2012-07-17 08:51:09 UTC 
confirmed,change its status
Comment 2 damjan 2024-01-18 18:32:31 UTC 
It's not too clear what you mean here.

If you type "=TRUE" into a cell, then yes you get a "1".

You can also type "=TRUE()" to get "TRUE", or format the "=TRUE" as "Boolean Value" so that it shows as "TRUE" instead of "1".

Is this bug about formatting "=TRUE" as a "Boolean Value" by default?
Comment 3 Czesław Wolański 2024-01-20 09:09:11 UTC 
(In reply to damjan from comment #2)
> 
> Is this bug about formatting "=TRUE" as a "Boolean Value" by default?

Waiting for a response by OP, just my two pennies' worth – Possibly.

In Excel, typying "=TRUE" into a cell, displays "TRUE",
as with "=TRUE()". The corresponding internal entries are, respectively,
<f>TRUE</f> and <f>TRUE()</f> (cell type: Boolean, value: 1)

File attached to this report by OP: "Book1.xlsx"
Opened in OpenOffice: cell C6 shows "1" ( cell formula "=1" ),
whereas one sees in:

- Google Sheets: "TRUE" ( cell formula "=TRUE" ) 
- LibreOffice: "TRUE" ( cell formula "=TRUE()" )
Comment 4 damjan 2024-01-20 10:54:29 UTC 
(In reply to Czesław Wolański from comment #3)
> whereas one sees in:
> 
> - LibreOffice: "TRUE" ( cell formula "=TRUE()" )

That must be something LibreOffice fixed recently, because on version 6.4.7.2 it very much shows a "1" instead of "TRUE".
Comment 5 Czesław Wolański 2024-01-21 11:33:04 UTC 
Yes, I noticed this difference too.

FWIW:

                      Formula     Displays
                      -------     --------

Excel file           =TRUE        TRUE     

Import to LO:

6.4.7.2              =1           1
7.0.0.1 - 7.3.1.3    =TRUE()      1           
7.3.2.1 -            =TRUE()      TRUE