Your message dated Wed, 09 Sep 2015 14:45:36 +0200
with message-id <[email protected]>
and subject line Re: Bug#777541: (libreoffice-calc): ignoring cell in formula
has caused the Debian Bug report #777541,
regarding (libreoffice-calc): ignoring cell in formula
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
777541: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=777541
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: libreoffice-calc
Version: 1:4.3.3-2
Severity: important
Hi,
Sorry my bad English
Cell I18 is ignored in the formula in cell J18. The sample attached
-- System Information:
Debian Release: 8.0
APT prefers testing-proposed-updates
APT policy: (500, 'testing-proposed-updates'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages libreoffice-calc depends on:
ii coinor-libcbc3 2.8.12-1
ii coinor-libcoinmp1 1.7.6+dfsg1-1
ii libboost-iostreams1.55.0 1.55.0+dfsg-3
ii libc6 2.19-13
ii libgcc1 1:4.9.1-19
ii libicu52 52.1-7
ii liblcms2-2 2.6-3+b3
ii libmwaw-0.3-3 0.3.1-2
ii libodfgen-0.1-1 0.1.1-2
ii liborcus-0.8-0 0.7.0+dfsg-9
ii libreoffice-base-core 1:4.3.3-2
ii libreoffice-core 1:4.3.3-2
ii librevenge-0.0-0 0.0.1-3
ii libstdc++6 4.9.1-19
ii libwps-0.3-3 0.3.0-2
ii libxml2 2.9.1+dfsg1-4
ii lp-solve 5.5.0.13-7+b1
ii uno-libs3 4.3.3-2
ii ure 4.3.3-2
ii zlib1g 1:1.2.8.dfsg-2+b1
libreoffice-calc recommends no packages.
Versions of packages libreoffice-calc suggests:
pn ocl-icd-libopencl1 <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.11.0-6.3
ii fonts-opensymbol 2:102.6+LibO4.3.3-2
ii libatk1.0-0 2.14.0-1
ii libboost-date-time1.55.0 1.55.0+dfsg-3
ii libc6 2.19-13
ii libcairo2 1.14.0-2.1
ii libclucene-contribs1 2.3.3.4-4
ii libclucene-core1 2.3.3.4-4
ii libcmis-0.4-4 0.4.1-7
ii libcups2 1.7.5-10
ii libcurl3-gnutls 7.38.0-4
ii libdbus-1-3 1.8.12-3
ii libdbus-glib-1-2 0.102-1
ii libeot0 0.01-3
ii libexpat1 2.1.0-6+b3
ii libexttextcat-2.0-0 3.4.4-1
ii libfontconfig1 2.11.0-6.3
ii libfreetype6 2.5.2-2
ii libgcc1 1:4.9.1-19
ii libgdk-pixbuf2.0-0 2.31.1-2+b1
ii libgl1-mesa-glx [libgl1] 10.3.2-1
ii libglew1.10 1.10.0-3
ii libglib2.0-0 2.42.1-1
ii libgltf-0.0-0 0.0.2-2
ii libglu1-mesa [libglu1] 9.0.0-2
ii libgraphite2-3 1.2.4-3
ii libgtk2.0-0 2.24.25-1
ii libharfbuzz-icu0 0.9.35-2
ii libharfbuzz0b 0.9.35-2
ii libhunspell-1.3-0 1.3.3-3
ii libhyphen0 2.8.8-1
ii libice6 2:1.0.9-1+b1
ii libicu52 52.1-7
ii libjpeg62-turbo 1:1.3.1-11
ii liblangtag1 0.5.1-3
ii liblcms2-2 2.6-3+b3
ii libldap-2.4-2 2.4.40-3
ii libmythes-1.2-0 2:1.2.4-1
ii libneon27-gnutls 0.30.1-1
ii libnspr4 2:4.10.7-1
ii libnspr4-0d 2:4.10.7-1
ii libnss3 2:3.17.2-1.1
ii libnss3-1d 2:3.17.2-1.1
ii libodfgen-0.1-1 0.1.1-2
ii libpango-1.0-0 1.36.8-3
ii libpangocairo-1.0-0 1.36.8-3
ii libpangoft2-1.0-0 1.36.8-3
ii libpng12-0 1.2.50-2+b2
ii librdf0 1.0.17-1+b1
ii libreoffice-common 1:4.3.3-2
ii librevenge-0.0-0 0.0.1-3
ii libsm6 2:1.2.2-1+b1
ii libssl1.0.0 1.0.1k-1
ii libstdc++6 4.9.1-19
ii libx11-6 2:1.6.2-3
ii libxext6 2:1.3.3-1
ii libxinerama1 2:1.1.3-1+b1
ii libxml2 2.9.1+dfsg1-4
ii libxrandr2 2:1.4.2-1+b1
ii libxrender1 1:0.9.8-1+b1
ii libxslt1.1 1.1.28-2+b2
ii libxt6 1:1.1.4-1+b1
ii uno-libs3 4.3.3-2
ii ure 4.3.3-2
ii zlib1g 1:1.2.8.dfsg-2+b1
-- no debconf information
--- End Message ---
--- Begin Message ---
Hi
On 09/02/15 15:44, YK wrote:
> Cell I18 is ignored in the formula in cell J18. The sample attached
I18 refers to cell F18, which is formatted as text, not a number. The
SUM() function considers that a cell which contains text - even if it
looks like a number - to be of value 0.
Solution:
* Change the format of cell F18 to General or a number format
(Format->Cells)
* The formula changes to '23,88. Now you can see it is a text value,
not a number.
* Re-enter the number, or remove the ' symbol to change it from text to
a number.
* The numeric value is now used in I18.
Chris
--- End Message ---
