[Libreoffice-bugs] [Bug 144986] Formula to Value renders a blank non-empty cell

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Oct 8 00:08:43 UTC 2021


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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
I don't agree, to change the value, for me it's fine, it is not an empty cell,
with the same value before the operation.

 <table:table table:name="Hoja1" table:style-name="ta1">
    <table:table-column table:style-name="co1"
table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p/>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell office:value-type="float" office:value="1"
calcext:value-type="float">
      <text:p>1</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell office:value-type="float" office:value="2"
calcext:value-type="float">
      <text:p>2</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:formula="of:=IF([.B5]=0;"";1)">
      <text:p/>
     </table:table-cell>
    </table:table-row>
   </table:table>

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211008/c11fb91e/attachment.htm>


More information about the Libreoffice-bugs mailing list