[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #15 from Paolo Cavallini  ---
I confirm that the issue has disappeared in LO5

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #14 from Paolo Cavallini  ---
Further note: I noticed that LO inserts extra spaces in the formula every time
I open it, like:
=2   +   2
Could this depend from some parsing lib?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #5 from Paolo Cavallini  ---
Please note that the same issue remains when removing user config
(~/.config/libreoffice), so it does not seem a local issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||r...@post.cz
 Resolution|--- |NOTABUG

--- Comment #3 from raal  ---
Set format of the cell to Numeric or All and recalculate the sheet
(ctrl+shift+F9). Cell format is boolean. Closing as notabug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #7 from Paolo Cavallini  ---
Yes

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Paolo Cavallini  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
 Ever confirmed|0   |1

--- Comment #4 from Paolo Cavallini  ---
Done, the result is 1, even if not formatted as boolean.
The issue is not formatting, but the type of calculation, which tests the
logical validity of the expression, not its numeric result.
Not resolved here.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #6 from raal  ---
(In reply to Paolo Cavallini from comment #4)
> Done, the result is 1, even if not formatted as boolean.
> The issue is not formatting, but the type of calculation, which tests the
> logical validity of the expression, not its numeric result.
> Not resolved here.

Did you recalculate the sheet (ctrl+shift+F9) ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Joel Madero  changed:

   What|Removed |Added

 Status|REOPENED|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #8 from Joel Madero  ---
Can't confirm.

Ubuntu 15.04 x64
LibreOffice 5.0.0.5

A hard recalculate resolves the issue. If one more QA member fails to confirm
then this is environment specific and thus NOTOURBUG. I'll try to find another
person to test. I would suggest asking ask.libreoffice.org as well.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl

--- Comment #9 from Cor Nouws  ---
(In reply to raal from comment #3)
> Set format of the cell to Numeric or All and recalculate the sheet
> (ctrl+shift+F9). Cell format is boolean. Closing as notabug.

I confirm this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #12 from Joel Madero  ---
I just tested with 4.4.5.2 on Ubuntu 15.04 and it works fine (same as before,
set to number, hard recalc, everything is fine)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #13 from Paolo Cavallini  ---
So I'm lost: retried once more, I confirm that here it does not work. It seems
a local issue, but I have no clue about what to check.
Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Joel Madero  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #10 from Joel Madero  ---
With a third QA member not being able to confirm the issue (hard recalculate
resolves the problem after setting the format to number) I am closing this as
NOTABUG.

Please do the following:
1. Test with 5.0.0.5
2. Fresh profile;

If those fail please reach out to user mailing list or ask site. Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #11 from Paolo Cavallini  ---
Thanks for this. Unfortunately I cannot test with LO5, as it is blocked by GCC5
transition in Debian sid.
I'm positive is an issue with my version.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Joel Madero  changed:

   What|Removed |Added

   Hardware|x86-64 (AMD64)  |All
   Severity|major   |normal

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Joel Madero  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||jmadero@gmail.com
 Ever confirmed|0   |1

--- Comment #1 from Joel Madero  ---
Please attach a sample document. Setting to NEEDINFO. Once you attach a simple
document please set to UNCONFIRMED.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

Joel Madero  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93841] Logical results (boolean) instead of numeric ones in calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93841

--- Comment #2 from Paolo Cavallini  ---
Created attachment 118324
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118324=edit
file required

Please find it herewith attached.
I do not think it matters much, however: the files which worked in previous
versions stopped working now.
Thanks for looking into this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs