<?xml version="1.0" encoding="UTF-8"?> <!-- * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> <helpdocument version="1.0"> <meta> <topic id="textscalcguidehtml_docxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Saving and Opening Sheets in HTML</title> <filename>/text/scalc/guide/html_doc.xhp</filename> </topic> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150542"><bookmark_value>HTML; sheets</bookmark_value> <bookmark_value>sheets; HTML</bookmark_value> <bookmark_value>saving; sheets in HTML</bookmark_value> <bookmark_value>opening; sheets in HTML</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="html_doc"><link href="text/scalc/guide/html_doc.xhp" name="Saving and Opening Sheets in HTML">Saving and Opening Sheets in HTML</link> </variable></paragraph> <paragraph role="heading" id="hd_id3154124" xml-lang="en-US" level="2" l10n="U" oldref="2">Saving Sheets in HTML</paragraph> <paragraph role="paragraph" id="par_id3145785" xml-lang="en-US" l10n="U" oldref="3"> <item type="productname">%PRODUCTNAME</item> Calc saves all the sheets of a Calc document together as an HTML document. At the beginning of the HTML document, a heading and a list of hyperlinks are automatically added which lead to the individual sheets within the document.</paragraph> <paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="4">Numbers are shown as written. In addition, in the <SDVAL> HTML tag, the exact internal number value is written so that after opening the HTML document with <item type="productname">%PRODUCTNAME</item> you know you have the exact values.</paragraph> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="5">To save the current Calc document as HTML, choose <emph>File - Save As</emph>.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3148645" xml-lang="en-US" l10n="CHG" oldref="6">In the <emph>File type</emph> list box, in the area with the other <item type="productname">%PRODUCTNAME</item> Calc filters, choose the file type "HTML Document (<item type="productname">%PRODUCTNAME</item> Calc)".</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3154729" xml-lang="en-US" l10n="U" oldref="7">Enter a <emph>File name</emph> and click <emph>Save</emph>.</paragraph> </listitem> </list> <paragraph role="heading" id="hd_id3149379" xml-lang="en-US" level="2" l10n="U" oldref="8">Opening Sheets in HTML</paragraph> <paragraph role="paragraph" id="par_id3149959" xml-lang="en-US" l10n="CHG" oldref="10"> <item type="productname">%PRODUCTNAME</item> offers various filters for opening HTML files, which you can select under <emph>File - Open</emph> in the <emph>Files of type</emph> list box:</paragraph> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="15">Choose the file type "HTML Document (<item type="productname">%PRODUCTNAME</item> Calc)" to open in <item type="productname">%PRODUCTNAME</item> Calc.</paragraph> <paragraph role="listitem" id="par_id3155446" xml-lang="en-US" l10n="U" oldref="16">All <item type="productname">%PRODUCTNAME</item> Calc options are now available to you. However, not all options that <item type="productname">%PRODUCTNAME</item> Calc offers for editing can be saved in HTML format.</paragraph> </listitem> </list> <section id="relatedtopics"> <embed href="text/simpress/guide/html_export.xhp#html_export"/> <embed href="text/swriter/guide/send2html.xhp#send2html"/> <embed href="text/scalc/guide/webquery.xhp#webquery"/> <paragraph role="paragraph" id="par_id3150370" xml-lang="en-US" l10n="U" oldref="17"><link href="text/shared/01/01020000.xhp" name="File - Open">File - Open</link></paragraph> <paragraph role="paragraph" id="par_id3150199" xml-lang="en-US" l10n="U" oldref="18"><link href="text/shared/01/01070000.xhp" name="File - Save As">File - Save As</link></paragraph> </section> </body> </helpdocument>