Re: [libreoffice-users] vlookup with cell reference for range

2013-11-03 Thread greg.a.sm...@oracle.com
What I have done that works is first name the region. Then I place the region name in a cell, then us indirect(cell with range name). hth gs On 11/3/2013 11:19 AM, yahoo-pier_andreit wrote: using libreoffice Version 4.0:build-305 on my opensuse 12.3 I would like to have a reference in the

Re: [libreoffice-users] treatment of blank cells

2013-08-20 Thread greg.a.sm...@oracle.com
So the cells are the result of opening a .csv file where the string has nothing between commas such as 5,4,,,3,,2,1 between the consecutive commas is nothing, so the cell should be made totally empty. gs On 8/19/2013 8:22 PM, Steve Edmonds wrote: On 2013-08-20 13:02, Virgil Arrington