Bug 78102 - BASIC: Bad expression result
Summary: BASIC: Bad expression result
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-30 05:08 UTC by Roman Rumíšek
Modified: 2014-07-30 14:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
the file with error expression (13.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-30 05:08 UTC, Roman Rumíšek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Rumíšek 2014-04-30 05:08:14 UTC
Created attachment 98202 [details]
the file with error expression

Simple Expression:

=IF(TRIM(E1)="10006-  38138021/0100";D1;0)

should give the value from column E2, but gives zero.

Operating System: Windows (other)
Version: 4.2.3.3 release
Comment 1 Jacques Guilleron 2014-05-01 14:40:24 UTC
Hello Roman,

Instead of:
=IF(TRIM(E1)="10006-  38138021/0100";D1;0)
type:
=IF(TRIM(E1)="10006- 38138021/0100";D1;0)

Have a nice day,

Jacques
Comment 2 raal 2014-07-30 14:32:54 UTC
Function TRIM removes excess spaces from a text string, also between words. 
https://help.libreoffice.org/Calc/Text_Functions/cs#TRIM
Change expression as Jacques wrote.
I mark this as RESOLVED NOTABUG, feel free to reopen if I'm wrong.