search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.82k stars 1.08k forks source link

Support for documents containing macros #240

Open apaqd opened 6 years ago

apaqd commented 6 years ago

We've got several Excel documents containing macros, therefor they're stored as .xlsm which isn't supported by OO. It would be great if those could be edited, without the macro functionally of course.

flaminestone commented 6 years ago

Hello @apaqd. ONLYOFFICE is not support ms office macroses now, and if you will upload .xlsm file, it will be converted to .xlsx, and all macroses will be deleted. In future ability to editing files with macros will be added(without the macro functionally), but it is not possible at this moment

falling-star commented 5 years ago

@ShockwaveNN is there any update on this ? MS Macros not working is okay but Ideally they should not be deleted ? Please update the current flow, thanks.

flaminestone commented 5 years ago

@falling-star, MS Macroses still delete from files after opening or convertion. We will fix it in future

alexgogan commented 5 years ago

Hi, would you have any idea if it is happening this year or not as it is a feature I use a lot?

flaminestone commented 5 years ago

Hi @alexgogan. We do not know when we will make this feature.

trofim24 commented 3 years ago

We do not plan to implement VBA support. We have our own macros and plugins on JavaScript language. But I will leave this issue. Since we will implement so that the macros existing in the file are not lost, but it will still be impossible to use, add and edit them.

cpot commented 3 years ago

This is course could slow down Onlyoffice adoption in Financial BU, but we can understand that for several reasons including IP issues, you cannot support VBA.

However a converter for the most used macros could be a big plus

trofim24 commented 3 years ago

Can you send us examples of most used macros? We will try to write an analogue on our API. It will be much easier than writing a converter. Microsoft and Google did not do this, although booth have JavaScript API.

cpot commented 3 years ago

We could perhaps ask our customers about it ... It will take some time.

Opensource world must be better and wiser than Microsoft and Google to have a chance to compete ;-)