How would you help Kevin who writes in with the following problem?
I need an OpenOffice miracle. I transitioned a small public library from M$ to OO recently, and nearly everyone was receptive to it (save one older woman, who for reasons she can't articulate, just plain hates OO.) I've been able to overcome every problem until now; here's what's happening:
Evil old woman is in charge of the schedule. She uses OO Calc to organize a monthly schedule where each week is on a separate sheet. When she wants to insert a row into all four sheets, I tell her to highlight the four sheets and the row should automagically be inserted into all of them. Unfortunately, this doesn't work. Is there another (simple/elegant) method for inserting a row across multiple sheets?
I've searched the documentation for a solution, but most error reports that deal with this are from OO 1.0. Please help!
First, I checked myself in OpenOffice.org 2.4.0 and in Microsoft Excel 2003. Indeed Excel performs multi-sheet insert operations simultaneously, but OpenOffice.org does.
Second, I checked the Issue Tracker and found issues 17044 and 29849. The first one more closely matches Kevin's need. Both issues are marked version 1.x, which means they were discovered in those old versions. The 1.x doesn't necessarily mean these issues don't apply to 2.4.0, and based on my quick tests, nothing has changed since then. Both issues also have 0 votes, no target milestone, and no recent comments: that generally means there is little interest in implementing these feature requests, so don't hold your breath. If Kevin were to register in the Issue Tracker, he could add two votes per issue. Even if by a miracle some developer decided to implement the feature request today, it wouldn't make it in until OpenOffice.org 3.1 in December.
Based on the information so far, there is no direct way to do this in OpenOffice.org. Now, is there a workaround? What about recording a macro? Should OpenOffice.org emulate all of Microsoft Office? How important is user satisfaction? How could Kevin manage the human element of the problem? Give Kevin your advice by posting a comment.