acknak wrote:What sort of work are you doing that requires vertical centering?

Typical documentation work.
http://prnt.sc/f6pk07

Sounds like the same issue, yes.

It already not resetting anymore, since I changed the date calculation base.
But I no longer trust ODF format in OO, until this bug is fixed.

Well, I don't think it's "mysterious changes in profile settings". Or rather, they should not have such effect, unless they happen on the fly. Even then, I can't imagine an event, in which it would affect dates like it does. I mean, I edit a file, save it, reopen. All dates are shifted. I ...

Indeed, the date base was set to 01.01.1900. I can accept an issue in displaying a date in such case.
But why it drifting on each consequent save?... That suggest that it ALTERING stored value.

Dates DO change in Calc on save-close-reopen. The shift is in days, not mere seconds taking to reopen a file.
I'm VERY angry. It only confirmed for Open Document format. Saving as MS Excel '97 don't cause dates to shift.

OK, keep in mind that A1:A65536 is not exactly the same as A:A. SUM(A1:A65536) will shrink when you delete cells (or entire rows). OFFSET($A$1;0;0;65536;1) returns a reference to A1, 0 rows offset, 0 columns offset, resized to 65536 rows and 1 row. That range gets it's dimensions calculated from co...

I've been given a shiny new (well, quite old in terms of hardware, but still) MacBook, running OS X Lion. It's quite good so far, the only problem is application support. While programs coming with it, as well as Opera, support it's native separate desktop fullscreen mode, OpenOffice, sadly, don't, ...

If you ask me, OOo is unable to open MS Office xml documents of certain size (several megabytes of XML code, which means 40+ pages) - Office just hangs of throw an exception that document is broken. Knowing that the document only contains simple formatting (easily opened after re-saving in binary fo...

I still have this issue, with OOo 3.3 now. It randomly manifests in writer, but 1) I rarely use writer, 2) for Calc it's much more consistent. (Read: persistent.)

Still actual for 3.1.0 (build 9399)

Actually, it DO WORK (although it's slow comparing to Excel) in OOo Calc. And I want it to continue to work there. Better than in Excel, if at all possible, despite it's (Calc) "speed". I want as many people as possible to leave the grasp of Microsoft development studio and switch to human...

Been using OOo from 2.4.1 to 3.0.1, it's consistent on all versons and systems i've tried. Win2kSP4, XPSP3, Ubuntu 8.04 Cut/Copy of the text from inside of the Calc cell (from the formula bar) or the Calc cells - no matter, takes no less than 5 sec. At the same time, cut and copy from Writer works o...

Do not cut. Copy.
When you cut&paste, it's keeping track as it were the movement of the cell, thus updating links to it.
However, there's different approach to the solution.
Adjust your Balance column formula to the (considering it is E767)
=SUM($E$2:$E767)-SUM($D$2:$D767)

If it were my own feeds and application, I'd better slap a PHP app together and forget about it. But it is what it is. It's a complete Excel app that already have composed links to these feeds (which are 3rd party to both me and that app author) for every row, only what I want is to avoid manual &qu...

[[:space:]] is effectively [:space:], set of single set is that set itself.
Try [[:space:][:alfa:]], combination of two sets into new one.

For me, it looks like OOo using POSIX RE matching library, not inventing it's own.
At least [:space:], [:alfa:] is the part of POSIX-defined patterns.

Well, it may be stated that way.
I want to populate certain cells of currently opened document with values available in remote XML feeds.
At best, I need Excel-compatible solution.

Thank you for fixing my bad regex. It wasn't bad, it's were doing what you told it to do. Not accounting for all possible cases, however. But still, what the proper "ungreedy" pattern for POSIX RE? It stripping beginning spaces, but not enging. May strip one if I change quantifier from &q...

It's apparent that you do not understand what I need. Or I can't understand what you're trying to say.
I do not need to convert documents from one format to another. I need to populate cell values in existing document with data from remote source.

WTS Reading Comprehension skillbook. Or WTB more explained answer. How can this example of loading and saving a document in different from standard format help me retrieve remote feed, prepare values from it (there are many, I'm interested in few), and paste them in the cell? If you're going to answ...

menu:Find&Replace all leading and trailing space seems to be the best solution to clean up pasted web-content. Search: ^[:space:]+(.*)[:space:]+$ Replace: $1 [More Options] [X] Regular Expressions [Replace All] Not even ^[:space:]*(.*?)[:space:]*$ works... it does not strip trailing spaces. P.S...

I need to feed cells with changing data (that's averaged prices) available as XML feeds. One feed per cell. To make it more practical, imagine the following situation: Sheet1 is the control sheet, where I have input fields and lookup formulas against Sheet2. On Sheet2, I have a long-long list of ID'...