Hi Ian, The only Open Source attempt i am aware of is LibreOffice Online (discontinued) and only office. In case of LibreOffice Online you can check out Collaboras code publication as Dave mentioned, but this is to my knowledge not really open Source, because otherwise TDF would not have discontinued libreOffice online. But I have not followed the details. My understanding might be wrong.
I am not a fan of the Approach of putting AOO on a server and believe it is save. AOO is not made for a server usage. It is made to be easily extended on a desktop system. Once the GUI is exploitable through the web you have a security nightmare to distinguish valid from illegit changes to the system. There are a lot of things to be thought about. @collaboration Collaboration is maybe thought of an independent module. maybe exchanging changes through a matrix channel. This is something AOO could support as a desktop app and you have less dependencies on a web GUI for example. Also if combined with a git document versioning there could be ways to support users collaboration Ina n easier way. @web GUI approach None the less a web UI could be done by implementing a new interface. Basically you need to extend the GUI classes. If I would have to design. That I think the best approach would be to write a J2EE frontend with HTML5. You can check out in the code how gtk, qt, windows and Mac UI are implemented and you add one with a J2EE approach Another approach is to check out the GUI less mode that AOO has, there are GitHub Repos on the web that work with this as an interface. But the GUI less approach is not made to scale. Using this would mean to spin up a new AOO insta CE for each user. How those communicate I don't know. My 2 cents Peter Am 2. August 2024 07:42:43 MESZ schrieb "石 尹賢" <s31...@hotmail.com>: >Dear OpenOffice team, >I am writing to inquire about the feasibility of integrating OpenOffice into a >web-based system. >We are aiming to develop a platform that allows users to edit and save >spreadsheets similar to offline Microsoft Excel, but with the added benefits >of online collaboration and centralized data storage. While Google >Spreadsheets offers these functionalities, we have concerns regarding data >confidentiality. >Our proposed system would: > > * Provide a user-friendly interface: Mimicking the familiar experience of > using offline Excel. > * Enable real-time collaboration: Multiple users can edit the same > spreadsheet simultaneously. > * Offer secure cloud storage: Protecting sensitive data from unauthorized > access. > >Specifically, we would like to know if it is possible to: > > 1. Embed OpenOffice into a web application: Are there any existing examples > or tutorials that could guide us in this process? > 2. Customize the saved file format: Can we modify OpenOffice to save data > in a format that is more suitable for our database (e.g., PostgreSQL)? > Ideally, we would like to break down the spreadsheet data into individual > records for better organization and querying. > >Key considerations for us include: > > * Performance: The system should be responsive and handle large datasets > efficiently. > * Security: We need to ensure that data is encrypted both in transit and > at rest. > * Scalability: The system should be able to accommodate a growing number > of users and data. > >We believe that OpenOffice, with its powerful features and open-source nature, >would be an ideal foundation for our project. Any insights or guidance you can >provide would be greatly appreciated. >Thank you for your time and consideration. >Sincerely, >Ian Shih
