https://bugs.documentfoundation.org/show_bug.cgi?id=113002
--- Comment #15 from Robert Lacroix <ralacr...@hydro.mb.ca> ---
e: #(In reply to Robert Lacroix from comment #14)
> One workaround is to convert this column in the source data to a text value.
> One way to do this for computed values is to append an empty string onto the
> computation. For example: =date(1995,7,28)&"" Then all the item labels
> will be text for that field.
>
> This is an unsatisfactory workaround if you expect the field to have numeric
> values, like when applying conditional formatting or when using the labels
> in a numeric computation. For instance when cell A3 contains a text value
> '1234 and cell D3 contains a formula =A3>1235 the value of cell D3 is
> TRUE.
Actually, this workaround is barely even useful - it works only for numbers
whose integer part is fixed-length, like a bar code. Integers of varying length
converted to text strings will sort ascending lexically so that "1000" comes
before "104". The workaround sorts the text representation of the date/time
values correctly but the resulting string of digits is practically worthless
because you can't interpret it as a date without converting it back to a
number.
--
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