[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 Eike Rathke changed: What|Removed |Added Version|4.3.0.4 release |Inherited From OOo Status|NEEDINFO|ASSIGNED Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Keywords|filter:xlsx | --- Comment #7 from Eike Rathke --- Thanks Laurent! As usual for Excel, I assume the conversion from string to numeric to have the awkward behaviour of being locale dependent, thus indeterminate. Taking. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536
Laurent BP changed:
What|Removed |Added
CC||jumbo4...@yahoo.fr
--- Comment #6 from Laurent BP ---
Tests with Excel 2010
(In reply to Eike Rathke from comment #5)
> For example, output for these is ...?
> =TEXT(0;"")
returns empty string
> =TEXT(12.3456;"")
returns empty string
> =TEXT(1E23;"")
returns empty string
> =TEXT("lala";"")
returns "lala"
if argument is numeric (date, time, percent, scientific...) => empty string
if argument is text => string with same text
/!\ if text can be converted as a value, empty string is returned:
=TEXT( "5:3" ; "" ) or =TEXT( "5e3" ; "" )
returns empty string
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536
Eike Rathke changed:
What|Removed |Added
Status|NEW |NEEDINFO
--- Comment #5 from Eike Rathke ---
An empty format string makes no sense as it would return an empty string for
any input value. If that is actually desired the proper format string would be
";;;" (i.e. all empty sub formats).
However, if Excel allows such in TEXT() we could as well. ODFF puts no
constraints on TextFormatCode. BUT, what does Excel actually do there?
Apparently it does not return an empty string? Does it return a formatted
string according to the 'General' format? Something else? Can someone please
check?
For example, output for these is ...?
=TEXT(0;"")
=TEXT(12.3456;"")
=TEXT(1E23;"")
=TEXT("lala";"")
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #4 from m.a.riosv --- At least in calc TEXT() it's not need for the formula. Not sure empty string it's a valid option for TEXT() function. https://docs.oasis-open.org/office/OpenDocument/v1.3/csprd02/part4-formula/OpenDocument-v1.3-csprd02-part4-formula.pdf 6.20.23 TEXT Summary: Return the value converted to a text. Syntax: TEXT( ScalarX ; TextFormatCode ) Returns: TextConstraints: The FormatCode is a sequence of characters with an implementation-defined meaning. Semantics: Converts the value X to a Text according to the rules of a number format code passed as FormatCode and returns it. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #3 from Xisco Faulí --- Reproduced in Version: 7.0.0.0.alpha0+ Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 --- Comment #2 from NISZ LibreOffice Team --- Created attachment 158938 --> https://bugs.documentfoundation.org/attachment.cgi?id=158938=edit The problematic formula structure in the Formula Wizard -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=131536 --- Comment #1 from NISZ LibreOffice Team --- Created attachment 158937 --> https://bugs.documentfoundation.org/attachment.cgi?id=158937=edit Screenshot of the original document side by side in Excel and Calc -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
