[Libreoffice-bugs] [Bug 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

BogdanB  changed:

   What|Removed |Added

 Blocks||108252
 CC||buzea.bog...@libreoffice.or
   ||g


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108252
[Bug 108252] [META] Cell-related bugs and enhancements (including formatting)
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Michael Stahl (allotropia)  changed:

   What|Removed |Added

   Keywords|needsDevAdvice  |
 Whiteboard||odf
 Status|REOPENED|NEW
 CC||er...@redhat.com

--- Comment #8 from Michael Stahl (allotropia)  ---
i think it's a bug in LO.

the space before the end of the element must be written as text:s because:

5) Leading “ “ (U+0020, SPACE) characters at the start of the resulting text
and trailing SPACE characters at the end of the resulting text are removed.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 CC||michael.st...@cib.de

--- Comment #7 from Regina Henschel  ---
@Micheal: Can you please look at it? Problem is step 5) in the algorithm in
section 6.1.2 (ODF 1.3 part3) compared to the description of  in
section 6.1.3 (ODF 1.3 part3).

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

--- Comment #6 from Andrew Church  ---
(I belatedly realize I filed the bug over _trailing_ rather than _leading_
spaces, but the same logic applies to trailing spaces.)

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Andrew Church  changed:

   What|Removed |Added

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

--- Comment #5 from Andrew Church  ---
> The description of  has, "This element shall be used to represent the 
> second and all following “ “ (U+0020, SPACE) characters in a sequence of “ “ 
> (U+0020, SPACE) characters.

As an initial issue, "shall be used to represent the second" does not imply
"shall not be used to represent the first", so I don't think this is enough to
resolve the question.

Looking at the ODF 1.3 specification
(https://www.oasis-open.org/committees/download.php/67566/OpenDocument-v1.3-part3-schema.odt):

"""
6.1.2. White Space Characters

Consumers shall collapse white space that occur in
 * a  or  element [...]

Collapsing white space characters is defined by the following algorithm:
[...]
5) Leading " " (U+0020, SPACE) characters at the start of the resulting text
[...] are removed.
"""

I hope I haven't omitted any relevant points by accident, but by my reading of
this algorithm, " space" should have the initial space removed
and be parsed as the text "space" (5 characters), suggesting that Excel has the
right of it and  is required to correctly encode the leading space.

Apologies for not doing the legwork on this in the first place, but reopening.

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

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

--- Comment #4 from Regina Henschel  ---
The description of  has, "This element shall be used to represent the
second and all following “ “ (U+0020, SPACE) characters in a sequence of “ “
(U+0020, SPACE) characters.

In Version: 7.0.0.2 (x64)
Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL
I see the  element, if there are two spaces.

I therefore think, that it is correct, that for one space no  element
is used.

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

   See Also||https://issues.oasis-open.o
   ||rg/browse/OFFICE-3828,
   ||https://issues.oasis-open.o
   ||rg/browse/OFFICE-3706

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

   See Also|https://issues.oasis-open.o |
   |rg/browse/OFFICE-3850   |

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

   See Also||https://issues.oasis-open.o
   ||rg/browse/OFFICE-3850

--- Comment #3 from Regina Henschel  ---
I have no strong opinion yet. Whitespace handling is still an issue in the TC,
see OFFICE-3706 and OFFICE-3828

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||rb.hensc...@t-online.de,
   ||xiscofa...@libreoffice.org

--- Comment #2 from Xisco Faulí  ---
@Regina, Do you have any insight here?

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords|needsDevEval|needsDevAdvice

-- 
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 113726] Trailing space in cell text not encoded as

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

   Keywords||implementationError,
   ||needsDevEval
 CC||suokunl...@126.com

--- Comment #1 from Kevin Suo  ---
I confirm the behaviour as mentioned by the bug reporter. I also confirm that
this ods file when open in MSO 2010 the last space is not shown. 

But I am not sure whether this is a bug of LibreOffice or not.

Adding keyword implementationError, needsDevEval.

The ODF specification says:
(http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part1.html#element-text_s)
> The  element is used to represent the [UNICODE] character “ “ 
> (U+0020, SPACE).
>
> This element shall be used to represent the second and all following “ “ 
> (U+0020, SPACE) characters in a sequence of “ “ (U+0020, SPACE) characters.
>
> Note: It is not an error if the character preceding the element is not a 
> white space character, but it is good practice to use this element only for 
> the second and all following “ “ (U+0020, SPACE) characters in a sequence.

-- 
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