diff options
| author | Dennis Francis <dennis.francis@collabora.com> | 2019-06-20 11:59:44 +0530 |
|---|---|---|
| committer | Dennis Francis <dennis.francis@collabora.com> | 2019-06-20 13:18:11 +0200 |
| commit | e324a6cea23fe19ec8a67f368c31e1567928a5af (patch) | |
| tree | cdd593ef7a31a2cadad907660eef14815ea04769 /sc | |
| parent | ea62608195d462f70fa8c09708edaac68752a013 (diff) | |
tdf#126012: Take care of polar and min-magnitude flags...
even in one point case (FOURIER). Add relevant test cases too.
Change-Id: I647ac14ff8e9ee11664b23b37d150f51e6a08354
Reviewed-on: https://gerrit.libreoffice.org/74412
Reviewed-by: Dennis Francis <dennis.francis@collabora.com>
Tested-by: Dennis Francis <dennis.francis@collabora.com>
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/qa/unit/data/functions/array/fods/fourier.fods | 236 | ||||
| -rw-r--r-- | sc/source/core/tool/interpr3.cxx | 8 |
2 files changed, 215 insertions, 29 deletions
diff --git a/sc/qa/unit/data/functions/array/fods/fourier.fods b/sc/qa/unit/data/functions/array/fods/fourier.fods index 789e1bd15f73..91b1aa4d098e 100644 --- a/sc/qa/unit/data/functions/array/fods/fourier.fods +++ b/sc/qa/unit/data/functions/array/fods/fourier.fods @@ -1,20 +1,20 @@ <?xml version="1.0" encoding="UTF-8"?> <office:document 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:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation: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:config="urn:oasis:names:tc:opendocument:xmlns:config: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" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet"> - <office:meta><meta:creation-date>2019-02-19T14:19:02.782037492</meta:creation-date><dc:date>2019-03-03T16:30:38.015797381</dc:date><meta:editing-duration>PT2H52M20S</meta:editing-duration><meta:editing-cycles>66</meta:editing-cycles><meta:generator>LibreOfficeDev/6.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/b4df9b0b4c7411f257b0a397687587114a53208e</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="2175" meta:object-count="0"/></office:meta> + <office:meta><meta:creation-date>2019-02-19T14:19:02.782037492</meta:creation-date><dc:date>2019-06-20T11:49:43.838698519</dc:date><meta:editing-duration>PT3H13M28S</meta:editing-duration><meta:editing-cycles>71</meta:editing-cycles><meta:generator>LibreOfficeDev/6.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/74a7b890524af4a52e711d8f0793ce844ded0948</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="2235" meta:object-count="0"/></office:meta> <office:settings> <config:config-item-set config:name="ooo:view-settings"> <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item> <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item> - <config:config-item config:name="VisibleAreaWidth" config:type="int">20041</config:config-item> - <config:config-item config:name="VisibleAreaHeight" config:type="int">4713</config:config-item> + <config:config-item config:name="VisibleAreaWidth" config:type="int">58208</config:config-item> + <config:config-item config:name="VisibleAreaHeight" config:type="int">25287</config:config-item> <config:config-item-map-indexed config:name="Views"> <config:config-item-map-entry> <config:config-item config:name="ViewId" config:type="string">view1</config:config-item> <config:config-item-map-named config:name="Tables"> <config:config-item-map-entry config:name="Sheet1"> <config:config-item config:name="CursorPositionX" config:type="int">1</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">8</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">17</config:config-item> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -31,8 +31,8 @@ <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> <config:config-item-map-entry config:name="Sheet2"> - <config:config-item config:name="CursorPositionX" config:type="int">0</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">3</config:config-item> + <config:config-item config:name="CursorPositionX" config:type="int">1</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">71</config:config-item> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -41,7 +41,7 @@ <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item> <config:config-item config:name="PositionRight" config:type="int">0</config:config-item> <config:config-item config:name="PositionTop" config:type="int">0</config:config-item> - <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item> + <config:config-item config:name="PositionBottom" config:type="int">44</config:config-item> <config:config-item config:name="ZoomType" config:type="short">0</config:config-item> <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> @@ -49,8 +49,8 @@ <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> <config:config-item-map-entry config:name="Sheet3"> - <config:config-item config:name="CursorPositionX" config:type="int">4</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">39</config:config-item> + <config:config-item config:name="CursorPositionX" config:type="int">3</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">15</config:config-item> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -67,8 +67,8 @@ <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> </config:config-item-map-named> - <config:config-item config:name="ActiveTable" config:type="string">Sheet1</config:config-item> - <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1861</config:config-item> + <config:config-item config:name="ActiveTable" config:type="string">Sheet2</config:config-item> + <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1307</config:config-item> <config:config-item config:name="ZoomType" config:type="short">0</config:config-item> <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> @@ -125,9 +125,9 @@ <config:config-item config:name="EndLine" config:type="string"/> </config:config-item-map-entry> </config:config-item-map-indexed> - <config:config-item config:name="PrinterName" config:type="string">Generic Printer</config:config-item> + <config:config-item config:name="PrinterName" config:type="string">DeskJet-2130-series</config:config-item> <config:config-item config:name="PrinterPaperFromSetup" config:type="boolean">false</config:config-item> - <config:config-item config:name="PrinterSetup" config:type="base64Binary">nwH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAwAAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luZGFqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4RGF0YQpEdXBsZXg6Tm9uZQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==</config:config-item> + <config:config-item config:name="PrinterSetup" config:type="base64Binary">qgH+/0Rlc2tKZXQtMjEzMC1zZXJpZXMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpEZXNrSmV0LTIxMzAtc2VyaWVzAAAAAAAAAAAWAAMAxwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9RGVza0pldC0yMTMwLXNlcmllcwpvcmllbnRhdGlvbj1Qb3J0cmFpdApjb3BpZXM9MQpjb2xsYXRlPWZhbHNlCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MQpjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6QTQASW5wdXRTbG90Ok1haW4AABIAQ09NUEFUX0RVUExFWF9NT0RFEwBEdXBsZXhNb2RlOjpVbmtub3du</config:config-item> <config:config-item config:name="EmbedOnlyUsedFonts" config:type="boolean">false</config:config-item> <config:config-item config:name="ApplyUserData" config:type="boolean">true</config:config-item> <config:config-item config:name="EmbedComplexScriptFonts" config:type="boolean">true</config:config-item> @@ -1624,8 +1624,6 @@ <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Good" style:base-cell-address="Sheet1.B3"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Bad" style:base-cell-address="Sheet1.B3"/> </style:style> <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="#000000"/> @@ -1637,18 +1635,12 @@ <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default"> <style:text-properties fo:color="#3465a4" fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> - <style:map style:condition="cell-content()=1" style:apply-style-name="Good" style:base-cell-address="Sheet2.N2"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Bad" style:base-cell-address="Sheet2.N2"/> - </style:style> + <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="#ffff00"/> <style:text-properties fo:color="#ff0000"/> </style:style> - <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> - <style:map style:condition="cell-content()=1" style:apply-style-name="Good" style:base-cell-address="Sheet3.N2"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Bad" style:base-cell-address="Sheet3.N2"/> - </style:style> + <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> <style:page-layout style:name="pm1"> <style:page-layout-properties style:writing-mode="lr-tb"/> <style:header-style> @@ -1689,7 +1681,7 @@ <text:p><text:sheet-name>???</text:sheet-name><text:s/>(<text:title>???</text:title>)</text:p> </style:region-left> <style:region-right> - <text:p><text:date style:data-style-name="N2" text:date-value="2019-03-03">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="15:46:05.649339134">00:00:00</text:time></text:p> + <text:p><text:date style:data-style-name="N2" text:date-value="2019-06-20">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="11:56:21.139087245">00:00:00</text:time></text:p> </style:region-right> </style:header> <style:header-left style:display="false"/> @@ -1703,6 +1695,7 @@ <office:spreadsheet> <table:calculation-settings table:automatic-find-labels="false" table:use-regular-expressions="false" table:use-wildcards="true"/> <table:table table:name="Sheet1" table:style-name="ta1"> + <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co3" table:default-cell-style-name="Default"/> @@ -1742,7 +1735,7 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Sheet2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" table:formula="of:=AND([Sheet2.$N$2:.$S$52])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce22" table:formula="of:=AND([Sheet2.$N$2:.$S$56])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1768,6 +1761,7 @@ </calcext:conditional-formats> </table:table> <table:table table:name="Sheet2" table:style-name="ta1"> + <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> <table:table-column table:style-name="co4" table:number-columns-repeated="13" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co5" table:default-cell-style-name="ce26"/> <table:table-column table:style-name="co6" table:number-columns-repeated="2" table:default-cell-style-name="ce26"/> @@ -4620,11 +4614,199 @@ <table:table-row table:style-name="ro2"> <table:table-cell table:style-name="ce24" table:number-columns-repeated="12"/> <table:table-cell/> - <table:table-cell table:style-name="Default" table:number-columns-repeated="6"/> + <table:table-cell table:formula="of:=IF(ISBLANK([.$C53]); 1; ABS([.$C53]-[.$E53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$D53]); 1; ABS([.$D53]-[.$F53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$G53]); 1; ABS([.$G53]-[.$I53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$H53]); 1; ABS([.$H53]-[.$J53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$K53]); 1; ABS([.$K53]-[.$A53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$L53]); 1; ABS([.$L53]-[.$B53])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + </table:table-row> + <table:table-row table:style-name="ro2"> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A54:.B54];1)" office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A54:.B54];1;;1)" office:value-type="float" office:value="0.5" calcext:value-type="float"> + <text:p>0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="3.14159265358979" calcext:value-type="float"> + <text:p>3.14159265358979</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=SQRT([.C54]*[.C54]+[.D54]*[.D54])" office:value-type="float" office:value="0.5" calcext:value-type="float"> + <text:p>0.5</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=ATAN2([.C54];[.D54])" office:value-type="float" office:value="3.14159265358979" calcext:value-type="float"> + <text:p>3.14159265358979</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.C54:.D54];1;1)" office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell/> + <table:table-cell table:formula="of:=IF(ISBLANK([.$C54]); 1; ABS([.$C54]-[.$E54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$D54]); 1; ABS([.$D54]-[.$F54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$G54]); 1; ABS([.$G54]-[.$I54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$H54]); 1; ABS([.$H54]-[.$J54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$K54]); 1; ABS([.$K54]-[.$A54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$L54]); 1; ABS([.$L54]-[.$B54])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + </table:table-row> + <table:table-row table:style-name="ro2"> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A55:.B55];1)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A55:.B55];1;;1)" office:value-type="float" office:value="0.5" calcext:value-type="float"> + <text:p>0.5</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-1.5707963267949" calcext:value-type="float"> + <text:p>-1.5707963267949</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=SQRT([.C55]*[.C55]+[.D55]*[.D55])" office:value-type="float" office:value="0.5" calcext:value-type="float"> + <text:p>0.5</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=ATAN2([.C55];[.D55])" office:value-type="float" office:value="-1.5707963267949" calcext:value-type="float"> + <text:p>-1.5707963267949</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.C55:.D55];1;1)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.5" calcext:value-type="float"> + <text:p>-0.5</text:p> + </table:table-cell> + <table:table-cell/> + <table:table-cell table:formula="of:=IF(ISBLANK([.$C55]); 1; ABS([.$C55]-[.$E55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$D55]); 1; ABS([.$D55]-[.$F55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$G55]); 1; ABS([.$G55]-[.$I55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$H55]); 1; ABS([.$H55]-[.$J55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$K55]); 1; ABS([.$K55]-[.$A55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$L55]); 1; ABS([.$L55]-[.$B55])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + </table:table-row> + <table:table-row table:style-name="ro2"> + <table:table-cell office:value-type="float" office:value="0.003" calcext:value-type="float"> + <text:p>0.003</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.0002" calcext:value-type="float"> + <text:p>-0.0002</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A56:.B56];1)" office:value-type="float" office:value="0.003" calcext:value-type="float"> + <text:p>0.003</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.0002" calcext:value-type="float"> + <text:p>-0.0002</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0.003" calcext:value-type="float"> + <text:p>0.003</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.0002" calcext:value-type="float"> + <text:p>-0.0002</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.A56:.B56];1;;1;0.01)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=ORG.LIBREOFFICE.FOURIER([.C56:.D56];1;1)" office:value-type="float" office:value="0.003" calcext:value-type="float"> + <text:p>0.003</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="-0.0002" calcext:value-type="float"> + <text:p>-0.0002</text:p> + </table:table-cell> + <table:table-cell/> + <table:table-cell table:formula="of:=IF(ISBLANK([.$C56]); 1; ABS([.$C56]-[.$E56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$D56]); 1; ABS([.$D56]-[.$F56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$G56]); 1; ABS([.$G56]-[.$I56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$H56]); 1; ABS([.$H56]-[.$J56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$K56]); 1; ABS([.$K56]-[.$A56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:formula="of:=IF(ISBLANK([.$L56]); 1; ABS([.$L56]-[.$B56])<[.$U$1])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <calcext:conditional-formats> - <calcext:conditional-format calcext:target-range-address="Sheet2.N2:Sheet2.S52"> + <calcext:conditional-format calcext:target-range-address="Sheet2.N2:Sheet2.S56"> <calcext:condition calcext:apply-style-name="Good" calcext:value="=1" calcext:base-cell-address="Sheet2.N2"/> <calcext:condition calcext:apply-style-name="Bad" calcext:value="=0" calcext:base-cell-address="Sheet2.N2"/> </calcext:conditional-format> diff --git a/sc/source/core/tool/interpr3.cxx b/sc/source/core/tool/interpr3.cxx index 9dffa0d11b28..85eb4b7167a4 100644 --- a/sc/source/core/tool/interpr3.cxx +++ b/sc/source/core/tool/interpr3.cxx @@ -5360,8 +5360,12 @@ ScMatrixRef ScFFT::Compute(std::function<ScMatrixGenerator>& rMatGenFunc) SCSIZE nPoints = mbReal ? aArray.size() : (aArray.size()/2); if (nPoints == 1) { - mpInputMat->Resize(2, 1, 0.0); - return mpInputMat; + std::vector<double> aOutArray(2); + aOutArray[0] = aArray[0]; + aOutArray[1] = mbReal ? 0.0 : aArray[1]; + if (mbPolar) + lcl_convertToPolar(aOutArray, mfMinMag); + return rMatGenFunc(2, 1, aOutArray); } if (mbReal && (nPoints % 2) == 0) |