[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#777541: marked as done ((libreoffice-calc): ignoring cell in formula)

Your message dated Wed, 09 Sep 2015 14:45:36 +0200
with message-id <55F029F0.5020003@debian.org>
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 owner@bugs.debian.org
immediately.)


-- 
777541: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=777541
Debian Bug Tracking System
Contact owner@bugs.debian.org 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 ---
Reply to: