On Wednesday 02 November 2005 11:18 am, you wrote:
> Am Mittwoch, 2. November 2005 17:25 schrieb Dan Lewis:
> > On Wednesday 02 November 2005 09:49 am, Guido Pinkernell wrote:
> > > Am Mittwoch, 2. November 2005 03:45 schrieb Andrew Good:
> > > > Hi. I am a first-time convert from MS Office. While the majority of
> > > > the functions have been relatively simple to figure out, I haven't
> > > > been able to ascertain how to make CALC display all of the formulas
> > > > in the spreadsheet as formulas so that they are easy to check and
> > > > print out. MS Office refers to it as "Formula Auditing Mode" and uses
> > > > Ctrl+` as a shortcut. How can this be accomplished in this otherwise
> > > > user-friendly program?
> > > >
> > > > Tools > Options > Openoffice. Calc > View > Formulas
> > >
> > > However I am not sure whether the formulas will be printed as well.
> > > Please try, and let us know if it works, on [email protected]
> > >
> > > Thanks!
> > >
> > > Guido
> >
> > When I did the
> > Tools > Options > OpenOffice.org Calc >View > Formulas,
> > the formulas appeared in the correct cells in the spreadsheet. I saved
> > the spreadsheet and then printed it to a ps file. The formulas did not
> > appear in the ps file.
>
> I suspected as much. However when checking Issuezilla about a bug report I
> found this: http://qa.openoffice.org/issues/show_bug.cgi?id=36059.
>
> Printing formulas seems to be possible after all.
>
> Thanks for reporting.
>
> Guido
I looked that what was written in that bug report, and at first did not
understand one thing that was written. However, I realized what he was
saying:
Format >Page > Sheet (tab). The middle section of the Sheet tab contains the
Print selections. Formulas is one of the selections. Check (tick) it if you
want to view and print the Formulas in your spreadsheet.
Hopefully, this will make more sense than what was written in the bug
report.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
