https://bugs.documentfoundation.org/show_bug.cgi?id=129460
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
CC| |miguelangelrv@libreoffice.o
| |rg
--- Comment #2 from m.a.riosv <miguelange...@libreoffice.org> ---
Cell format doesn't change ceel value, so references to the cell retrieve the
true value not the formatted value.
Use a formula like =CONCAT(TEXT(I10;"0")).
BTW you can use the operator '&' to concatenate texts ="a"&"b"
--
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