[ooo-build] Calc не добавляет повтор строки в области печати

[foxval]

Binary package hint: openoffice.org

 После указания в диалоговом окне "Изменение диапазонов печати" повтора строки (пытался выделять, вводил вручную) нажимаю "Ок" и получаю окно с ошибкой "Недопустимая ссылка на лист."

ProblemType: Bug
Architecture: amd64
Date: Thu Nov 5 22:57:10 2009
DistroRelease: Ubuntu 9.10
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified: usr/lib/openoffice/basis3.1/program/libdeploymentmisclx.so usr/lib/openoffice/basis3.1/program/pagein usr/lib/openoffice/basis3.1/program/pluginapp.bin usr/lib/openoffice/basis3.1/program/spadmin.bin usr/lib/openoffice/basis3.1/program/uri-encode usr/lib/openoffice/basis3.1/program/libsofficeapp.so usr/lib/openoffice/basis3.1/program/libunopkgapp.so usr/lib/openoffice/basis3.1/program/libbasegfxlx.so usr/lib/openoffice/basis3.1/program/libfwelx.so usr/lib/openoffice/basis3.1/program/libfwilx.so usr/lib/openoffice/basis3.1/program/libjlx_g.so usr/lib/openoffice/basis3.1/program/libpsplx.so usr/lib/openoffice/basis3.1/program/libsaxlx.so usr/lib/openoffice/basis3.1/program/libsblx.so usr/lib/openoffice/basis3.1/program/libsfxlx.so usr/lib/openoffice/basis3.1/program/libsotlx.so usr/lib/openoffice/basis3.1/program/libspalx.so usr/lib/openoffice/basis3.1/program/libsvllx.so usr/lib/openoffice/basis3.1/program/libsvtlx.so usr/lib/openoffice/basis3.1/program/libtklx.so usr/lib/openoffice/basis3.1/program/libtllx.so usr/lib/openoffice/basis3.1/program/libutllx.so usr/lib/openoffice/basis3.1/program/libvcllx.so usr/lib/openoffice/basis3.1/program/libxcrlx.so usr/lib/openoffice/basis3.1/program/libcomphelp4gcc3.so usr/lib/openoffice/basis3.1/program/libi18nisolang1gcc3.so usr/lib/openoffice/basis3.1/program/libi18nutilgcc3.so usr/lib/openoffice/basis3.1/program/libucbhelper4gcc3.so usr/lib/openoffice/basis3.1/program/libvos3gcc3.so usr/lib/openoffice/program/oosplash.bin usr/lib/openoffice/program/soffice.bin usr/lib/openoffice/program/unopkg.bin]
ProcEnviron:
 LANGUAGE=ru_RU:ru:en_GB:en
 PATH=(custom, no user)
 LANG=ru_RU.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-14.48-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-14-generic x86_64

[Niklas-nebel (niklas-nebel)]

Task tracking system for Childs
PLEASE CREATE CHILD-TASKS IN ISSUEZILLA!

Source
QA/Customer

Category
Calc

Product Requirement
Allow (A:A) as range in functions

Customer Need/Problem
A compatible range for a whole column is needed (e.g. =sum(A:A) )

Comment
-

Eng Effort
-

Eng Owner
Niklas Nebel

Product Concept
In formulas in other applications, whole columns or rows can be referenced using
just the column or row names, like 'A:B' or '1:2'. In the Excel file import
these references are already converted to 'A1:B32000' or 'A1:IV2', so nothing is
lost. But a user who tries to enter such formulas in SO/OOo will get an error.
We dont want to change our definition of cell references, because it is part of
the documented file format. Instead, we will do the same conversion as in the
Excel import during formula input. The 'INDIRECT' function also has to be extended.

Functional Specification
-

[Lutz-hoeger (lutz-hoeger)]

added keyword Q-PCD

[Niklas-nebel (niklas-nebel)]

*** Issue 23098 has been marked as a duplicate of this issue. ***

[Nesshof (nesshof)]

according to the announcement on releases
(http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) this issue
will be re-targeted to OOo Later.

[Frank-l (frank-l)]

*** Issue 50303 has been marked as a duplicate of this issue. ***

[Frank-l (frank-l)]

changed summary

[Frank-l (frank-l)]

*** Issue 68207 has been marked as a duplicate of this issue. ***

[Eva-email (eva-email)]

The suggestion to convert automatically any entry like (A:A) to (A1:A65563) is
_not_ a sufficient solution!

If you mean to sum the entire culumn A by using =SUM(A1:A65563) in cell B1, and
extend it to a row below by dragging, the second row cell (B2) will take a value
of "=SUM(A2:A#REF!)", obviously not the desired result (to keep selecting the
entire column).

In addition there is a compatibility problem between old sheets that contain
32000 rows and new sheets that contain 65563 rows.

(A:A) and (A1:A65563) are just not the same, but a very different qualitiy of
information. Up to now, OOo lacks the possibility to express a reference to an
entire column or an entire row.

[Eva-email (eva-email)]

Please consider to enable entering a reference to an entire row/column by a
mouse click on the row/column header.

[Frank-l (frank-l)]

*** Issue 82189 has been marked as a duplicate of this issue. ***

[David-hobley (david-hobley)]

Note that the Excel 2007 file import does not convert these references
automatically which effectively breaks the compatibility for those sheets using
this syntax.

[Frank-loehmann (frank-loehmann)]

Set target and cc myself.

[sam tygier (samtygier)]

I noticed that the report is not in English. If they were translated to English they would be accessible to more triagers. Could you please translate them? Thanks

[foxval (valunf)]

I have attached screenshots with this bug.

[foxval (valunf)]

Another one with English UI

[Chris Cheney (ccheney)]

Do you still have this problem with Ubuntu 10.04 LTS (Lucid)?

[foxval (valunf)]

Yes, I do.
Kubuntu 10.04, OpenOffice 3.2.0 (Build:9483)

[B-ooo (b-ooo)]

*** Issue 112049 has been marked as a duplicate of this issue. ***

[Niklas-nebel (niklas-nebel)]

*** Issue 112254 has been marked as a duplicate of this issue. ***

[Andrey (aol-nnov)]

Hi, All!

I can confirm, that the bug is 100% reproducible on many builds and on both platforms. I've checked latesl libreoffice for x86 linux, openoffice 3.2.1 from gentoo portage, packages from ALTLinux 5.1 repos and OOo for Windows built by InfraResource.
I have no idea of the root cause of this bug, BUT i've just found an interim solution.

bring up OO Calc, navigate to Tools->Options->OpenOffice.org Calc->Formula. Choose "Excel A1" as formula syntax instead of "Calc A1" which is chosen by default.

Bingo.

HTH,
Andrey

[Andrey (aol-nnov)]

Hi, All!

That's me again ;)

just digged a bit deeper and look what i've found so far:

(all my investigations were performed with clean config (rm -rf ~/.ooo3), so it's "Calc A1" Formula syntax.

http://qa.openoffice.org/issues/show_bug.cgi?id=20495 - it seems like OOo has problems with addressing the whole row. Anyway, i've tried to select print ranges -> row to repeat and just entered A:A there. Hell, it worked!
Ok, i've relaunched calc and tried to perform the same thing with mouse. Just clicked the A1 cell and "Row to repeat" textbox was immediately filled with $1 value. And to my surprise, it worked TOO!.

okay, damned thing, i thought and mv ~/.ooo3 ~/.ooo3-working

rerun calc and tried to add repeating row with mouse again. it fails. cool! now the only thing i need is a diff tool! ;)

5 minutes later i've figured out that among files created by default ~/.ooo3-working contains user/registry/data/org/openoffice/Office/Calc.xcu, but ~/.ooo3 does NOT. copied it over, and again BINGO! it's working like a charm now!!

Bottom line: Calc.xcu is not created during first run of the application and hardcoded values (if there are any) are not suitable.

Andrey

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[Strideroflands (strideroflands)]

Logical extensions or parts of this functionality, depending on whether you want these as separate issue(s) or not, would the the ability to click the SUM button (sigma), and then the column or row title, and get the whole column or row; or several columns or rows. To be able to think in columns or rows, no matter how many are supported in future versions of the software, would also include being able to use the Format Paintbrush to paint a format on a column or row. Painting a format on the whole sheet by clicking on the heading square in the upper-left corner would complete this user interface suite of niceties. Note that one can already set formats this way through Cell | Format; just, not with the Format Paintbrush. Think of this as one of the pre-Apache things the developers never got around to; but now, it is now a matter of just catching up to where Excel was 10-15 years ago.

[Damjan-5 (damjan-5)]

*** Issue 105444 has been marked as a duplicate of this issue. ***

[Orcmid (orcmid)]

This is now a defect since import of a proper .ods having A:A produced by Excel will cause a failure on entry into AOO as of 4.1.2.

There is a patch under review and there is also some developer discussion on how to accomplish this with appropriate attention to interoperability with earlier ODF 1.2 (and OpenForumula) supporting versions of OpenOffice.org, AOO, and also LibreOffice before this was repaired there.

[Mkrcds (mkrcds)]

Reset the assignee to the default "<email address hidden>".

[OOoForum (oooforum)]

*** Issue 126915 has been marked as a duplicate of this issue. ***

[OOoForum (oooforum)]

(In reply to orcmid from comment #16)
> There is a patch under review
Where is this patch?

I bump this defect because incompatibility increase now

[Damjan-5 (damjan-5)]

(In reply to oooforum (fr) from comment #19)
> (In reply to orcmid from comment #16)
> > There is a patch under review
> Where is this patch?

It was committed and then reverted because the author copied it from LibreOffice.

[OOoForum (oooforum)]

It's a shame, but I don't really see how we can invent another code syntax to fix the issue. :-/