How to show formulas written on cells instead of their value? I found documentation that guides as follows: View > Show Formulas.
I don’t see such option in Collabora Office Desktop 26.04, installed from the Microsoft Store?
How to show formulas written on cells instead of their value? I found documentation that guides as follows: View > Show Formulas.
I don’t see such option in Collabora Office Desktop 26.04, installed from the Microsoft Store?
Hi @tmuukkon
One check first, because there are two different Collabora Office desktop applications and the answer is different for each.
Collabora Office Classic keeps the older menu layout, and it does have View > Show Formula, with Ctrl+` as its shortcut. That is the application the documentation you found describes.
Collabora Office 26.04, the newer desktop application, is built on the same front end as Collabora Online, and that front end has no Show Formulas entry at all. It is not in the View menu and it is not on any of the toolbar tabs. If your Calc window has the tabbed toolbar with File, Home, Insert, Page Layout, Formulas, Data, Review and View along the top, you are on the newer one. Help > About will confirm which you have.
So you have not missed a menu. In the newer application there is no setting yet that switches a sheet over to showing formulas instead of results. It is reported at Show formulas function not found · Issue #14450 · CollaboraOnline/online · GitHub and the report is still open.
Until it is added, the way to read the formulas in that application is a helper column using the FORMULA function, which gives you the formula of the cell you point
Is there any sort of time estimate for when this feature will be added?
@tmuukkon That’s a tough question to answer, as I can’t commit to a specific timeline. It will depend on priorities and the resources available.
However, if you’re interested, I’d love to see you explore Collabora Online and work on a patch for this! You can find the build instructions and other useful resources on our community page: https://www.collaboraoffice.org/
Happy to help if you need any pointers along the way! ![]()