[Solved] Grey menu prevents field entry
- morphingstar
- Posts: 101
- Joined: Mon Mar 28, 2011 5:52 am
- Location: Mx
[Solved] Grey menu prevents field entry
I want to enter the field for Author (and more, the usual page, date etc stuff).
CALC Menu INSERT
In Openoffice the choice is grey. V4.1.14.
In Libreoffice the choice does not exist. V7.6.2.1.
Both programs used to work fine, no such problem until today.
Chaos reigns
CALC Menu INSERT
In Openoffice the choice is grey. V4.1.14.
In Libreoffice the choice does not exist. V7.6.2.1.
Both programs used to work fine, no such problem until today.
Chaos reigns
Last edited by MrProgrammer on Tue Mar 12, 2024 6:29 pm, edited 3 times in total.
Reason: Tagged ✓ [Solved] Double click the cell, then you can insert fields -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] Double click the cell, then you can insert fields -- MrProgrammer, forum moderator
OO 4.1.6 on Win10. Member since StarOffice 7. Alternative name "morphingstar2" when other fails. Use Writer, Calc (as DB + Calc), Draw. Impress mainly for Eyedropper and animating GIFs. Updated 20190716.
Re: Grey menu prevent field entry
Hi,
Try to post example and keep calm. Xchtulu has nothing to do neither with AOO nor with LO.
Be peaced and quiet
Nick
Try to post example and keep calm. Xchtulu has nothing to do neither with AOO nor with LO.
Be peaced and quiet
Nick
Libre Office 6.0.7 on Ubuntu 18.04
Re: Grey menu prevent field entry
I don't see any menu item related to inserting an author field in Calc. Are you really using Calc? I'm familiar with that in Writer.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Grey menu prevent field entry
Personally do fully agree with FJCC.
No Panic Please!
No Panic Please!
Libre Office 6.0.7 on Ubuntu 18.04
Re: Grey menu prevent field entry
@ morphing star
Would you please be so kind to STATE IF YOU COULD select menu File--->Properties and follow up? Such routine is available both in CALC and WRITER.
Regards
Would you please be so kind to STATE IF YOU COULD select menu File--->Properties and follow up? Such routine is available both in CALC and WRITER.
Regards
Libre Office 6.0.7 on Ubuntu 18.04
Re: Grey menu prevent field entry
In Apache OpenOffice 4.1.11, Insert - Fields is not available, You can enter some document statistics in the header or footer of a Calc document. To do that, select Format - Page, select the Header or Footer tab, enable the header or footer and then click Edit to open a simple editor where you can insert some fields. The Author field is not available in Calc, but you can enter such data manually. You can enter the author name, but that option is well hidden. In the screenshot, floris_v v is the author name. All of this is very limited, but then, remember that Calc is calculating software, not formatting software.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
Re: Grey menu prevent field entry
Attached screenshot shows who's the author. (Select File--->Properties)
- Attachments
-
- document owner.png (24.06 KiB) Viewed 1834 times
Libre Office 6.0.7 on Ubuntu 18.04
Re: Grey menu prevent field entry
Check if the file is read-only.
AOO 4.1.15 & LO 24.2.2 on Windows 10
Re: Grey menu prevent field entry
Cross posted on AskLibreOffice
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.3.2; SlackBuild for 24.2.3 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.3.2; SlackBuild for 24.2.3 by Eric Hameleers
- Hagar Delest
- Moderator
- Posts: 32687
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Grey menu prevent field entry
It seems that Calc does not support fields in the header/footer.
I haven't even found any enhancement request for that on the LO bugzilla.
I haven't even found any enhancement request for that on the LO bugzilla.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10
Re: Grey menu prevent field entry
LibreOffice Calc seems to have similar to what floris v describes for AOO. For LO 7.6.3.2 choose Format | Page Style which presents this dialog:
Select Edit and a further dialog allows addition of various fields to the header.Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.3.2; SlackBuild for 24.2.3 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.3.2; SlackBuild for 24.2.3 by Eric Hameleers
- morphingstar
- Posts: 101
- Joined: Mon Mar 28, 2011 5:52 am
- Location: Mx
Re: [Dropped] Grey menu prevents field entry
Lots of answers, most not to the matter at hand, thanks for trying. Please look at the CALC picture, it answers all doubts mentioned.
[img]E:\ASUS\HD_ALL\Pictures\_Screenshots\LO field entry no choice 20240301a.jpg[/img]
first the file was too big, I did not change it, later it worked.
[img]E:\ASUS\HD_ALL\Pictures\_Screenshots\LO forum file size problem when dropping into text field 20240301a.jpg[/img]
[img]E:\ASUS\HD_ALL\Pictures\_Screenshots\LO field entry no choice 20240301a.jpg[/img]
first the file was too big, I did not change it, later it worked.
[img]E:\ASUS\HD_ALL\Pictures\_Screenshots\LO forum file size problem when dropping into text field 20240301a.jpg[/img]
- Attachments
-
- LO forum file size problem when dropping into text field 20240301a.jpg (33.73 KiB) Viewed 851 times
-
- LO field entry no choice 20240301a.jpg (60.64 KiB) Viewed 851 times
OO 4.1.6 on Win10. Member since StarOffice 7. Alternative name "morphingstar2" when other fails. Use Writer, Calc (as DB + Calc), Draw. Impress mainly for Eyedropper and animating GIFs. Updated 20190716.
Re: [Dropped] Grey menu prevents field entry
That screenshot doesn't show the cell where you want to insert a field. I just played with this and found that when you select a cell, so it has a blue border and no cursor is visible, Insert - Field is disabled. Double click in the cell so that the cursor appears, then you can insert fields.
On a side note: when your files are so big that the forum software blocks uploading, you can always upload them at a freehoster like mediafire.com and post a link here. Any other freehoster will do, but expect trouble if you select one where we have to register before we can download anything.
On a side note: when your files are so big that the forum software blocks uploading, you can always upload them at a freehoster like mediafire.com and post a link here. Any other freehoster will do, but expect trouble if you select one where we have to register before we can download anything.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
- morphingstar
- Posts: 101
- Joined: Mon Mar 28, 2011 5:52 am
- Location: Mx
Re: [Solved] Grey menu prevents field entry
I shall try sugg's, thanks for help. As to "floris" in spreasheet there is always 1 cell ready to accept input (except when protected), never mind the position of the cell cursor, else the sheet could not work.
If the drop down menu indicates the available choices but greyed out it indicates these are not active, there must be a reason.
The cell to go is not protected, keyboard entry is possible. The cell to go does not have to be near the drop-down menu to show, though it might need to be empty.
I 'll continue trying, shall come back and add solution / reason if found, and the add Solved. Til then
If the drop down menu indicates the available choices but greyed out it indicates these are not active, there must be a reason.
The cell to go is not protected, keyboard entry is possible. The cell to go does not have to be near the drop-down menu to show, though it might need to be empty.
I 'll continue trying, shall come back and add solution / reason if found, and the add Solved. Til then
OO 4.1.6 on Win10. Member since StarOffice 7. Alternative name "morphingstar2" when other fails. Use Writer, Calc (as DB + Calc), Draw. Impress mainly for Eyedropper and animating GIFs. Updated 20190716.
Re: [Solved] Grey menu prevents field entry
When a cell is first selected, it is in Selection Mode. Typing input when a cell is selected switches to Input Mode. Input while in Input Mode replaces existing cell content. Double-clicking a selected cell or pressing F2 switches to Edit Mode and existing cell content can be edited. Insert > Fields options are only available for cells in Input Mode or Edit Mode.
Calc/Cell Edition Modes
Calc/Cell Edition Modes
AOO 4.1.14 on Ubuntu MATE 22.04