Я уже писал на эту тему, но то ли у всех все работает нормально, то ли
подобное поведение Calc считают правильным; ответа не получено.

-------- Исходное сообщение --------
Тема: Re: [oodisc] удалить содержимое - Calc - Правка
Дата: Wed, 22 Nov 2006 15:21:43 +0300
От: Герман Тимонин <[EMAIL PROTECTED]>
Отвечать: [email protected]
Кому: [email protected]
Ссылки: <[EMAIL PROTECTED]>     <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>     <[EMAIL PROTECTED]>

Уважаемое сообщество!

Я считаю, что данная поведение Calc ошибочно (поправьте меня) в плане
выполнения команд Удалить содержимое, Формат ячеек -> Числа, Формат по
образцу

См. вложенный документ:
1. При выполнении команды Удалить формат - формат Должен удаляться -
этого не происходит
2. При выполнении Формат ячеек -> Числа - содержимое должно превращаться
в число (если это конечно возможно) указанного формата - не происходит,
остается строкой
3. Аналогично п.2
4. При выполнении Формат по умолчанию - должно происходить "Удаление из
выделения прямого форматирования" (из справки) - это действительно
происходит

Я полез внутрь Calc-документа и вот что выяснил:

1. Так представляется наша галимая ячейка (16.12.1952) с которой
ничего-то нельзя поделать
- <table:table-cell table:style-name="ce2" office:value-type="string">
- <text:p>
  <text:span text:style-name="T3">16.</text:span>
  <text:span text:style-name="T4">12.1952</text:span>
  </text:p>
  </table:table-cell>

2. Такой она должна быть
- <table:table-cell table:style-name="ce4" office:value-type="date"
office:date-value="1952-12-16">
  <text:p>вторник 16 Декабрь, 1952</text:p>
  </table:table-cell>


Прошу поддержки для грамотного информирования о перечисленных проблемах
разработчиков.


Инструменты:
Windows 2000, OpenOffice 2.04 (Инфра), TotalCommanter 6.53, плагин к
тоталу ResExtract

Приложенные файлы:
ПлохаяДата.ods - проведенный эксперимент
ПлохаяДата_content.xml - xml содержимое этого файла



-- 
С уважением,
Герман Тимонин
mailto:[EMAIL PROTECTED]
ICQ  #108944662

<?xml version="1.0" encoding="UTF-8"?>

<office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink"; xmlns:dc="http://purl.org/dc/elements/1.1/"; xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML"; xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office"; xmlns:ooow="http://openoffice.org/2004/writer"; xmlns:oooc="http://openoffice.org/2004/calc"; xmlns:dom="http://www.w3.org/2001/xml-events"; xmlns:xforms="http://www.w3.org/2002/xforms"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; office:version="1.0">
 <office:scripts/>
 <office:font-face-decls>
  <style:font-face style:name="F" svg:font-family="" style:font-family-generic="roman"/>
  <style:font-face style:name="Arial1" svg:font-family="Arial" style:font-family-generic="swiss"/>
  <style:font-face style:name="Times New Roman" svg:font-family="&apos;Times New Roman&apos;" style:font-adornments="Обычный" style:font-family-generic="roman" style:font-pitch="variable"/>
  <style:font-face style:name="Arial" svg:font-family="Arial" style:font-family-generic="swiss" style:font-pitch="variable"/>
  <style:font-face style:name="Arial Unicode MS1" svg:font-family="&apos;Arial Unicode MS&apos;" style:font-family-generic="swiss" style:font-pitch="variable"/>
  <style:font-face style:name="Tahoma1" svg:font-family="Tahoma" style:font-family-generic="swiss" style:font-pitch="variable"/>
  <style:font-face style:name="Arial Unicode MS" svg:font-family="&apos;Arial Unicode MS&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
  <style:font-face style:name="Tahoma" svg:font-family="Tahoma" style:font-family-generic="system" style:font-pitch="variable"/>
 </office:font-face-decls>
 <office:automatic-styles>
  <style:style style:name="co1" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="2.267cm"/>
  </style:style>
  <style:style style:name="co2" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="2.801cm"/>
  </style:style>
  <style:style style:name="co3" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="4.44cm"/>
  </style:style>
  <style:style style:name="co4" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="6.465cm"/>
  </style:style>
  <style:style style:name="co5" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="10.433cm"/>
  </style:style>
  <style:style style:name="co6" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="3.634cm"/>
  </style:style>
  <style:style style:name="ro1" style:family="table-row">
   <style:table-row-properties style:row-height="0.453cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ro2" style:family="table-row">
   <style:table-row-properties style:row-height="1.131cm" fo:break-before="auto" style:use-optimal-row-height="false"/>
  </style:style>
  <style:style style:name="ro3" style:family="table-row">
   <style:table-row-properties style:row-height="1.316cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ro4" style:family="table-row">
   <style:table-row-properties style:row-height="2.154cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ro5" style:family="table-row">
   <style:table-row-properties style:row-height="0.885cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ro6" style:family="table-row">
   <style:table-row-properties style:row-height="0.974cm" fo:break-before="auto" style:use-optimal-row-height="false"/>
  </style:style>
  <style:style style:name="ro7" style:family="table-row">
   <style:table-row-properties style:row-height="0.473cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
   <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
  </style:style>
  <number:date-style style:name="N39" number:automatic-order="true">
   <number:day/>
   <number:text> </number:text>
   <number:month number:textual="true"/>
   <number:text>, </number:text>
   <number:year/>
  </number:date-style>
  <number:date-style style:name="N75" number:automatic-order="true">
   <number:day/>
   <number:text> </number:text>
   <number:month number:textual="true"/>
   <number:text>, </number:text>
   <number:year number:style="long"/>
  </number:date-style>
  <number:text-style style:name="N100">
   <number:text-content/>
  </number:text-style>
  <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="wrap"/>
  </style:style>
  <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
  </style:style>
  <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" style:vertical-align="middle"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:text-properties fo:font-weight="bold"/>
  </style:style>
  <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="no-wrap"/>
  </style:style>
  <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="wrap"/>
  </style:style>
  <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" style:vertical-align="middle"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:text-properties fo:font-weight="bold"/>
  </style:style>
  <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="wrap"/>
   <style:text-properties style:font-name="Times New Roman" fo:font-size="8pt"/>
  </style:style>
  <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="wrap"/>
   <style:text-properties style:font-name="Arial1" fo:font-size="6pt" fo:font-weight="bold" style:font-name-asian="Arial Unicode MS1" style:font-name-complex="Tahoma1" style:font-size-complex="6.80000019073486pt"/>
  </style:style>
  <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="wrap"/>
   <style:text-properties style:font-name="Times New Roman" fo:font-size="8pt" fo:font-weight="bold" style:font-name-asian="Arial Unicode MS1" style:font-name-complex="Tahoma1" style:font-size-complex="6.80000019073486pt"/>
  </style:style>
  <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N75">
   <style:table-cell-properties fo:wrap-option="wrap"/>
   <style:text-properties style:font-name="Arial1" fo:font-size="6pt" fo:language="en" fo:country="US" fo:font-weight="bold" style:font-name-asian="Arial Unicode MS1" style:font-name-complex="Tahoma1" style:font-size-complex="6.80000019073486pt"/>
  </style:style>
  <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N39"/>
  <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N100">
   <style:table-cell-properties fo:wrap-option="wrap"/>
  </style:style>
  <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N100">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" style:vertical-align="middle"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:text-properties fo:font-weight="bold"/>
  </style:style>
  <style:style style:name="T1" style:family="text">
   <style:text-properties style:use-window-font-color="true" style:font-name="Arial1" fo:font-size="6pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:font-weight="bold" style:font-name-asian="Arial Unicode MS1" style:language-asian="ru" style:country-asian="RU" style:font-name-complex="Tahoma1" style:font-size-complex="6.80000019073486pt"/>
  </style:style>
  <style:style style:name="T2" style:family="text">
   <style:text-properties style:use-window-font-color="true" style:font-name="Arial1" fo:font-size="6pt" fo:language="ru" fo:country="RU" fo:font-style="normal" fo:font-weight="bold" style:font-name-asian="Arial Unicode MS1" style:language-asian="ru" style:country-asian="RU" style:font-name-complex="Tahoma1" style:font-size-complex="6.80000019073486pt"/>
  </style:style>
 </office:automatic-styles>
 <office:body>
  <office:spreadsheet>
   <table:calculation-settings table:use-regular-expressions="false"/>
   <table:table table:name="Лист1" table:style-name="ta1" table:print="false">
    <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
    <table:table-column table:style-name="co1" table:default-cell-style-name="ce1"/>
    <table:table-column table:style-name="co2" table:default-cell-style-name="ce2"/>
    <table:table-column table:style-name="co3" table:default-cell-style-name="ce5"/>
    <table:table-column table:style-name="co4" table:default-cell-style-name="ce12"/>
    <table:table-column table:style-name="co5" table:default-cell-style-name="ce12"/>
    <table:table-column table:style-name="co6" table:default-cell-style-name="ce1"/>
    <table:table-column table:style-name="co1" table:number-columns-repeated="250" table:default-cell-style-name="ce1"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:number-columns-repeated="256"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell/>
     <table:table-cell table:style-name="ce3" office:value-type="string">
      <text:p>№ эксперимента</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce6" office:value-type="string">
      <text:p>Результат</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce13" office:value-type="string">
      <text:p>Действие</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce13" office:value-type="string">
      <text:p>Внутреннее содержимое документа</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro3">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="1">
      <text:p>1</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce7" office:value-type="date" office:date-value="1994-03-18">
      <text:p>18 мар, 1994</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>Так должно быть</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce3&quot; office:value-type=&quot;date&quot; office:date-value=&quot;1994-03-18&quot;&gt;</text:p>
      <text:p>&lt;text:p&gt;18 мар, 1994&lt;/text:p&gt;</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro4">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="2">
      <text:p>2</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce8" office:value-type="string">
      <text:p><text:span text:style-name="T1">16.</text:span><text:span text:style-name="T2">12.1952</text:span></text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Бедовая» дата – такая исходная ячейка</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce5&quot; office:value-type=&quot;string&quot;&gt;</text:p>
      <text:p>&lt;text:p&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T1&quot;&gt;16.&lt;/text:span&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T2&quot;&gt;12.1952&lt;/text:span&gt;</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro4">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="3">
      <text:p>3</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce9" office:value-type="string">
      <text:p><text:span text:style-name="T1">16.</text:span><text:span text:style-name="T2">12.1952</text:span></text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>Форматировать по образцу – образец в ячейка C3</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce6&quot; office:value-type=&quot;string&quot;&gt;</text:p>
      <text:p>&lt;text:p&gt;</text:p>
      <text:p>&lt;text:span text:style-name=&quot;T1&quot;&gt;16.&lt;/text:span&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T2&quot;&gt;12.1952&lt;/text:span&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro4">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="4">
      <text:p>4</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce8" office:value-type="string">
      <text:p><text:span text:style-name="T1">16.</text:span><text:span text:style-name="T2">12.1952</text:span></text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Удалить содержимое» (Формулы Примечания, Форматы, Объекты)</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce5&quot; office:value-type=&quot;string&quot;&gt;</text:p>
      <text:p>&lt;text:p&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T1&quot;&gt;16.&lt;/text:span&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T2&quot;&gt;12.1952&lt;/text:span&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro5">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="5">
      <text:p>5</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>16.12.1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Форматирование по умолчанию»</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell office:value-type=&quot;string&quot;&gt; </text:p>
      <text:p>&lt;text:p&gt;16.12.1952&lt;/text:p&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro3">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="6">
      <text:p>6</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="date" office:date-value="1952-12-16">
      <text:p>16 дек, 1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Форматирование по умолчанию» + ручное удаление знака &apos;</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell office:value-type=&quot;date&quot; office:date-value=&quot;1952-12-16&quot;&gt; </text:p>
      <text:p>&lt;text:p&gt;16 дек, 1952&lt;/text:p&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro6">
     <table:table-cell/>
     <table:table-cell table:style-name="ce4" office:value-type="string">
      <text:p>Теперь редактируем внутренний XML:</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="Default"/>
     <table:table-cell table:number-columns-repeated="253"/>
    </table:table-row>
    <table:table-row table:style-name="ro4">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="7">
      <text:p>7</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce8" office:value-type="string">
      <text:p><text:span text:style-name="T1">16.</text:span><text:span text:style-name="T2">12.1952</text:span></text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>Исходная ячейка</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce5&quot; office:value-type=&quot;string&quot;&gt;</text:p>
      <text:p>&lt;text:p&gt;</text:p>
      <text:p>&lt;text:span text:style-name=&quot;T1&quot;&gt;16.&lt;/text:span&gt; </text:p>
      <text:p>&lt;text:span text:style-name=&quot;T2&quot;&gt;12.1952&lt;/text:span&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro7">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="8">
      <text:p>8</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce10" office:value-type="string">
      <text:p>16.12.1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>правим xml, уже появился &apos;</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;text:span text:style-name=&quot;T1&quot;&gt;16.12.1952&lt;/text:span&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro7">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="9">
      <text:p>9</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce10" office:value-type="string">
      <text:p>16.12.1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>открыл-сохранил-закрыл</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;text:p&gt;16.12.1952&lt;/text:p&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro7">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="10">
      <text:p>10</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce10" office:value-type="string">
      <text:p>17.12.1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«растянуто» из предыдущей ячейки</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;text:p&gt;17.12.1952&lt;/text:p&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro3">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="11">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce10"/>
     <table:table-cell office:value-type="string">
      <text:p>редактирование xml: office:value-type=&quot;data&quot; (вместо string)</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce10&quot; office:value-type=&quot;data&quot;&gt; </text:p>
      <text:p>&lt;text:p&gt;17.12.1952&lt;/text:p&gt; </text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro7">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="12">
      <text:p>12</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce10" office:value-type="date" office:date-value="1952-12-17">
      <text:p>17 дек, 1952</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>редактирование xml</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>office:value-type=&quot;date&quot; office:date-value=&quot;1952-12-17&quot;</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro3">
     <table:table-cell/>
     <table:table-cell office:value-type="float" office:value="13">
      <text:p>13</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="Default" office:value-type="float" office:value="19345">
      <text:p>19345</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Форматирование по умолчанию» + «Удаление содержимого»</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;Default&quot; office:value-type=&quot;float&quot; office:value=&quot;19345&quot;&gt; </text:p>
      <text:p>&lt;text:p&gt;19345&lt;/text:p&gt;</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro3">
     <table:table-cell/>


     <table:table-cell office:value-type="float" office:value="14">
      <text:p>14</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce11" office:value-type="date" office:date-value="1952-12-17">
      <text:p>17 дек, 52</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>«Формат ячейки» - тип Дата</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string">
      <text:p>&lt;table:table-cell table:style-name=&quot;ce11&quot; office:value-type=&quot;date&quot; office:date-value=&quot;1952-12-17&quot;&gt; </text:p>
      <text:p>&lt;text:p&gt;17 дек, 52&lt;/text:p&gt;</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="251"/>
    </table:table-row>
    <table:table-row table:style-name="ro1" table:number-rows-repeated="2">
     <table:table-cell table:number-columns-repeated="2"/>
     <table:table-cell table:style-name="ce10"/>
     <table:table-cell table:number-columns-repeated="253"/>
    </table:table-row>
    <table:table-row table:style-name="ro1" table:number-rows-repeated="65516">
     <table:table-cell table:number-columns-repeated="256"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:number-columns-repeated="256"/>
    </table:table-row>
   </table:table>
   <table:table table:name="Лист2" table:style-name="ta1" table:print="false">
    <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell/>
    </table:table-row>
   </table:table>
   <table:table table:name="Лист3" table:style-name="ta1" table:print="false">
    <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell/>
    </table:table-row>
   </table:table>
  </office:spreadsheet>
 </office:body>
</office:document-content>

Attachment: binS3tazv9f2L.bin
Description: application/vnd.oasis.opendocument.spreadsheet

_____________________________________________________
Oo-discuss mailing list
Oo-discuss at openoffice.ru
https://lists.openoffice.ru/mailman/listinfo/oo-discuss

Ответить