Issue 123901

Summary: formula DGET() gives #VALUE! error when fetching calculation resulting in string
Product: Calc Reporter: papayes <jyl44>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CLOSED FIXED QA Contact:
Severity: Normal    
Priority: P3 CC: damjan, elish, issues, pedlino, pescetti
Version: 4.0.1Flags: pescetti: 4.1.2_release_blocker+
Target Milestone: 4.1.2   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.2-dev
Developer Difficulty: ---
Attachments:
Description Flags
Error when data containt formula with string none

Description papayes 2013-12-21 09:13:35 UTC 

    


    


      



        
          Comment 1
        

        
          papayes

        

        
        

        
          2013-12-21 09:24:02 UTC
        

      






Created attachment 82144 [details]
Error when data containt formula with string

    


    


      



        
          Comment 2
        

        
          papayes

        

        
        

        
          2013-12-21 09:27:09 UTC
        

      






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

    


    


      



        
          Comment 3
        

        
          Edwin Sharp

        

        
        

        
          2013-12-22 13:34:47 UTC
        

      






Confirmed with
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian

    


    


      



        
          Comment 4
        

        
          SVN Robot

        

        
        

        
          2015-09-09 20:35:13 UTC
        

      






"damjan" committed SVN revision 1702107 into trunk:
#i123901# formula DGET() gives #VALUE! error when fetching calculation result...

    


    


      



        
          Comment 5
        

        
          damjan

        

        
        

        
          2015-09-09 20:38:30 UTC
        

      






ScDBQueryDataIterator::DataAccessInternal::getCurrent() was only dealing with formulas returning numbers, and skipping all strings. Patch committed, resolving fixed. Thank you for your bug report!

    


    


      



        
          Comment 6
        

        
          Andrea Pescetti

        

        
        

        
          2015-09-24 06:22:43 UTC
        

      






Approved for 4.1.2. @damjan: feel free to merge.

    


    


      



        
          Comment 7
        

        
          Andrea Pescetti

        

        
        

        
          2015-10-07 21:18:29 UTC
        

      






Committed to AOO410 for OpenOffice 4.1.2. Note: only the code fixes were merged, tests are only on trunk.

    


    


      



        
          Comment 8
        

        
          Andrea Pescetti

        

        
        

        
          2015-10-17 22:11:24 UTC
        

      






To verify: Open papayes' nice test document from the Attachments list ("Error when...") and check if you get an error in row 15.

    


    


      



        
          Comment 9
        

        
          Pedro

        

        
        

        
          2015-10-18 01:26:21 UTC
        

      






Verified fixed with

AOO412m2(Build:9781)  -  Rev. 1707648
2015-09-28 12:45:04 (Mo, 28 Sep 2015)

under Windows 7 Pro x64 SP1