Description: windows ltsc 21H2 X64 libreoffice portable V7.6 calc program can not achieve the following function insert->filed(date, sheet name, document_title) The buttons are grayed out and are not available. Please fix this feature. writer program functions insert->field program functions work properly Actual Results: calc program can not achieve the following function insert->filed(date, sheet name, document_title) The buttons are grayed out and are not available. Expected Results: Should be able to insert date, paper name, document title normally Reproducible: Always User Profile Reset: Yes Additional Info: No relevant information
The program function of inserting sheet name, document title. in cell does not work.
When you first click on the formula bar (input box) then you can insert those fields. Each cell can have multiple fields, or another text and fields and so on. I guess that, even when the Insert > Field menu entry is grayed out (before entering into cell's edit mode), the sub-menu could also be displayed (also grayed out), so the user has a clue of what potential alternative fields would be available. In that case, this ticket should be modified, changing the title subject in order to request this change.
(In reply to ady from comment #2) > When you first click on the formula bar (input box) then you can insert > those fields. Each cell can have multiple fields, or another text and fields > and so on. We could overwrite the cell content when adding a field not in edit mode. But rather keep it blocked and give better feedback. > I guess that...the sub-menu could also be displayed... Don't get this. Please elaborate :-)
(In reply to Heiko Tietze from comment #3) > > I guess that...the sub-menu could also be displayed... > Don't get this. Please elaborate :-) 1. Open new Calc. 2. (Do _not_ enter into cell edit mode) Click menu Insert > move mouse to "Field" entry within the Insert menu. There is an arrow pointing to the right, indicating that there is a sub-menu for "Field", but when the mouse pointer is focused on the Field entry, the sub-menu does not display the possible entries. Now repeat the steps but with a minor difference: 1. Open new Calc. 2. Press F2 (in order to enter cell's edit mode) and then click menu Insert > move mouse to "Field" entry within the Insert menu. With this modified steps, the field entry is allowed (i.e. not grayed out), and when pointing the mouse to it, the sub-menu entries are displayed (not grayed out, as expected because they can be used in this case). I am trying to suggest that, even when the Field entry of the Insert menu is grayed out, it could still allow to show the sub-entries, also grayed-out when that's the expected case.
For me (Linux/KDE, tested with gen,gtk3,kf5) the "Fields" menu item is always enabled but the submenu items are disabled until the edit mode. And actually I doubt showing (or not) the disabled submenu items makes the situation more clear. The context menu has a Fields entry when in edit mode, not in view mode (Cell Edit vs. Cell in the customization). So we could remove Fields from the main menu (or show it only when in edit mode, although that's no a good solution).
(In reply to Heiko Tietze from comment #5) > For me (Linux/KDE, tested with gen,gtk3,kf5) the "Fields" menu item is > always enabled but the submenu items are disabled until the edit mode. Not under MS Windows in recent LO Dev 24.2 (but yes in 7.6.0.3); the sub-entries are not shown when the Field entry is grayed out. Showing the sub-entries (in gray when adequate, as in LO 7.6.0.3) is more clear for (new) users. IOW, keep "Field" grayed out when relevant, but also show the sub-entries (also in gray when relevant). > So we could > remove Fields from the main menu (or show it only when in edit mode, > although that's no a good solution). It would make the entry harder to discover and to learn about it, as this report shows. The feature is already not immediately understood (or at least how to use it, requiring edit mode); let's not make it harder. In the meantime, we have now shown a regression in UX in LO Dev 24.2 vs 7.6.
Tried all of the above, but it still doesn't work. Can't upload a picture to clearly show the problem I'm experiencing
(In reply to neil from comment #7) > Tried all of the above, but it still doesn't work. Please re-read comment 2. Before trying to insert a field, click first on the input box (formula bar). > Can't upload a picture to clearly show the problem I'm experiencing In the web page of the report bug 157036, there is a link "Add an attachment". Please don't set your own report to NEW. There is still no confirmation from someone else that there is a bug.
Comment 2 Effective in solving problems. Thank you. Best wishes libreoffice gets better and better!!!!
Description: windows ltsc 21H2 X64 libreoffice portable V7.6 calc format cells number normal language default-chinese(simplified) In the cell enter "= (69.15-62.15)*1000" Return value is 7000.00000000001 In cell A1 enter "= 69.15-62.15" return value of 7, in cell B1 enter "= A1 * 1000" return value of 7000.00000000001 In the cell enter "=(77.15-69.15)*1000" Return value is 8000 In cell A1 enter "=(77.15-69.15)" return value of 8, in cell B1 enter "= A1 * 1000" return value of 8000 Why is this value returned? Is it a bug? Please fix it. Thanks.
@ neil, This site is aimed at bug reports and enhancements requests (one per ticket); this is not a support site. Please either subscribe to the users mailing list and ask your questions there, or read the Help content or the Manuals, or go to https://ask.libreoffice.org .
@ UX Team: my report in comment 6 has had no feedback. I think that should be a new regression bug report (not related to this one, if someone else can confirm my report in comment 6). As for tdf#157036 itself, I am closing it as NOTABUG.
(In reply to ady from comment #12) > @ UX Team: my report in comment 6 has had no feedback. I think that should > be a new regression bug report (not related to this one, if someone else can > confirm my report in comment 6). Yes, maybe it's a bug. But IIRC some OS/DE don't expand the submenu for disabled nodes and maybe that happens in this case.
(In reply to Heiko Tietze from comment #13) > (In reply to ady from comment #12) > > @ UX Team: my report in comment 6 has had no feedback. I think that should > > be a new regression bug report (not related to this one, if someone else can > > confirm my report in comment 6). > > Yes, maybe it's a bug. But IIRC some OS/DE don't expand the submenu for > disabled nodes and maybe that happens in this case. @ Heiko, that's not the case here: the problem happens on LO 24.2 but it does not happen on LO 7.6. Please re-read comment 6, and comment 4 for STR for the potential new regression (not related to tdf#157036).
@ady. Thanks for the kind reminder.