Excel in OnlyOffice - filtering and coediting

cpotter

Happy to see that you get traction with your users and Onlyoffice.

And you found an interesting usecase ; -)

We briefly thought that we could give you a workaround ... but not at least for now.

As you know, OnlyOffice has 2 co-editing operating modes, Fast and Strict (here with a text document but it is the same with spreadsheet):

Fast mode allows all users to see in realtime all modifications by users (including filtering)

Strict mode allows a user to work on his document and merge his modifications when he clicks on the same button (of course his edited cells are locked for others to ensure consistencies)

Therefore our idea was to use the Strict mode.

Unfortunately, when using this mode, the first user can filter his spreadsheet, but other users cannot do the same (in fact there is even an onlyoffice bug because the filter drop-down is not greyed). We will certainly open an issue to Onlyoffice.

There is perhaps another way using Onlyoffice macros but this has to be investigated.

Have a nice end of day,

aclassen

Now that is interesting, thank you. Perhaps OnlyOffice come up with a solution then

cpotter

@aclassen we have open an issue to Onlyoffice here https://github.com/ONLYOFFICE/DocumentServer/issues/1246

However we are afraid that they will correct this misbehavior by only greying the filter cells for other co-editors and not give to every users the ability to define its own filters until he 'saves' to synchronize his modifications with others

cpotter

@aclassen Onlyoffice told us that you can achieve what you want using SheetView
(paid edition only) https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Spreadsheet-Editor/UsageInstructions/SheetView.aspx

aclassen

@cpotter OK, thanks for this.

Would using a paid edition of OnlyOffice be possible within GoFAST?

cpotter

@aclassen yes of course, we are an official partner of Onlyoffice, we can send you a quotation. It will give you also the ability to open more than 20 documents simultaneously in Onlyoffice

aclassen

@cpotter it would be interesting to see (just to learn about the size of such an investment at this point)

cpotter

@aclassen the first onlyoffice subscription is 1020€/year giving you some additional features (https://www.onlyoffice.com/en/compare-editions.aspx) and up to 50 documents opened simultaneously

Important : you need also the Enterprise edition to use Onlyoffice on tablet in edit mode

cpotter

@aclassen nothing related to this post, but did you had a look to https://community.ceo-vision.com/topic/497/extension-zotero-dans-onlyoffice about Bibliographical References plugin for Onlyoffice ? I had in mind it was a topic of interest for EMCDDA

aclassen

@cpotter Oh yes, I'll share that with my colleagues, perhaps we could experiment with it?

cpotter

@aclassen if the test is successful with INSA-Lyon, of course we can install it on your GoFAST or in parallel in you prefer