OnlyOffice: Free open source office suite with business productivity tools
github.com
github.com
https://github.com/ONLYOFFICE/DesktopEditors
The headless server is Apache, the client and visual elements AGPL, which might be the confusion.
This, however, can easily be legally patched around. It’s more just to make a point that it’s not supported without talking to them about a proper deployment. They also might have some code that is proprietary to make that large deployment easier, but it’s not required as long as you don’t mind the AGPL.
You can actually try this yourself with their NextCloud plugin. LibreOffice also has a cloud version available but it’s… let’s just say, in my opinion, it’s very bad.
As someone who doesn't even know MS Office well enough to know what I'm missing, what's unintuitive about LibreOffice to someone who knows MS Office?
I am not saying that Libreoffice has a worse interface (or really 'unintuitive').. Just more different from MS Office.
In almost all situations where one could use CSV, a better, more structured, more standards-compliant, more optimized file format (like a SQLite database) would be a better choice.
The Library of Congress has a small amount of SQLite files in its collections.
The Library of Congress also cites CSV [2], Comma Separated Values, as strictly specified in RFC 4180 as a acceptable dataset format. No other types of free-form CSV that aren't variants compliant with 4180 are accepted, and it also says that documentation and metadata needs to be supplied with additional separated archives in supported data formats.
The Library of Congress has 0 CSVs in its collections, and as a result no experience actually handling it.
I believe that if a widespread format such as CSVs have 0 files added to a reasonably well known and encompassing collection of human artifacts related to culture even with its ubiquity, it's a telltale sign that it isn't a standard at all.
[1] https://www.loc.gov/preservation/digital/formats/fdd/fdd0004...
[2] https://www.loc.gov/preservation/digital/formats/fdd/fdd0003...
Furthermore, the LoC's job is archiving. Your links have "preservation" in the url for a reason, and "preservation" is not what people do with spreadsheets. To strive for relevance, explore https://data.gov, where CSV is abundant, because it's in use by literally hundreds of state and federal agencies, often by people using spreadsheet software, and will continue to be so for years or decades to come, whether you understand why or not.
edit: Your assertions are wrong anyway, as the LoC does indeed have CSV artifacts in its collection. It is most often in a Zip file and catalogued as "compressed data," which is probably why your perfunctory search did not unearth it. Some random counterexamples to your claim:
https://www.loc.gov/item/2022482299/
https://www.loc.gov/item/2020446966/
I did not conflate database and dataset. I specifically described the two types. The Library of Congress specifically describes the two types.
You decided that "others" think that database and dataset are conflated, and that they are wrong.
> edit: Your assertions are wrong anyway (...) Some random counterexamples to your claim:
It's not my assertion, it's a assertion by the Library of Congress itself. The Library declares that it has no experience directly handling CSV.
> "LC experience or existing holdings": None in relation to collection holdings [1]
> "LC experience or existing holdings": "Report of actual practice at the Library of Congress." [2]
[1] CSV, Comma Separated Values (RFC 4180) - https://www.loc.gov/preservation/digital/formats/fdd/fdd0003...
[2] Format Descriptions: Explanation of Terms, Local Use - https://www.loc.gov/preservation/digital/formats/fdd/fdd_exp...
You asserted that "In almost all situations where one could use CSV" there would be a better choice, and suggested a database format. Aside from weasel words like "almost" making the statement inapplicable, the assertion itself is impracticable, for the reason I discussed, viz. in most situations where one is using CSV, one did not choose the format. Nothing you have said (or, I speculate, can say) contradicts this central point.
Your blathering about the Library of Congress is completely useless, since you appear to extract from a specific datum (the Library of Congress preservationists reporting no preferential experience with the format in relation to their collection) the irrelevant misinformation "The Library of Congress has 0 CSVs in its collections," which has a remarkable combination of qualities, i.e. not only does it have no bearing on the topic of this thread, it is also a lie, or at the very least a mistake borne of an inability or unwillingness to read the text you keep linking.
So in conclusion, nothing you have contributed to this discussion is of use to any office suite user while considering the ease of opening CSV files, and even if the information you have provided were of any utility value, it's not reliable. Congratulations on a perfect record, then, of not helping. I hope for the sake of those around you that your skills at identifying relevance and pursuing accuracy increase markedly and quickly.
The linked GitHub repo clearly says Apache License, but their commercial website does say AGPL. They're not even remotely similar.
The AGPL is regarded as so toxic that nearly all companies where office suites matter, place it on a "do not use" list. It's a good way to artificially limit your potential customers. It doesn't matter that they have a page saying "sure go ahead and use it internally" - most places won't touch it with a 10m pole, by policy.
Perhaps the best feature of the AGPL is that it predominately hampers companies with ineffective legal departments.
AGPL would level the playing field between Google and device manufacturers and on-prem software companies (like Apple and Microsoft).
Of course they don’t want their employees to use and indirectly support that ecosystem!
I wish they’d produce a GPL 4 that is closer to the AGPL. v3 backfired and is severely hurting end-users’ freedom in practice.
Due to their size, they must have one of the best legal department in the world. Also, their core business is search, and data processing in general. They have the means of using such software and doing what it takes to comply with the licence without putting themselves in trouble.
My guess is simply that they don't want to. They prefer to rewrite it, which will allow them to monetize their tools as proprietary software later. They are already overstaffed with some of the best developers, they can rewrite stuff, and they don't really need help from the open source community, that's why they don't release under copyleft themselves.
Viral, perhaps if you integrate a library, but in this case it doesn't make sense, you only need to distribute source code if you modify it. Poisonous makes no sense to me, can you clarify?
https://www.merriam-webster.com/dictionary/poisonous
1. DESTRUCTIVE, HARMFUL
...
3. SPITEFUL, MALICIOUS
In what ways is the GPL or AGPL destructive or harmful or spiteful or malicious? I find it the exact opposite of all those concepts.
I don't typically make my decisions based on what businesses "universally decide" (have they actually?). Most businesses are shareholder or private corporations that find margin between labor and sales; I instead structured a business as a co-op and that seems to be working just fine. Many businesses profit off polluting the environment or selling weapons; I've never worked DoD or O&G (and never will) and lead an extraordinarily comfortable and privileged life regardless. Many content creator businesses lock their content behind paywalls, riddle their sites with ads and tracking; I put up a simple blog in html and css and my audience might be small but they are engaged and are in conversation with me.
I'm not trying to say i'm a special ethical snowflake that's better than everyone else, I'm saying I don't really take it as a given that "businesses doing things in a certain" way really means much of anything at all. In fact I've found often profit correlates with harm (and that businesses often make decisions that don't lead to long, long-term profits but rather pillage themselves for short-term profits), O&G being a great example, so I might even be able to take "businesses do it that way" as a warning to not do it that way or I might be hurting people.
I don't care to continue the conversation where you justify your actions to me, it's just not necessary. I just wish we would stop acting like it's confusing or we don't understand why businesses respond the way that they do when confronted with the decision to use AGPL software.
Maybe it's just a messaging/marketing problem, I don't know.
This is pure fud. Nothing else.
AGPL DOES NOT restrict ability to be used internally. Agpl does NOT restrict selling software as it is.
Agpl does not restrict using agpl software with proprietary software.
Only thing that agpl prevent is, IF YOU MODIFY AGPL SOFTWARE, YOU HAVE TO GIVE SOURCE CODE TO USERS. Your modifications. Thats it.
AGPL DOES NOT MANDATE upstreaming modifications. You can do it or you cannot. Your choice. Others can choose to upstream or fork or Downstream your modifications
What you are confusing with is the fud google spreads about agpl. They dont touch it because if they modify code they have to release it but they don't for reasons known to them.
Again, AGPL is NOT viral like SSPL which is like AGPL but on steroids.
I could be wrong but let's see how wrong I really am.
Though I am not lawyer/license expert so that fact may be irrelevant more so using it as desktop app. But perception matters, if Goog/MSFT are not using it, a startup also won't risk using them lest some auditor flags it in next round of funding particularly if alternative is few dollars a month.
>lest some auditor flags it in next round of funding
i am an auditor and a laywer, so what is there to flag? please enlighten me.
Basically, you if you provide this software as a service to your customers, you are required to let them access the source code and modifications.
the source code of "this" software and any modifications you made. so.... whats the problem?
The problem with AGPL is, that the definitions are very open to interpretation. What is a network, how many systems do have to be between to the end user and the software component to still count as "interacting over a network", etc.
So I would also not recommend to use AGPL in your company...
Edit: we've had to ask you this at least once before: https://news.ycombinator.com/item?id=32387908. Can you please stick to the rules when posting here? We have to ban accounts that won't, and I don't want to ban you.
Then it's no worse than any proprietary software; if they pay for a commercial license then it's fine. Of course, if they use it internally then AGPL is also fine.
But if I had to guess, the major development effort is still done in Russia.
There's an RFP/ITP (Request For Package/Intent To Package) issue for Debian filed in June 2020, but no evidence that any DDs have wanted to pick it up or start working on it. I guess LibreOffice works well enough for all of them that need it.
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=963070
> It's [...] more intuitive than LibreOffice to anyone coming from Microsoft Office.
I've just had a look at some of the OnlyOffice screenshots, and they mostly look like it has a Ribbon-style interface. It might be that Debian devs are mostly old-school enough that LibreOffice's classic menu and toolbars is more similar to the MS Office they used to use than a Ribbon.
That said, LibreOffice does have multiple User Interface variants (accessible from the "View" menu in the standard UI), including a "Tabbed" option that is Ribbon-like if that's more your thing. (And some others, but I've not explored them much.)
There have been various efforts to bring LibreOffice to the web, but I haven’t tested anything in a long time, so I can’t say if it works well.
But those are reasonable answers. I would rather see engineering effort go into fixing bugs in the suite, but I realize that the people volunteering to "Web-enable" the software aren't necessarily the ones who'd be fixing unrelated bugs.
The protocol that connects the office suite to the file sharing platform is called WOPI (https://en.wikipedia.org/wiki/Web_Application_Open_Platform_...). OneDrive/Dropbox/Nextcloud all seem to support it.
Seems like Collabora and OnlyOffice are the two big players right now.
When I open my Word docs in LibreOffice, they still look significantly different than in Word after all these years. In OnlyOffice they look exactly like in Word. So it replaced Word-in-Wine for me.
I remember also looking at WPS Office for this and it seemed mostly okay to me: https://www.wps.com/office/ (though no source code available, at least it doesn't seem so)
Then again, LibreOffice feels like the most trustworthy option out there for me (and is the default in many Linux distros), so I ended up just using that, any drawbacks and all. Nowadays I use LibreOffice on all my computers and have basically gotten rid of MS Office altogether. If I ever need to send someone something that looks consistent across all devices, there's PDF/A.
I've actually used PDFs for presentations as well with no issues, especially after the inconsistencies of LibreOffice Impress and PowerPoint made one of my past presentations look like an utter mess on someone else's computer (fonts/locations were all wrong).
Huh, I've not had that issue with the documents I've worked with in the best part of a decade.
What is it that's different for you? Page layout, text wrapping/length, image support, table formatting? Something else?
What platform are you using, and if you're not on Windows do you have the equivalent-metric Liberation font families installed so that docs which rely on non-redistributable proprietary Microsoft fonts can be rendered properly?
https://blog.documentfoundation.org/blog/2020/09/08/libreoff...
When I need to fill PDF form, Microsoft Edge could work fine.
I did not know was a Russian company so shall now rethink my use.
But wow, I didn't knew OnlyOffice is manage by company in Singapore where I live.
Excerpt via Google translate, though the whole thing might be worth a read via Google translate or ChatGPT or whatnot:
> The majority of OnlyOffice employees are citizens of Russia who are in this country or hold positions in the Latvian and Russian offices at the same time.
> The developers of OnlyOffice in the Russian information space emphasize that the Latvian Ascensio System SIA is a one hundred percent daughter and one hundred percent property of the Russian company NKT. The open database of Lursoft companies registered in Latvia also points to a Russian beneficiary.
Google translate: https://www-epravda-com-ua.translate.goog/publications/2022/... via Reddit https://www.reddit.com/r/privacy/comments/10nqq8m/onlyoffice...
[1] https://www.statista.com/statistics/896181/putin-approval-ra...
[2] https://pace.coe.int/en/news/9191/pace-committee-examines-th...
"liberate us? Why", we are more free here in Ukraine.
Follow up would be: are you free enough to be against the war?
Why did so many Russians flee?
Etc...
Ps. Good luck... It's cruel what is happening now.
A lot of times they are stuck with the recurring why loop.
Same with the conspiracy theorists.
Tbg. Sometimes they do find a farfetched reason that actually makes sense somehow.
The normal rule is that it's too farfetched by then. And you could just say: do you realize how crazy that sounds? What if it's "just" .... x.
Eg. for Elon Musk. He probably believes that Russia would nuke and he's just scared.
Or his business in China is at stake. Which means he's getting hated in the West for something he will already lose in the future...
Simple > conspiracy theory
The Iraq War being the go to example of the West.
[0] https://en.wikipedia.org/wiki/War_crimes_in_the_Russian_inva...
> The Brin family lived in Vienna and Paris while Mikhail Brin secured a teaching position at the University of Maryland with help from Anatole Katok. During this time, the Brin family received support and assistance from the Hebrew Immigrant Aid Society. They arrived in the United States on October 25, 1979.
He is an immigrant. https://en.wikipedia.org/wiki/Sergey_Brin
https://en.wikipedia.org/wiki/Suspicious_deaths_of_Russian_b...
It's an entire category.
Not defending any of the US' wars, but it's a little disingenuous to compare them to the Ukrainian conflict.
So invading and bombing other countries is now fine as long as you don't annex them? Good to know that's how far the goalposts have moved.
That's an absolutely insane comparison.
Police are funded from your taxes to protect you. Countries haven't paid taxes tot he US to come invade/drone strike them.
In your country, do police officers from other countries routinely break into your house to tear it up, steal your shit and beat you up for doing nothing? Sounds more like criminals than police.
https://securingdemocracy.gmfus.org/incident/chinese-serbian...
In all seriousness, America does not pull their weapon to prevent bad things from happening (or at least, not primarily).
The US primarily works through Nato and the UN to intervene in their 'world police' role, but they are happy to start other conflicts without the support of Nato and the UN (see Afghanistan, Iraq, Vietnam, ~~Korea~~).
If the US were really the 'world police', then where were they in Rwanda, in Sudan, in North Korea, in Sri Lanka, in Nigeria, in Myanmar, in DRC, in Ethopia, what are they doing for the Uyghurs, the Rohingyas...
EDIT: see correction from OfSanguineFire, I was wrong about Korea, which was indeed a UN-led intervention.
The US involvement in the Korean War was organized under the nascent UN.[0] "During the course of the war, 22 nations contributed military or medical personnel to UN Command. Although the United States led the UNC and provided the bulk of its troops and funding, all participants formally fought under the auspices of the UN, with the operation classified as a 'UN-led police action'."
But is the annexing part the part that really matters or is it the countless dead and wounded civilians?
Do you mean like not calling it an intervention? It's been sometime, but I don't think the Ukrainians care too much about Russia calling it a “special operation”…
What do you think ethnic Russians abroad are? It's displacing locals with poor rural Russians to try a land grab.
Some people literally wake up suddenly within Russia, since Russia is moving borders 100 m. / night.
It's more likely they'd introduce a security flaw that is hard to detect in the OSS code. If someone finds, they'd just claim it was a security incident which is now fixed (and then they'd move to another masked flaw).
Generally not. Most software does not have reproducible builds, so the checksums would be unlikely to match.
Then build your own binaries. I'm sure the Russian government wouldn't struggle to do this.
Open source == a level of independence from sanctions and foreign government spying.
Suppose that the USA works in the same way, bombing and shelling civilians every day, torturing and raping women and children, launching massive attacks on power plants during winter to freeze the population to death, abducting children from their parents etc. Suppose all this was true. Would it give Russia a moral excuse to do what they are doing?
It then veered towards people saying that actually, it's different when Americans invade countries.
I cannot say if there are still indirect ties to Russia, but the direct ones appear fully severed?
How much time (money no object) would it take for you personally to get any citizenship other than your current one?
How much time (assuming your current level of income) would it take for you personally to get any citizenship other than your current one?
I have done my research. The answer to the first question is 6 months (if advertisements on the black market are true), and the second one is between 5 and 10 years. So please don't blame people based solely on their citizenship.
Sanctions against Russia exist to hurt Russian economy and trade to punish and limit their war capacity. If the money stays outside and does not support the war, then I do not see an issue with a Russian citizen living abroad having an indirect controlling stake.
what has a russian company have to do with the war? tomorrow if usa once again starts a war to decimate another country for petrodolalrs, will you go out of your way and start shunning your own country?
- the Afghanistan invasion was an actual reaction to a direct attack, not a “you are close to joining an opponent alliance”
- in the west people were free to criticize the invasion, while Russians have much to fear if they are anti-war.
The first point is more moral, while both wars are ridiculous, they are different scale of ridiculous, but not important from business perspective.
This is extremely important from a business perspective, as it shows the state heavy arm on its people and therefore its business. If it controls people’s speech, people’s business are under even more control.
So, as a business, you face a much bigger risk depending on some compony from a “controlling state”, then a more free state.
This doesn’t mean that USA/the west, doesn’t use it’s private companies, it’s just a difference on scale, and how easy/entrenched that control is.
Another example, is that many european PMs lost the next election cycle with major reason being supporting that war effort. Also, people were actually allowed to protest. Checkout how russian protests are handled.
Just like even today in eastern eurocountries there are some sons of ex wealthy soviets nicknamed “homo sovietis”, with their soviet themed bars, which are perfectly allowed today, but i wonder what would happened if during their youth they opened a “capitalist/ocidental” bar.
Also Who cares if the people in the west were free to criticize it? It didn't stop the war, and it has absolutely nothing to do with embargoes and boycotts. Absolutely no one in Iraq cares that Americans still had their free speech when they destroyed their country and set them back 30 years
Russia wouldn't suddenly be a fine member of the international community if their government wasn't censoring criticism of the war while still invading Ukraine.
Case in point is "doing business with American/Russian companies" not the evils of war, which are undisputable.
The "freedom" is a very important point when doing any kind of risk assessment of a vendor deal.
> You realize that they did offer to extradite bin Ladin, right?
I did not, thanks for the info.
Also, just to provide a source and details on the extradition offer, they offered to extradite him to a third country for trial which I think is more than reasonable, but the US said that there was no need for proof or process.
>"There's no need to discuss it," Bush said. "We know he's guilty. Just turn him over. … There's nothing to negotiate about. They're harboring a terrorist and they need to turn him over."
So essentially the US and the rest of the world razed a country to the ground because they wanted a man so badly that when the country offered to give that man a fair trial before a third neutral country, the US found that offensive and destroyed them? democracy much?
But to hear that the Talibans were the reasonable or at least negotiating party here is insane.
Software is software, people are people and governments are governments. Stop mixing it all together, it's a hypocrites minefield. If you're feeling so righteous about the countries of who writes your software, just throw your computer out of the window.
While that is true, it is also true, that people can easily be forced by bad acting governments to do things to the software they write.
We don't need to condemn the people in general, but we can still be wary of the product they make, while being in the influence zone of certain governments.
1) There's a difference between a government and people living in that country. If my country does something evil, that doesn't mean you should attack me (personally). The firebombing of Dresden by the allies in WWII is widely considered a war crime since it targeted civilians and killed many little children.
2) With sanctions on this war, I see two valid goals: (1) Regime change (2) Not funding / supporting the war. To be clear: Punishment of people in Russia is not a valid goal for sanctions.
3) With a country doing something evil, simply cutting off ties doesn't have much positive effect (see North Korea).
4) Attacking people simply polarizes them to hate you and supports Putin's message.
5) Even under sanctions, there are constructive ways of engagement. These generally center on communications and cultural engagement. Things like rock-and-roll, Disney, Coca Cola, McDonald's and blue jeans played a pretty significant role in the downfall of the Soviet Union. Trade helped open up China (it's not open, but it's a much freer, nicer place to live than 50 years ago, largely due to people doing business across borders).
My general conclusion here:
1) I don't think we should be buying anything from Russia. That provides money to support the war effort.
2) I don't think we should be exporting anything which can in any way be used to help build weapons (e.g. technology, raw materials, etc.).
3) I'm also on the more extreme end of sending more weapons to Ukraine (much more than we have been).
On the other hand, with Russia, I am fully in favor of scientific engagement (think blue whales and not radar research), educational engagement, cultural engagement, as well as things like open source.
Controversially, I'm also supportive of /selling/ luxury goods to Russia. I don't think it supports the regime in any appreciable way, and a Gucci handbag won't help the war effort. It does bring in Western culture and leads to capital outflow.
This. 20 years ago I read an article that spoke of the Iranian peoples' admiration for American people, while the two governments were actively hating each other. It changed everything about how I perceived other countries. We don't have to be our governments.
> We would like to host ONLYOFFICE ourselves. Is that possible?
> Yes. It is possible to download and compile the source code. Thereafter you can deploy it on your own server. The source code is listed on GitHub and distributed under GNU Affero General Public License terms. For more details see the Server Version Frequently Asked Questions section.
You don't have that with Google Docs or Office 365.
Yes, with open source you can look at the source, but who analyses the whole codebase before compiling anything?
To those who comment on the OSS nature of the product, I would suggest that you ask yourself if you are actually willing to perform security audits of the suite and its updates, or roll the dice and hope that your data doesn't get exfiltrated or corrupted one day. Unlike with software developed in other countries, you can't count on the developers to care about their reputation more than some quick gains. As long as the core of the devteam is in Russia - this is out of their control.
> @ONLYOFFICE, FYI to add bidi-directional support (LTR, RTL and mixed) in Web interface is as simple to add to element dir=auto.
> If I remember correctly, they are using canvas with custom rendering logic. Hence many native browser capabilities might not be available.
Oh, jeez, why? I want to install this just to point a screen reader at it and watch the havoc. Maybe they got that figured out but good lord...
Maybe today you could get something to work using a combination of contenteditable and canvas, with code to handle the inconsistencies between browsers. But I know that at least a few years ago, rendering to a canvas was a necessity for rich web apps like this. Google docs at least used to be canvas based as well. I'm not sure if that is still the case.