https://bugs.documentfoundation.org/show_bug.cgi?id=171552
--- Comment #4 from Thomas Tempelmann <[email protected]> --- Julien's patch is missing the same addition for "vnd.oasis.opendocument.spreadsheet-flat-xml", it seems to me. Also, I think that the "org.openoffice.spreadsheet" should get this entry as well, for completeness. For the rest of the list that Patrick lists, I'm not sure. Are the "-template"-types spreadsheet files, too? Then they should get the new entry as well. And sheet and sheet.macroEnabled? No idea. I'd say: Only add the "public.spreadsheet" to those file types the user would interact with and would consider being spreadsheet files. If a sheet file (which I assume is a single sheet of a spreadsheet that could contain multiple sheets) can also be saved and opened as a spreadsheet, then the type should probably be added there as well. Apart from the Calc types, there'a also other types to consider, but Apple isn't providing much guidance here, so this is more of a FYI: If the file is embedded in a zip file, that type (public.zip-archive) could be added as well, and also the "public.composite-content" might be added to anything that is a hybrid type (like zip + spreadsheet). And all xml file types might also get the "public.xml" type added. But it's a bit confusing where this is adequate and where not. Lastly, for the other types such as "Writer documents", it would be best to look what similar apps from Apple declare, and adopt those. But even Apple seems to not care too much for this, it seems to me. Here's what Pages (their word processor) gives for ".pages" files: <key>UTTypeConformsTo</key> <array> <string>public.zip-archive</string> <string>public.composite-content</string> </array> <key>UTTypeDescription</key> <string>Pages Document</string> <key>UTTypeIconName</key> <string>PagesDocument.icns</string> <key>UTTypeIdentifier</key> <string>com.apple.iwork.pages.sffpages</string> <key>UTTypeTagSpecification</key> <dict> <key>public.filename-extension</key> <array> <string>pages</string> </array> <key>public.mime-type</key> <array> <string>application/x-iwork-pages-sffpages</string> </array> </dict> As you can see, it conforms to the zip and composite types I mentioned above, but doesn't seem to even declare a common "rich text" type. There's "public.text" type, but that's not even used here, sadly. So, this is the usual Apple mess of starting a smart system and then later engineers not paying attention to it any more, possibly due to lack of guidance documents, and the lack of an oversight team, and now we have quite the mess. So, let's just focus on adding the spreadsheet type, but it's a rather small matter. Thanks for listening, though. -- You are receiving this mail because: You are the assignee for the bug.
