Thank you for the remarkable work you are doing for the open source community.
I am saddened but not surprised. I realized quite quickly that this feature is completely absent.
Let me explain the significance of that feature.
If you are not familiar with hotel room price calculation, it is always base rate for the room plus extras. Base rate and extras vary with seasonality of hotels. Moreover, extras vary depending on room configuration: number of adults, number of children, meal plan, extra bed or not and so forth. So, in other words, you have huge tables that are full of formula to reach the net price per room per night for particular date and room configuration. I cannot simply drag/copy the formula across the entire table. I have to carefully review each price calculation.
Question is how I am supposed to review walls of formula if I don’t have formula view option? I do not calculate each hotel booking individually, my company has thousands of bookings each day through automated price distribution system. I only calculate the net prices for each possible date and room configuration through spreadsheets. Reviewing each formula by selecting/focusing the cell is just not an option.
Due to certain reasons, I was working for a short period of time from home, and I couldn’t recommend OnlyOffice to any of my colleagues (who were working from home as well) because without formula view I by myself couldn’t do much in spreadsheets.
Overall, working with formula, adding changes to calculations without seeing formula right away (instead of final results/values) is ridiculously tedious to the point that I wouldn’t try to do that.
Even when I simply calculate my personal finance it is needed to ensure the final numbers are right. I do not have to check whether the final value is correct or not, I just have to make sure that the formula is correct.
I do hope you understand. As a matter of fact, this is quite literally the only reason why I cannot use OnlyOffice for work and the only reason why I cannot recommend OnlyOffice to dozen of my colleagues. I wanted to recommend your office suite to the guy responsible for almost the entire IT in my company so that maybe he will consider switching from MS Office on our computers but again even I can’t accomplish what is needed with OnlyOffice.
I hope you will consider prioritizing this feature/function in future releases:)