You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/12/21 10:13:35 UTC

[Bug 123901] New: formula DGET() gives #VALUE! error when fetching calculation resulting in string

https://issues.apache.org/ooo/show_bug.cgi?id=123901

            Bug ID: 123901
        Issue Type: DEFECT
           Summary: formula DGET() gives #VALUE! error when fetching
                    calculation resulting in string
           Product: Calc
           Version: 4.0.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: jyl44@free.fr
                CC: issues@openoffice.apache.org

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123901] formula DGET() gives #VALUE! error when fetching calculation resulting in string

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123901

--- Comment #2 from papayes <jy...@free.fr> ---
Hello,

When the DGET() formula fetches data from a cell that contains a formula THAT
RESULTS IN A STRING, the result is the #VALUE!-error. The fetched cell itself
shows the correct string value.

If the fetched cell contains a string (not a formula), the string is fetched
correctly.

Resolved with LibreOffice :
https://bugs.freedesktop.org/show_bug.cgi?id=49052
cordially

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123901] formula DGET() gives #VALUE! error when fetching calculation resulting in string

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123901

--- Comment #1 from papayes <jy...@free.fr> ---
Created attachment 82144
  --> https://issues.apache.org/ooo/attachment.cgi?id=82144&action=edit
Error when data containt formula with string

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123901] formula DGET() gives #VALUE! error when fetching calculation resulting in string

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123901

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@apache.org
             Latest|---                         |4.1-dev
    Confirmation on|                            |
     Ever confirmed|0                           |1

--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.