summaryrefslogtreecommitdiff
path: root/sc
AgeCommit message (Collapse)AuthorFilesLines
2011-08-10Prevent crash at column row boundaries.libreoffice-3-3Eike Rathke1-30/+16
Modified from the original patch submitted by Olivier Hallot. Signed-off-by: Kohei Yoshida <kohei.yoshida@suse.com>
2011-07-27Resolves: fdo#38955 set selection request as done for macro recorderCaolán McNamara1-0/+1
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>
2011-05-04lp#775608: Libreoffice Calc's PRODUCT function doesn't calculate correctly.Bjoern Michaelsen1-2/+2
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>
2011-03-21Fix seg faults on sheet deletion.Kohei Yoshida1-1/+1
Sometimes a simple sheet removal causes segfault in certain types of documents. Not always reproducible, but this fix is certainly safer. (n#680272) Signed-off-by: Noel Power <nopower@novell.com>
2011-03-11Disabled auto-complete in Calc filter dialog - fix for bug 34898.Tibby Lickle1-0/+1
A hyphen character caused auto-complete to kick in, changing the user's choice of conditional operator to "=". This was not changed back if auto-complete option is overridden. Signed-off-by: Kohei Yoshida <kyoshida@novell.com>
2011-03-08Properly invalidate cached sheet XML streams during reference update.Kohei Yoshida6-11/+57
Failure to invalidate sheet streams during reference update caused formula cross referenceing between sheets to totallly get borked. The bug was originally reported in i#116833. Signed off by Petr Mladek <pmladek@suse.cz>
2011-03-03Fixed incorrect cursor navigation. (fdo#33756)Kohei Yoshida1-44/+15
Block selection with keyboard was incorrect when the selected range included hidden cells. This also fixes one crasher on block selection during formula reference mode i.e. type '=SUM(' and select range via keyboard afterward.
2011-03-03Better fix for fdo#31939.Kohei Yoshida3-22/+2
Turns out that the token array's recalc mode is set to "recalc always" when it contains a volatile token during compilation. We can re-use that to mark the token array volatile before the interpretation starts. The end result is the same, with better performance since we can avoid re-scanning of the token array. Signed-off-by: Michael Meeks <michael.meeks@novell.com>
2011-03-03Go through all tokens to look for a volatile one. (fdo#31939)Kohei Yoshida4-1/+59
When a volatile token is inside a conditional function (such as IF), *and* the evaluation of that conditional skips the volatile token it would incorrectly mark the cell non-volatile. The solution is to scan through all tokens in the token array in the beginning of the calculation and mark the cell volatile if one is found.
2011-02-27Changed label size and position for BTN_GENERAL_PREC, FT_PREC and ED_PRECJean-Baptiste Faure1-5/+5
FT_PREC overwrote BTN_GENERAL_PREC so that French translation was truncated
2011-02-18Properly update column and row header selections. (fdo#34383)Kohei Yoshida1-0/+1
When making range selection by mouse, Calc wouldn't highlight the new range in the column and row headers. It was because we weren't calling ScTabView::SelectionChanged() when the selection range is updated. This SelectionChanged() call then puts in queue a re-paint request for column and row headers.
2011-01-27Remove unused declarationJani Monoses1-3/+0
Signed-off-by: Michael Meeks <michael.meeks@novell.com>
2011-01-21Fixed incorrect page number in page preview mode. (fdo#33155)Kohei Yoshida1-5/+7
When the window is large enough to show several 'Page X' strings, the page number was not properly incremented. This commit fixes it.
2011-01-21Fixed incorrect import of cell attributes from Excel documents.Kohei Yoshida1-0/+9
When a cell with non-default formatting attribute starts with non-first row in a column, the filter would incorrectly apply the same format to all the cells above it if they didn't have any formats. This commit fixes it.
2011-01-13Reverting the merge commit 0fe55349b05fae496a86a3fa958d184f0453916c.Kohei Yoshida12-234/+52
I created a patch between before and after the merge commit, and reverse-applied it. This is because if you revert a merge commit in git you are denying all future merges from that branch. I wasn't sure if we really wanted that. Signed-off-by: Petr Mladek <pmladek@suse.cz>
2011-01-13Revert "This is also part of the merge."Kohei Yoshida1-1/+2
This reverts commit 0fe55349b05fae496a86a3fa958d184f0453916c. Signed-off-by: Petr Mladek <pmladek@suse.cz>
2011-01-07This is also part of the merge.Kohei Yoshida1-2/+1
2011-01-07Merge commit 'ooo/OOO330_m19' into libreoffice-3-3Kohei Yoshida12-53/+235
Conflicts: sc/source/core/data/table2.cxx sc/source/core/data/table3.cxx
2011-01-06CWS-TOOLING: integrate CWS calc64ooo/OOO330_m19Kurt Zenker6-24/+162
2011-01-05Make more room for Portuguese locale. (fdo#32823)Kohei Yoshida1-6/+6
Signed-off-by: Michael Meeks <michael.meeks@novell.com>
2011-01-05calc64: remove a warningNiklas Nebel1-1/+0
2011-01-05calc64: #i116164# performance of filters with many filtered rangesNiklas Nebel6-23/+162
2010-12-29Remove bogus check for numerical sheet names. (fdo#32570)Kohei Yoshida1-6/+1
We apparently put numerical sheet name into quotes somewhere else, so checking for a number followed by a '.' and flagging it as bad is not only necessary, it's not appropriate. E.g. we do support other formula syntax where the sheet-to-reference separator is not '.' (Excel A1 and Excel R1C1), thereby making this test even more inappropriate. Signed-off-by: Jan Holesovsky <kendy@suse.cz>
2010-12-22Actually the object doesn't have to be a cell note.Kohei Yoshida1-6/+3
The same problem happens even when the object is not a cell note, but, say, a regular text box. Let's not check whether or not the object is a cell note. Signed-off-by: Caolán McNamara <caolanm@redhat.com>
2010-12-22Avoid double-paste when pasting text into cell comment. (fdo#32572)Kohei Yoshida1-0/+20
Original patch is from Caolan. I re-worked it to handle more use cases. Signed-off-by: Caolán McNamara <caolanm@redhat.com>
2010-12-14Remove trailing spaces too when parsing csv's simple numbers.feature/helppackKohei Yoshida2-3/+15
2010-12-14WaE, shadowed warningCaolán McNamara1-1/+1
2010-12-14We need to reset i to 0 after parsing spaces.Kohei Yoshida1-1/+7
2010-12-14The previous commit would skip *all* spaces. This is the right fix.Kohei Yoshida1-5/+12
2010-12-14When parsing numbers, ignore preceding spaces.Kohei Yoshida1-2/+6
Also, increment the char pointer and use it directly, which is faster than accessing char via [] in each iteration.
2010-12-11ooo33gsl13: #i115906# obtain correct data range for external referencesEike Rathke [er]8-31/+72
* Apparently ScTable::GetFirstDataPos() never worked as intended and selected the first non-empty row of the first non-empty column instead of also taking following columns into account where non-empty rows may be on top of that. * Caller of ScDocument::ShrinkToDataArea() must check the return value, if false there is no data in the area passed and the values obtained may be out of bounds, not in order or unmodified. * In ScExternalRefMgr a call of ScDocument::ShrinkToUsedDataArea() was intended instead of ScDocument::ShrinkToDataArea(). For this changed the return of ShrinkToUsedDataArea() to flag if there is any data and added an out parameter to flag if the area was shrunk. * Sanitized arguments and slightly optimized ScTable::ShrinkToUsedDataArea() to not have to check for >0 and <MAX on each iteration. (transplanted from 31b53a2ec7e32f9560464f8a3b9f6c3e07b29083)
2010-12-08Make the string 'New Record' localizable. (fdo#32209)feature/winshrinkKohei Yoshida3-1/+7
This string was hard-coded in the code to be always in English. This change makes it localizable. Signed-off-by: Caolán McNamara <caolanm@redhat.com>
2010-12-07Display correct record information in Data Form dialog. (fdo#32196)Kohei Yoshida1-3/+13
I had accidentally removed the part that constructed correct string to display. Recovered it, and modified it to use OUStringBuffer instead of sprintf to construct the string. Signed-off-by: Norbert Thiebaud <nthiebaud@gmail.com>
2010-11-30Changed header license for new files from ooo-build.Kohei Yoshida2-53/+47
2010-11-30Don't forget to store sheet index of merged cell range to be re-merged.Kohei Yoshida3-3/+15
This fixes fdo#31805.
2010-11-30Skip hidden cells while expanding range selection.Kohei Yoshida3-6/+36
This commit happily fixes fdo#31796.
2010-11-29Extracted methods that may be used in another place.Kohei Yoshida3-80/+125
2010-11-29Removed unused code.Kohei Yoshida1-6/+0
2010-11-29Don't update visible ranges for invisible panes.Kohei Yoshida1-1/+1
2010-11-29Re-calculate visible range when switching sheets.Kohei Yoshida6-62/+85
Visible range of the current sheet is used to decide whether or not to render cell cursor. Failing to do that was causing the cursor to disappear when switching sheets while the cursor on the current sheet was invisible. (fdo#31753)
2010-11-29Fixed use of incorrect integer type during import of outlines.Kohei Yoshida2-3/+11
I was supposed to use SCSIZE to store column / row position but was incorrectly using sal_uInt8. This caused import of outlines from Excel document to entirely get screwed when the outline positions were > 255, and it was understandably so. :-P (fdo#31833)
2010-11-29More strict parsing of external range names.Kohei Yoshida1-7/+31
This is to prevent parsing formula strings such as '=A#REF!' as valid external range names. Ideally we should express any formula including invalid refs simply as '=#REF!' in all cases, but we are not there yet. (fdo#31741)
2010-11-25Put show credits entry into all app ui configsThorsten Behrens1-0/+1
2010-11-25Fixed crash in xls export caused by off-by-one iteratorKatarina Machalkova1-2/+1
(this is for bnc#653533 and fdo#31141)
2010-11-19No automatic width adjustment of the dropdown popups. (fdo#31710)Kohei Yoshida1-0/+1
Let's not automatically adjust the width of the dropdown popups of the Values combo boxes in the standard filter dialog. It looks better that way.
2010-11-18Make VLOOKUP work with an external reference once again. (fdo#31718)Kohei Yoshida1-3/+8
2010-11-18Add workaround to avoid pasting data from OOo Calc as an OLE objectTor Lillqvist1-0/+7
Help for fdo#31077.
2010-11-18Disable document modify and broadcasting of changes on range names.Kohei Yoshida11-91/+244
We don't need to set document status modified & broadcast changes on every single addition of range names during document import. Doing so would make the document import painfully slow esp with docs with lots of range names defined. (n#634257) Note: this is a backport of the same fix from master. Please don't merge this back into master.
2010-11-17Changing margins in print preview should mark the document modified.Kohei Yoshida1-0/+7
This fixes fdo#31219.
2010-11-16Merge commit 'ooo/OOO330_m15' into libreoffice-3-3Jan Holesovsky3-5/+29