Re: [libreoffice-users] Formulas in Calc not showing results

Thanks, Brian,

So I finally was able to open the CSV file after re-saving it a few 
times.  Not sure what that's about...

The CSV file has the proper values saved instead of the formulas, so it 
appears it's just a display issue.  I'll try to dig further to see what 
might be going on.  Restart the software or reboot the computer 
sometimes helps these odd glitches.

Carl



On 12/12/12 3:45 PM, Brian Barker wrote:
> At 12:10 12/12/2012 -0500, Carl Paulsen wrote:
> > I'm trying to build a simple text concatenation (formula is 
> > =CONCATENATE("Dear ",Q2), though I also tried it as ="Dear " & Q2).  
> > The formula only shows as the text of the formula, not the result of 
> > the formula.
>
> Another possible cause of this is formatting the cell as Text before 
> you enter the formula.
>
> I trust this helps.
>
> Brian Barker

--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted