summaryrefslogtreecommitdiff
path: root/sc
AgeCommit message (Collapse)AuthorFilesLines
2015-03-13import the document properties before the documentMarkus Mohrhard1-12/+12
That allows us to potentially change the import depending on the producer of the document. This becomes necessary to handle MSO 2007 chart drawingml streams correctly. (cherry picked from commit a2fa9e2468aa5c4fd4b610c5d0ebc8959e87a072) Conflicts: sc/source/filter/oox/excelfilter.cxx Conflicts: sc/source/filter/oox/excelfilter.cxx Change-Id: I9be8b019fae69cd206203591982a89648965692f
2015-03-09Resolves tdf#80137 Paste array formula into range pastes as non-array formulaHenry Castro3-2/+72
Reviewed-on: https://gerrit.libreoffice.org/14770 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Andras Timar <andras.timar@collabora.com> (cherry picked from commit 097a16b59884c777f724cec6c5d42734974ed44b) Conflicts: sc/qa/unit/ucalc.cxx sc/qa/unit/ucalc.hxx Change-Id: I500008b32e5af07702b76afb901a3ec270453462
2015-03-05Resolves tdf#78221 Cannot drag twice the same cell when editing formulaHenry Castro3-6/+56
Change-Id: I69402778e68a2955bdda1ba2c9d31d9b10fb60cc Reviewed-on: https://gerrit.libreoffice.org/14748 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Andras Timar <andras.timar@collabora.com> (cherry picked from commit 3381cb4a421bf390445b7dac9ea42f9ccaf3d875)
2015-03-05Resolves tdf#84012 FORMATTING: Partially missing text in shrink-to-fit cellsHenry Castro1-0/+4
Change-Id: I32f44acbcf5a6aed4d9f7442ad7212af31073352 Reviewed-on: https://gerrit.libreoffice.org/14723 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Andras Timar <andras.timar@collabora.com> (cherry picked from commit 4acffa65b58c8bd359215345dca2c61e2c5ceba5)
2015-03-04tdf#89679 - fix incorrect mapping of font-family-complex and CharFontNameAsianMark Hung1-1/+1
Change-Id: I4adad1675f2a880e14ed870a3c74e43e8898c371 Reviewed-on: https://gerrit.libreoffice.org/14663 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit cda9ae79e58d861a85128d6a37587b633b956aae) Reviewed-on: https://gerrit.libreoffice.org/14668 (cherry picked from commit ce7a2502810615b64e83036211e6149313604fff)
2015-03-04Resolves: tdf#81659 handle expand reference edge correctlyEike Rathke3-6/+158
split formula grouping for reference edge expansion, tdf#81659 related Edge expansion may change expressions individually, which must be split off the group. (cherry picked from commit 0cd15b4494f8e8abe67a258fb10189135bf5a8ac) tdf#81659 check that references are at least 2 cols/rows to expand edge Needs also 0cd15b4494f8e8abe67a258fb10189135bf5a8ac if edges are to be expanded and formula grouping is affected. (cherry picked from commit 23b0112ecea2f8796a4e237e9061de1a36997a30) Backported. b3cee8dd214d216907248316a2ac5a290399b169 Change-Id: Id4328bd8c42f2ff9f83d2edc845537971f3a39d3 Reviewed-on: https://gerrit.libreoffice.org/14656 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit 58deeaea725eca0e8140b09420d5144d5d3f800c)
2015-03-04Resolves: tdf#89484 check that sheet reference is within selected sheetsEike Rathke1-0/+4
Change-Id: I88f1d0a134ffa3fbb9a5b5abdabbd4774f457e81 (cherry picked from commit 5803c76f318b2a8b655bf83a8257f60cd112ac71) Reviewed-on: https://gerrit.libreoffice.org/14610 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 8a0712e79a53c057e4a337c5b8570262dc5a33de)
2015-02-23tdf#89460 test pChangeTrack before using itLaurent Godard1-2/+5
Reviewed-on: https://gerrit.libreoffice.org/14553 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit bf5c5f359cf4eb36a0a9a1110ec2aa3393bb87df) Conflicts: sc/source/ui/docshell/docsh4.cxx Change-Id: Ic02351c448929daa7d4c5a9a00df9842c2c5aa91 Reviewed-on: https://gerrit.libreoffice.org/14558 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit bf57bbef91bc40090561d614e4c2070c01aef7cb)
2015-02-23Resolves: tdf#39316 add matrix empty cells to ScInterpreter::QueryMatrixType()Eike Rathke3-7/+35
(cherry picked from commit eccbc97c7c224269fe261b8924e7866c3758ec91) add ScMatrix::IsEmptyResult() for tdf#39316 fix preparation (cherry picked from commit cf3f1d8dfeb45249eb60a30dba3243fe9a4a65e5) 9f2a3e6fa9f4ef43df672661afef996269b90a7a Change-Id: Ifa5d59e90afcfff66f2e8683fac2a9090ed615da Reviewed-on: https://gerrit.libreoffice.org/14430 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 5b952ced5b2ae6151079206c3e397de653f0ced2)
2015-02-23fix windows buildMarkus Mohrhard1-1/+1
Change-Id: Ifad245fac92e5e94347da3e5ac01ff3ba0a8c50b (cherry picked from commit 863c5e9e4b6ff1e4311665485d9e5ff2c08421d8)
2015-02-23tdf#68117 Partially fix boolean labels in XLSXUrsache Vladimir1-1/+1
Change-Id: I731a58c7749e157f6b40c60808687ce629683742 Reviewed-on: https://gerrit.libreoffice.org/14410 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 9c0910765954fba7611611befc1d42ab19d010ef)
2015-02-23tdf#89330 preserve file name case in an unresolvable external named rangeJan Kantert4-4/+40
Reviewed-on: https://gerrit.libreoffice.org/14474 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 0a9e7293a570da8a36b2ac4fd1c4a22d6bc084f2) add unittest for tdf#89330 Reviewed-on: https://gerrit.libreoffice.org/14473 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit e4882717f3dc0375e113ed692374870ab8302a16) 4c5c65733700e7e7245e96f85714221acf23bcfb Change-Id: Ib8728a4a9c793b162de07a0cef66e242879f2aa1 Reviewed-on: https://gerrit.libreoffice.org/14483 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit c261beb79c56faf86dcae7d9cf092b11e1b8c66e)
2015-02-23tdf#88576 fix handling of empty arguments in IF(), IFERROR() and IFNA()Winfried Donkers2-3/+8
Reviewed-on: https://gerrit.libreoffice.org/14415 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 0b75eda1090f92adc678ceff2565da2dc7d9328c) tdf#88576 check that two parameters are given for IFERROR() and IFNA() Otherwise the functions failed only for the error case resulting in #NULL! error. (cherry picked from commit 6583f4e30015164af4972921b5bb7880dfb65f65) eb987637698ab418fc0a60cd873e23878c9f497b Change-Id: I8acca26cf7398768a9e25f97f3a9e61754ab2179 Reviewed-on: https://gerrit.libreoffice.org/14423 Tested-by: Eike Rathke <erack@redhat.com> Reviewed-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 14b76ff3a98898fcccfa6e48ca8ae1e7bea802e2)
2015-02-23Resolves: tdf#83461 do not override MatColsRows if already setEike Rathke1-1/+1
ScMatrixFormulaCellToken::SetMatColsRows() via ScFormulaCell::SetMatColsRows() is used during document import and preselected cell area input of an array formula. Do not override existing values with subsequent result matrix dimensions. Change-Id: I9e844b5064ea276f3cbcb680eb1127c344328e00 (cherry picked from commit e32eff2bb4c12fdc33e476b9f12bb4bb71d22ebc) Reviewed-on: https://gerrit.libreoffice.org/14355 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit cd1f5a81b7602040a7c88b30fd8dbde844fa2f71)
2015-02-23tdf#79239: make the dialog closable with 'X' button againKatarina Behrens2-2/+8
that one of window manager, top-right corner mostly. We need to reimplement Close() method for this class - I don't quite get why this has to be the case, but all classes derived from ScAnyRefDlg do it as well. Change-Id: I3e94b7ee09f9b3581d054818d36ea4fb0fd55f78 (cherry picked from commit bd472c8a91976cda5fc5a45fccd2c782c6d44e73)
2015-02-06fdo#80538 Show an infobar when document is in read-only modeSamuel Mehrbrodt2-3/+0
and remove the Edit icon from the toolbar Reviewed-on: https://gerrit.libreoffice.org/11182 Reviewed-by: Bosdonnat Cedric <cedric.bosdonnat@free.fr> Tested-by: Bosdonnat Cedric <cedric.bosdonnat@free.fr> Conflicts: include/sfx2/sfx.hrc include/sfx2/viewfrm.hxx Change-Id: I27d9506bd0fb76b3f1ad056a9866f7744674a3e2
2015-02-06fdo#80536 UI: Menu entry for 'Edit File' -> 'Edit Mode'Joren De Cuyper1-0/+2
In this commit not only a menu entry is created, also the name is changed from 'Edit File' to 'Edit Mode'. Change-Id: Icd7998307cb0337dd2ee95b298452557ab37375b Reviewed-on: https://gerrit.libreoffice.org/10211 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-02-06Resolves: rhbz#1179642 crash in GetFocus with empty mpPreviouslyFocusedListBoxCaolán McNamara1-2/+3
Change-Id: I7559067c00617482d34e7cbdd177202868cbfc76 (cherry picked from commit dae7d2089516d9cf014b9fad0adb484f19282a29) Reviewed-on: https://gerrit.libreoffice.org/14162 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-02-06Resolves: fdo#75565 reduce block on pasting rtf like we do for htmlCaolán McNamara1-1/+2
Change-Id: I74a9748a2e4981dc5d1677f06db7eceed9e4b108 (cherry picked from commit 0efbd9931ea854cf71c4c54ca3f3d55d6db1fa13) Reviewed-on: https://gerrit.libreoffice.org/14144 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit a0ef7698b7df63b8befe274305051063425f8eb6)
2015-02-06Related: fdo#88455 crash using delete in available fieldsCaolán McNamara2-8/+12
Change-Id: I4ac5fe6f42b425ee96124b2dde39ff397a081638 (cherry picked from commit 1746c886362b8525b04365dd6b7203b8098b99ba) Reviewed-on: https://gerrit.libreoffice.org/14291 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-02-06Resolves: tdf#88740 parse with locale decimal separatorEike Rathke1-6/+27
And use a proper string to double conversion and early bail out conditions. (cherry picked from commit 1884c0bbd40f0ded41d7a1656cb64fb1f6368c36) tdf#88740 fix sidebar angle rotation i18n (cherry picked from commit 9a7bf47098fe69b5c6069372708918ef94a9d597) use a less ugly string to double conversion, tdf#88740 follow-up And check string length before accessing characters.. (cherry picked from commit 3ba5ac834780fc2565aff99e42dd8c3b2202fba3) 30355f3aaf77b1952e21050e3593e575571d7aaa ac3c2bf2f67f0cc7fc106515a875512771676e01 f97a25cd2cab0dccf2154465da7c1235ef3ca8c6 Backport: added vcl/settings.hxx Change-Id: I6c89dd850405ad74ebd175800131cdcac19a8c86 Reviewed-on: https://gerrit.libreoffice.org/14245 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-02-06Resolves: tdf#81124 crash on setting autofilter on column with no contentCaolán McNamara1-1/+2
Change-Id: Id53e589789144d892427a8a4ec1af1926aa97b52 (cherry picked from commit 3a5fa612b4afb72b5f91877a5c52e25c7604ae1a) Reviewed-on: https://gerrit.libreoffice.org/14159 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-01-24Resolves: fdo#88735 crash after calling sort after subtotal removalCaolán McNamara1-1/+1
Change-Id: Ia30271426ea47b7bf5af85d16591a02e6d52b3d9 (cherry picked from commit 0442cd217645aa4fdd924e4c2e4f90a77f1fbbad) Reviewed-on: https://gerrit.libreoffice.org/14140 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-01-24fix abuse of OUStringBuffer(int) ctorEike Rathke2-2/+4
Partial backport of 853c2fc71a96755a9dee629fd5d0e1cff9a48034 Change-Id: I14e26da332a829c6381ee9e07571171ebebe0ac0 Reviewed-on: https://gerrit.libreoffice.org/14133 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-01-24Resolves: fdo#88721 correct negated condition in range name validationEike Rathke1-1/+1
Fallout of 72b9dd277bab328c4d9227439e27e8c29b43fa7d String to OUString conversion. (cherry picked from commit 34f8864c9af563cbcd34352b3edefc67ba235ae7) Conflicts: sc/source/core/tool/rangenam.cxx Change-Id: I89a90da11790efba9e8ce4c9464dfca50b08c3ce Reviewed-on: https://gerrit.libreoffice.org/14121 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-01-24Resolves: fdo#88455 delete in empty data field crashesCaolán McNamara1-5/+10
Change-Id: I399bf576fe89283f839842959f06b8fe83f13b2b (cherry picked from commit 66df4d7d309ce237e4979d57b1069659ece1e3a5) Reviewed-on: https://gerrit.libreoffice.org/14109 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-01-24don't access empty range list, could be rhbz#1180312Eike Rathke1-0/+3
ScRangeList::DeleteArea() may remove an entire range, if it was the last range a subsequent call to ScConditionalFormat::DeleteArea() would attempt to access an invalid first element. Change-Id: I8d68c27963dc8561d61a94980093c271bd3aaffb (cherry picked from commit 9af8e14e67d354bb7736271a76a3dd8b6da78fd9) Reviewed-on: https://gerrit.libreoffice.org/13965 Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2015-01-24rhbz#1136013: svx: try to make the ExternalToolEdit not crash all the timeMichael Stahl2-28/+8
This thing was starting a timer that re-starts itself forever, and when the file it was watching changed, it would just assume the drawing objects were still there (and the document, for that matter...) (cherry picked from commit 5f6bdce0c0ac687f418821ce328f2987bf340cda) Conflicts: sc/source/ui/drawfunc/graphsh.cxx sd/source/ui/inc/DrawViewShell.hxx sd/source/ui/view/drviews2.cxx svx/source/core/extedit.cxx sw/source/core/uibase/shells/grfsh.cxx Converted to C++98. Change-Id: I35f187f0828097a05618dc1733dce819fc6bffc6 Reviewed-on: https://gerrit.libreoffice.org/13994 Tested-by: Caolán McNamara <caolanm@redhat.com> Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2015-01-24Ctrl+A and Data Sort took ages to broadcast ALL cells, fdo#81501 relatedEike Rathke5-14/+26
Noticed when investigating fdo#81501 Squashed commits: Fix high memory usage when sorting cells in Calc. (fdo#81501) Empty columns were being unnecessarily included in the sorting range which caused extra allocation. This happens when you select the entire sheet to sort. There was already code to skip empty trailing cells in rows but not to skip empty columns. Reviewed-on: https://gerrit.libreoffice.org/13294 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit c50d8bf596f527bb53b86dd04da652ed72f2c549) actually use identical code for both byRow and byCol, fdo#81501 follow-up (cherry picked from commit 1e4235f8b2dc693b0fb1edade9db25a631bdbf94) trim also empty leading column ranges, fdo#81501 follow-up (cherry picked from commit c7b57c6c2b15a4b9f65dafb642e3f1da402e62ca) Ctrl+A and Data Sort took ages to broadcast ALL cells ... now that also empty cells are to be broadcasted. Set dirty and broadcast only the effective data range as determined by Sort. This is more a workaround, a cleaner solution would be to refactor the SetDirty() algorithm to iterate only through broadcasters and use AreaBroadcast() to notify area listeners. However, this can also be easily backported to 4-3. (cherry picked from commit 9a568c41ccd1ccf6073758973da5914a44f629d2) 982e03a12dd80be0787f22dce4495065775e7de0 eaeea85149e4b6d263b112205bb17c155e2d12be 6d68ca0088cec6a8328a3e93364ac928ef69babe Change-Id: Ieac22647bb13165cbf66cb1a93f567e5169fff6a Reviewed-on: https://gerrit.libreoffice.org/13323 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-01-24only delete cell content for CELLTYPE_NONE, fdo#88200Markus Mohrhard3-3/+15
Change-Id: I43463b56cabfea4c9ee2b98445f7fb522221197d Reviewed-on: https://gerrit.libreoffice.org/13843 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2015-01-12Resolves: fdo#85617 always store fully encoded external document nameEike Rathke5-12/+18
Also OOXML calls these API functions, this is the central place to handle it. (cherry picked from commit 97a8b3ed5e5bd42e213d3230fa764b0f5d10f0f2) write externalLink Relationship Target IURI encoded, fdo#85617 related (cherry picked from commit 7eb5e135422f1a5830a44d129300bc3fafb4627d) do not drop entire external reference, fdo#85617 related If there are no matching tab names for a FileId, preserve at least the known reference parts. In case of 2D references the sheet name is in the token if for example read from .xlsx, only for 3D references the second sheet name would be needed. The underlying makeExternalRefStr() and its subroutines handle the missing tabname elements gracefully. Still this situation is worth an assertion. (cherry picked from commit b6339617b1cc3136f9e527acd0746d712cd21643) Change-Id: I3df065af8e4ef44734f468fd455c3b7c93d7fbc6 Reviewed-on: https://gerrit.libreoffice.org/13840 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 80bbe4a4dcbb0286f472ca3ee0e21746995fe4a6)
2015-01-12handle index based external refs in formulas in ooxml import, fdo#85617Markus Mohrhard1-3/+28
(cherry picked from commit 18cccd62fb5b730319878df6fac748d5cdf73f1f) return after finding the reference (cherry picked from commit cef36587674b6472471478524e87b1add4109507) that method is the same as in the base class (cherry picked from commit 02caf8f2eef75d8b5acb6a4ec40277355c3c6c6e) remove copy&paste code (cherry picked from commit 757ce63f7346aea132f11c3d9a328b0a1a776403) a22b97b0a45d8d840095737638c2ccf68373e27a 8cb6f59795d9461c0e02ab70d7edd60af1410c1f 5710856fdb9fb91573de89eeb5a29d3d106ad7a6 Change-Id: Ie4f43f041f5d614b9c2826c74574c854af05c266 Reviewed-on: https://gerrit.libreoffice.org/13839 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 90bbc9e6f51a2281f7cf06577252791e62a9189b)
2015-01-12fix Werror buildMarkus Mohrhard1-1/+1
Change-Id: Ief706ff4dc74efe2a8cee69d9e9806e025394329 Reviewed-on: https://gerrit.libreoffice.org/13847 Reviewed-by: Norbert Thiebaud <nthiebaud@gmail.com> Tested-by: Norbert Thiebaud <nthiebaud@gmail.com> (cherry picked from commit e4c2cada42d5f81bc09291da3b000f57de4a50b0)
2015-01-08handle all fill cases correctly, fdo#86754Markus Mohrhard1-1/+1
That special case only works if the whole source range contains formula cells. For now we just limit it to the special case of a single source cell. Change-Id: I71ccfde06edd97e5a9c78da22053583d05aac411 Reviewed-on: https://gerrit.libreoffice.org/13344 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 8176253a7f8b061eb18015763ca674ea959ddf37)
2015-01-08don't update range name if ref not in update range, fdo#85304Markus Mohrhard1-0/+3
Change-Id: I1ccfacd98bd10f6ae1d4eaf7a705fe8863045697 Reviewed-on: https://gerrit.libreoffice.org/13363 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit ba874864eb57e38b6368256ccadcb8274eec4f2c)
2015-01-08we want to compare two different cells, fdo#85353Markus Mohrhard1-1/+1
Change-Id: Ie612555a63a1eff79e6c35aeed3cfa27b948ad38 Reviewed-on: https://gerrit.libreoffice.org/13636 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 96409fd72c6fca3b64254666471f590ff89b9a26)
2015-01-08reimplement shared formula import for xlsb, fdo#86734Markus Mohrhard4-12/+30
Change-Id: Ic5d678a2b1197ce8d83b308b0a4387bf657052d5 Reviewed-on: https://gerrit.libreoffice.org/13634 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit c931268890fdd0e9aec1bdab939495f299e11011)
2015-01-08fix another validation error for OOXML, related fdo#40746Markus Mohrhard1-7/+11
e.g. exporting fdo40746-2.ods as OOXML Change-Id: I8a19ec2caecbc3687229d820ac2ec11fc01facd1 Reviewed-on: https://gerrit.libreoffice.org/13590 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 62bc15f270614afa37c6615fc34cd79f45026da5)
2015-01-08fix OOXML validation error, related fdo#40746Markus Mohrhard1-6/+10
e.g. fdo40746-2.ods exported to OOXML Change-Id: I48bc7a7d21ddc00eceaeb09970a2b1a60330fbf0 Reviewed-on: https://gerrit.libreoffice.org/13589 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 1eb1d5a643f3526d540abe783edac78c8ded476b)
2015-01-08fix OOXML validation errorsMarkus Mohrhard1-0/+6
Change-Id: Ieac082a3b312602eff5ec101529536d747fa3836 Reviewed-on: https://gerrit.libreoffice.org/13586 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 995a06e212c1a5ca6b5f29ad01d445a1c0d460f1)
2015-01-08we need the original context that contains the data, fdo#85856Markus Mohrhard1-2/+1
Conflicts: sc/source/core/data/documen2.cxx Change-Id: I107201ab736b548f010d813540e0a9cec7402e79 Reviewed-on: https://gerrit.libreoffice.org/13343 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit c9770b4fc95e87e1f56f01b7b448d20e57277d50)
2015-01-08import part for: " use correct xml element name, related fdo#45266"Markus Mohrhard2-1/+2
Change-Id: Ied71383fc837c7e667455f84937801e8d45f2989 Reviewed-on: https://gerrit.libreoffice.org/13360 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com> (cherry picked from commit 21afec83dbb6ab338e43db647345cda81db1039a)
2015-01-08handle relative refs correctly in xls import, fdo#80091Markus Mohrhard1-2/+5
Change-Id: Ia70f96e1d31e71c56f03c828be0a4e49fff4b198 Reviewed-on: https://gerrit.libreoffice.org/13688 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit be9631c2dd65a46f56c45615acd415422ee6a468)
2015-01-08relative refs wrap around in xls, fdo#84556Markus Mohrhard2-7/+16
Change-Id: If84d468d4bd55ed55ccd517d0b078d283a1a9c38 Reviewed-on: https://gerrit.libreoffice.org/13695 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com> (cherry picked from commit 57009e242645590603b8854a81be74c1d4872fa1)
2015-01-08fix compilationLionel Elie Mamane1-2/+2
Change-Id: If55862447acc364203079ad98a0bffd0da2dff79 Reviewed-on: https://gerrit.libreoffice.org/13800 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit 3c744def658df4e7d2154ee48eabe39969600486)
2015-01-08rhbz#1116534 crash when pasting over a formulaDavid Tardon3-25/+54
When pasting CSV data into existing document, we cannot use the ScImportExport optimization for insertion, because the cells can already have content (a grouped formula in this case). So use appropriate ScDocument functions, even if that means the import is slower. This is a regression from commit 93959db4d8846cfdfb87ab647c4d457fb09bb869 "use DocumentImport for csv import, related fdo#69006". (cherry picked from commit bf97980c8d5d5fbc63a08b8834c10fe903152b75) Conflicts: sc/source/ui/view/viewfun5.cxx Change-Id: I92f70abca0542d796e3aa674b28a31053fff00d0 Reviewed-on: https://gerrit.libreoffice.org/13456 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 40ec3aa2d5f9ecf713cce0fd7c89fdd5f830f664)
2015-01-08Resolves: fdo#86978 append formula cells to track instead of treeEike Rathke2-1/+12
Cells in FormulaTree are assumed to be tracked already and their dependents be notified. Also postpone tracking until all listeners are established. (cherry picked from commit 573f5dfba805b733dd2da62bde3cd5d9d25879d9) Conflicts: sc/source/core/data/formulacell.cxx Change-Id: I7f27fba979fe231e3d3cd071fcc8a273142cb3f3 Reviewed-on: https://gerrit.libreoffice.org/13523 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit d210265a1b6c4d7b405ef6e79fd30395ca1bc0aa)
2015-01-08fdo#85258 differentiate between empty cell and empty result in matrixEike Rathke4-21/+93
Change-Id: I79259224e411f9c1a6e852623d9d49cf89a03c27 (cherry picked from commit 069698de192ef7e8d3582398e4542c175cabb987) Reviewed-on: https://gerrit.libreoffice.org/13617 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit 007bede69824b2caee948d21acefc2f5b0f63b3a)
2015-01-08fdo#79249 call formula compiler with error stringEike Rathke4-10/+23
... instead of attempting to stringize a NaN coded error value. Regression introduced with 30a20743ae17e6e02183a65603d38968253b3ffb (cherry picked from commit 994607b55104b9ae4554554c13b001b8d5d513b6) construct grouped ScFormulaCell with bDirty=true, fdo#79249 related Noticed when loading https://bugs.freedesktop.org/attachment.cgi?id=99844 with fdo#79249 fix where oox::xls::applyCellFormulas() groups the consecutive =#N/A formulas. Only A1 result was displayed, other cells were displayed empty. (cherry picked from commit a1dc5e97da273bf35d58d54e625149022569a993) correct error string, #N/A instead of #NA (cherry picked from commit 758755e31b3d9e1ed2eab522d4794282178346ac) implement an actually working setErrorCell() from BIFF error codes (cherry picked from commit ca9a81b2ca858b82e863e1e6f917928916fea79e) Change-Id: Ia7a8ca39938820ac75db169404446fa696c6ee1b 3a541f74d3d25e1515a1c6d47f02ec6a8e817c93 15019072b6e812b9ffe29d3ee6afacd9ab526948 67b8fc324779875ba14e2d69204c40fe27cc180e Reviewed-on: https://gerrit.libreoffice.org/13490 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com> (cherry picked from commit 11724301fb690cbd58581e468f3cd80e7becc07d)
2015-01-08Better fix for fdo#87558: Duplication in Last Used Functions sidebar listJulien Nabet1-2/+2
Advantage compared to previous fix: in sidebar, last used function is put at the top Still function from menu is sorted, the pb is we use InsertEntry, see 0 ImplEntryList::InsertEntry (this=0x32d0910, nPos=2147483647, pNewEntry=0x326f620, bSort=true) at /home/julien/compile-libreoffice/libreoffice/vcl/source/control/ilstbox.cxx:144 1 0x00002aaab1b2444e in ImplListBoxWindow::InsertEntry (this=0x3287358, nPos=2147483647, pNewEntry=0x326f620) at /home/julien/compile-libreoffice/libreoffice/vcl/source/control/ilstbox.cxx:750 2 0x00002aaab1b2a138 in ImplListBox::InsertEntry (this=0x3287100, nPos=2147483647, rStr="ACOT") at /home/julien/compile-libreoffice/libreoffice/vcl/source/control/ilstbox.cxx:2182 3 0x00002aaab1b47d51 in ListBox::InsertEntry (this=0x32e9ca0, rStr="ACOT", nPos=2147483647) at /home/julien/compile-libreoffice/libreoffice/vcl/source/control/lstbox.cxx:1001 4 0x00002aaad0c05d84 in formula::FuncPage::UpdateFunctionList (this=0x3217110) at /home/julien/compile-libreoffice/libreoffice/formula/source/ui/dlg/funcpage.cxx:153 should we create a new InsertEntry to force bSort=false? Change-Id: Iba1b020aeea09951dead30f6781b24993aac98e0 Reviewed-on: https://gerrit.libreoffice.org/13725 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com> (cherry picked from commit 585ab75a9344e140c876cb7565d3525a62fb8a73) Reviewed-on: https://gerrit.libreoffice.org/13781 Reviewed-by: Julien Nabet <serval2412@yahoo.fr> (cherry picked from commit 689afb19dc399ff3fcea07a6d264b61d10313a1e) Reviewed-on: https://gerrit.libreoffice.org/13782 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit 3cc529ccfb91444c13c771d0f8b2c1292452002f)