Re: [libreoffice-users] #NAME? error in valid formula in xlsx format spreadsheet

2013-01-21 Thread Tom Davies
anuary 2013, 19:59 >Subject: [libreoffice-users] #NAME? error in valid formula in xlsx format >spreadsheet > >TIA! > >I have an xlsx format spreadsheet with several formulas: > >=PRODUCT(SUM(months("10/21/2012",NOW(),1),months("11/6/2012",NOW(),1)) ,50)

[libreoffice-users] #NAME? error in valid formula in xlsx format spreadsheet

2013-01-21 Thread Eric J Owens
TIA! I have an xlsx format spreadsheet with several formulas: =PRODUCT(SUM(months("10/21/2012",NOW(),1),months("11/6/2012",NOW(),1)) ,50) When I close and re-open the spreadsheet, the cell with the formula gives me the #NAME? error. The first time I saw this and after quite a while trying to de