5 ms·

Along these lines, would Google be in trouble for Google Sheets, since it can take an excel file and load it?

deleted 9y ago
[deleted]
evv 9y ago
IANAL, but it seems that yes Google could be in trouble there, assuming that the Excel EULA prohibits reverse engineering, and also assuming that Google did actually use Excel to compare the behavior of opening different files. It also depends if Microsoft had published the xls[x] spec, and under what license.
- IMcD23 9y ago
  The specs for the open-XML file formats (the newer XLSX) are open.
  - lucideer 9y ago
    Which means you're permitted to parse the files and handle them according to spec., which is notably different to handling them "exactly as Excel does" (e.g. in cases where the spec. allows implementation variance, which I believe are frequent with OpenXML formats), particularly where Google would be testing with Excel software in order to ape implementation specifics that are absent from the spec. That's the potentially worrying differentiator in this case.
  - hydrogen18 9y ago
    The older specifications are available as well, I don't think they have any specific requirements about their use. I think they called it CDF back then.
- ams6110 9y ago
  Might also be covered by one of the many cross-licensing agreements that no doubt exist between Google and Microsoft.
gaius 9y ago
Nope, newer MS Office products write files as a fully documented XML format. Contrary to popular belief MS never deliberately obfuscated Office files; they were simply a raw dump of the internal objects as they were in memory. So obviously they would change between versions. Which made sense in the days when computers were a lot more resource constrained than they are now. Now with power and memory to spare, they can be encoded and decoded on the fly.
- azinman2 9y ago
  And that xml file is anything but structured in a plain and simple way. To understand it and all it does, it’s be impossible to accomplish in a way that people didn’t load a given file in excel and diff the two. Same for OpenOffice.
  - _asummers 9y ago
    I wonder how much that has to do with excessive amounts of backwards compatibility for existing .xls and .doc files. I imagine a fresh implementation with no respect paid to existing sheets would be much better behaved. Anything that stands out to you as overtly strange in the format worth drawing attention to?
    - rubidium 9y ago
      "excessive" to you is "core user need" to a product manager
    - azinman2 9y ago
      Office is a super giant set of products with a million function, years of versions each their own set of bugs, and decades of files of every kind and subset of features produced by users. I personally have almost never seen another word processing app, for example, 100% successfully load in a non-trivial document from a competitor. It’s just really hard, especially if the features don’t map 1:1, let alone fonts, model of layout, etc. Just the shear number of rendering quirks, subtle differences in math formula implementations, etc would be mind boggling. It’s hard to imagine a more insane (and boring) job. Kudos to Google for getting such impressive compatibility. Must have been insane amounts of man-hours to achieve. They at least have the ability to crawl the web, download docs and xls, and automate comparison. I’m not sure it’s even feasible otherwise.
fcbrooklyn 9y ago
My first task in the industry, in the early 90's, involved writing to excel files. At the time I worked at microsoft, so you'd have thought they'd have given me the super secret documentation to the excel format. Instead, they gave me a book published by microsoft press, describing the BIFF format which is what they'd called the format, apparently dreaming that it might one day become a semi-open standard for spreadsheets. (there was no danger of that ever happening, the format was distilled madness, based on a million performance optimizations) Later they made the format a lot saner, but either way I'm pretty sure google would be fine.
deleted 9y ago
[deleted]

deleted 9y ago

[deleted]

evv 9y ago

IANAL, but it seems that yes Google could be in trouble there, assuming that the Excel EULA prohibits reverse engineering, and also assuming that Google did actually use Excel to compare the behavior of opening different files. It also depends if Microsoft had published the xls[x] spec, and under what license.

IMcD23 9y ago
The specs for the open-XML file formats (the newer XLSX) are open.
- lucideer 9y ago
  Which means you're permitted to parse the files and handle them according to spec., which is notably different to handling them "exactly as Excel does" (e.g. in cases where the spec. allows implementation variance, which I believe are frequent with OpenXML formats), particularly where Google would be testing with Excel software in order to ape implementation specifics that are absent from the spec. That's the potentially worrying differentiator in this case.
- hydrogen18 9y ago
  The older specifications are available as well, I don't think they have any specific requirements about their use. I think they called it CDF back then.
ams6110 9y ago
Might also be covered by one of the many cross-licensing agreements that no doubt exist between Google and Microsoft.

gaius 9y ago

Nope, newer MS Office products write files as a fully documented XML format. Contrary to popular belief MS never deliberately obfuscated Office files; they were simply a raw dump of the internal objects as they were in memory. So obviously they would change between versions. Which made sense in the days when computers were a lot more resource constrained than they are now. Now with power and memory to spare, they can be encoded and decoded on the fly.

azinman2 9y ago
And that xml file is anything but structured in a plain and simple way. To understand it and all it does, it’s be impossible to accomplish in a way that people didn’t load a given file in excel and diff the two. Same for OpenOffice.
- _asummers 9y ago
  I wonder how much that has to do with excessive amounts of backwards compatibility for existing .xls and .doc files. I imagine a fresh implementation with no respect paid to existing sheets would be much better behaved. Anything that stands out to you as overtly strange in the format worth drawing attention to?
  - rubidium 9y ago
    "excessive" to you is "core user need" to a product manager
  - azinman2 9y ago
    Office is a super giant set of products with a million function, years of versions each their own set of bugs, and decades of files of every kind and subset of features produced by users. I personally have almost never seen another word processing app, for example, 100% successfully load in a non-trivial document from a competitor. It’s just really hard, especially if the features don’t map 1:1, let alone fonts, model of layout, etc. Just the shear number of rendering quirks, subtle differences in math formula implementations, etc would be mind boggling. It’s hard to imagine a more insane (and boring) job. Kudos to Google for getting such impressive compatibility. Must have been insane amounts of man-hours to achieve. They at least have the ability to crawl the web, download docs and xls, and automate comparison. I’m not sure it’s even feasible otherwise.

fcbrooklyn 9y ago

My first task in the industry, in the early 90's, involved writing to excel files. At the time I worked at microsoft, so you'd have thought they'd have given me the super secret documentation to the excel format. Instead, they gave me a book published by microsoft press, describing the BIFF format which is what they'd called the format, apparently dreaming that it might one day become a semi-open standard for spreadsheets. (there was no danger of that ever happening, the format was distilled madness, based on a million performance optimizations) Later they made the format a lot saner, but either way I'm pretty sure google would be fine.

deleted 9y ago

[deleted]