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

Thanks, Tom.

Yep, I did save as ODS, then as CSV.  And yes, I expect the formulas to 
save in CSV as the value they were when saving.  That's why I saved to 
CSV in the first place.  I wanted to see if the formulas were being 
saved as the value and just not displaying that way. Unfortunately, I 
wasn't able to open the saved CSV file.

See next post.

Carl


On 12/12/12 3:26 PM, Tom Davies wrote:
> Hi :)
> I think saving a spreadsheet as a Csv strips out the formulae and replaces them with whatever the 
> answer happened to be at the moment of saving.
>
>
> It's better to save an original version as Ods and then if you want other people to be able to edit 
> and work with the sheet use
>
> File - "Save As ... "
>
> to save in Xls format (that's Microsoft Excel (97/2000/Xp)" (or soemthing like that).  Avoid using 
> the XlsX (MS 2007 or 2010 or 365, as all 3 of those are slightly different from each other).
>
>
> Regards from
> Tom :)
>
>
>
>
>
>
> > ________________________________
> > From: Brian Barker <b.m.barker@btinternet.com>
> > To: users@global.libreoffice.org
> > Sent: Wednesday, 12 December 2012, 19:54
> > Subject: Re: [libreoffice-users] Formulas in Calc not showing results
> >
> > At 12:10 12/12/2012 -0500, Carl Paulsen wrote:
> > > LO = 3.5.6.2 for Mac OS 10.6
> > > AutoCalculate is on
> > >
> > > 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.  Using the formula builder, it 
> > > shows the correct result (in this case, "Dear Kate and Marc."  It's just that the result doesn't show in the cell.
> > Remove the tick at Tools | Options...| LibreOffice Calc | View | Display | Formulas.
> >
> > >    My Tools menu doesn't contain Options as a choice (not even grayed out), so can't adjust that.
> > Under Mac OS, this setting is at LibreOffice | Preferences | LibreOffice Calc | View | Display | 
> > Formulas instead.
> >
> > > Finally, when I export to csv, where I should be able to see the formula results if they are being 
> > > created, I can't even open the resulting csv file with LO (or anything else I have on hand).
> > A CSV file is plain text, so you can certainly open it as a spreadsheet with LibreOffice Calc or as 
> > text with LibreOffice Writer.  Remember that when you save as CSV, only the active sheet is saved.
> >
> > I trust this helps.
> >
> > Brian Barker
> >
> >
> > -- 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

--

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