Paste Special to convert formula to value doesn't

Discuss the spreadsheet application

Paste Special to convert formula to value doesn't

Postby SUNFAIR » Mon Jan 21, 2008 7:17 pm

have a check box for value. If I check every box but 'formula', the formula result converts to text. If I uncheck the formual and text boxes it returns a blank cell. What am I missing?
SUNFAIR
 
Posts: 1
Joined: Mon Jan 21, 2008 7:01 pm

Re: Paste Special to convert formula to value doesn't

Postby thomasjk » Mon Jan 21, 2008 7:39 pm

Uncheck Text, Formulas. Check Numbers. Works for me.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4431
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Paste Special to convert formula to value doesn't

Postby Villeroy » Mon Jan 21, 2008 9:01 pm

SUNFAIR wrote:have a check box for value. If I check every box but 'formula', the formula result converts to text. If I uncheck the formual and text boxes it returns a blank cell. What am I missing?

I'd bet the formula returns a text value. Test: =ISNUMBER(A1) or =ISTEXT(A1)
If the formula is supposed to return a number, you can wrap it in function VALUE. =VALUE(<formula>) fails with error #VALUE if the result of the inner formula can not be converted to number.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28846
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests