https://bugs.documentfoundation.org/show_bug.cgi?id=91070
Buovjaga <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Version|4.4.3.2 release |4.3.7.2 release
--- Comment #25 from Buovjaga <[email protected]> ---
(In reply to gmarco from comment #16)
> Created attachment 115508 [details]
> same bin on 1drive (see previous comment)
>
> The .bin here attached is the same you can find on 1drive.
> Renaming it as .xls you get the original sheet like that I have on my
> harddisk.
I saved it to .ods.
Below are XML snippets from the content.xml. Note that the color #ff9999 is the
red we see in for example F54.
Cell 53:
<table:table-cell table:style-name="ce18" table:formula="of:=[.C38]-[.C39]"
office:value-type="float" office:value="-15" calcext:value-type="float">
<text:p>-15,00</text:p>
</table:table-cell>
The cell style of F53:
<style:style style:name="ce18" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N2">
<style:table-cell-properties style:glyph-orientation-vertical="0"
fo:background-color="#ff9999" style:cell-protect="protected"
style:print-content="true" style:diagonal-bl-tr="none"
style:diagonal-tl-br="none" style:text-align-source="value-type"
style:repeat-content="false" fo:wrap-option="no-wrap" fo:border="none"
style:direction="ltr" fo:padding="0.71mm" style:rotation-angle="0"
style:rotation-align="none" style:shrink-to-fit="false"
style:vertical-align="automatic" loext:vertical-justify="auto" />
<style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm"
style:writing-mode="page" />
<style:text-properties fo:color="#000000" style:text-outline="false"
style:text-line-through-style="none" style:text-line-through-type="none"
style:font-name="Courier New" fo:font-size="10pt" fo:font-style="normal"
fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal"
style:font-size-asian="10pt" style:font-style-asian="normal"
style:font-weight-asian="normal" style:font-name-complex="Courier New"
style:font-size-complex="10pt" style:font-style-complex="normal"
style:font-weight-complex="normal" />
<style:map style:condition="cell-content-is-not-between(-12,+12)"
style:apply-style-name="Excel_5f_CondFormat_5f_1_5f_2_5f_1"
style:base-cell-address="'RIEPIL.'.F53" />
</style:style>
Row 54:
<table:table-cell table:style-name="ce19" table:formula="of:=[.C41]-[.C42]"
office:value-type="float" office:value="-7" calcext:value-type="float">
<text:p>-7,00</text:p>
</table:table-cell>
Cell style of F54 is the same as F53, except the style to be applied by
condition is Excel_5f_CondFormat_5f_1_5f_1_5f_1
I don't know what the problem is, but I thought to save some digging time..
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
