Cells calculated by named range not visible in mail merge

panchristo · Newbie Joined: 11 Sep 2011 Posts: 3

I have a Workbook created in Calc, where one sheet gets updated automatically. A second sheet is used to merge RAW data from the first. I have used named ranges to format the data in the second sheet, which is then used as a database source for document templates created in Write. The problem is that when I import data from columns where named ranges have been used in their formulas, they appear as empty in the Writer dialog.

Is there any specific reason that this named range-formula driven cells don't get updated when viewed externally or is it some sort of bug?
For the time being I got rid of all the uses of named ranges and everything works fine (would rather not of course)

Does this however sound like something that needs to be fixed in a forthcoming version, or is it due to some internal structure that cannot be overcome?

Villeroy · Posted: Fri Apr 20, 2012 2:52 am Post subject:

Operating system?
Office Version?
Formula?
Returned data types?
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

panchristo · Newbie Joined: 11 Sep 2011 Posts: 3

Windows XP / Vista
OO v.3.2
Simple text formulas combined with IFs to produce custom format DATA (concatenation, paragraph, e.tc.)
Data Type Text Mostly

panchristo · Newbie Joined: 11 Sep 2011 Posts: 3

Any possible answers anyone?

Villeroy · Posted: Thu Apr 26, 2012 12:45 am Post subject:

Version 3.2 has a bug.Text and numbers mixed in the same column give a blank field in database context.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org