[Solved] Formula edit line (at top) is not visible

Discuss the spreadsheet application
Post Reply
garyrnorth
Posts: 2
Joined: Tue Jun 06, 2023 2:57 pm

[Solved] Formula edit line (at top) is not visible

Post by garyrnorth »

Hello
Been using open office for many years. specifically calc. Thanks for the forum;
hopefully my ignorance can be helped.
Please forgive me for not knowing the proper terminology here.
In older versions of your software when I would type a formula into a cell
whatever had been typed into that cell would be displayed in that cell and
would also be displayed on a line at the top of the page.
I could edit the cell contents in either the cell or that line above.
A few months ago I updated to version 4.1.11 and that line ,above ,that displayed
the contents of a particular cell disappeared.
ALSO
The sum of whatever formula is displayed in that cell is displayed BUT the actual formula is no longer
visible.
I have to re-insert the entire formula any time a change is made ie adding a few lines or whatever.

Please help this is irritating.

 Edit: Changed subject, was Problem with cell formulas' sort of 
Make your post understandable by others 
-- MrProgrammer, forum moderator 
Last edited by MrProgrammer on Tue Jun 06, 2023 7:20 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.14
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Problem with cell formulas' sort of

Post by RoryOF »

Try /View /Toolbars /Formula Bar
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
garyrnorth
Posts: 2
Joined: Tue Jun 06, 2023 2:57 pm

Re: Formula edit line (at top) is not visible

Post by garyrnorth »

WOW Thanks so much
That was irritating
Thanks again
OpenOffice 4.1.14
Post Reply