] Calc Conditional Formatting - Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods
)
Insert a row above row 11, and you should see cells B12 - E12 (now B13 -
E13) retain their green formatting. OK so far.
Now starting with the original test case again, make the following
modification:
In cells B12
Conditional Formatting - Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu
are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/235602
Title:
[upstream] [hardy] Calc Conditional Formatting - Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/235602
Title:
[upstream] [hardy] Calc Conditional Formatting - Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602
.
https://bugs.launchpad.net/bugs/235602
Title:
[upstream] [hardy] Calc Conditional Formatting - Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
- Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
/+source/libreoffice/+bug/235602
OOo bug may be found at:
http://openoffice.org/bugzilla/show_bug.cgi?id=4155
1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
- Incorrect cell
references after line or column insertions
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
No, it still does not work correctly neither for OO nor LO.
Cell references shall act the same way independent of whether they are
specified explicilty in the cell itself or by using conditional
formatting.
A correct result is that all four cells on row 12 remain green when
moved to row 13 after
becomes $B3 - correct
- * B$2 remains B$2 - incorrect, should become B$3
- * B2 becomes B3 - correct
+ cd ~/Desktop wget
+
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods
+ localc -nologo 'Conditional formatting
** Bug watch added: freedesktop.org Bugzilla #37987
http://bugs.freedesktop.org/show_bug.cgi?id=37987
** Also affects: df-libreoffice via
http://bugs.freedesktop.org/show_bug.cgi?id=37987
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a
** Changed in: df-libreoffice
Status: Unknown = Confirmed
** Changed in: df-libreoffice
Importance: Unknown = Medium
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/235602
Title:
Bowmore, this issue is unreproducible in LibreOffice Calc via the
Terminal:
cd ~/Desktop wget
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods
localc -nologo 'Conditional formatting example.ods'
Inserted a row
** Tags added: hardy
--
[upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references
after line or column insertions
https://bugs.launchpad.net/bugs/235602
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
** Changed in: openoffice
Status: Unknown = Confirmed
--
[upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references
after line or column insertions
https://bugs.launchpad.net/bugs/235602
You received this bug notification because you are a member of Ubuntu
Bugs, which
Possibly a bit more detailed information for the bug-solver:
I use a column, let's say J, with conditional formatting based on the values in
column D.
When I insert a new column left from D (or more than one column), the
references are updated.
When I insert a column between D and J, the
pboosman, what type of conditional formatting reference did you use in
your example?
If you by updated mean updated correctly that behaviour only applies
as far as I can see to relative addressing of columns, i.e columns not
prefixed by $. For absolute addressed columns I get the opposite result.
Thanks Chris for taking your time.
The issue 4155 you linked to was raised in 2002 (six year ago) but still
not solved! They refer to the modelling of the feature and claim it is
an enhancement rather than a bug. But this is not the case, it's a pure
bug, probably in the model itself! As I wrote
** Summary changed:
- OO Calc Conditional Formatting - Incorrect cell references after line or
column insertions
+ [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references
after line or column insertions
--
[upstream] [hardy] OO Calc Conditional Formatting - Incorrect
Do you still have this problem with openoffice.org 1:2.4.1-1ubuntu2 in
Ubuntu 8.04? I can't reproduce this issue with the current version.
** Changed in: openoffice.org (Ubuntu)
Status: New = Incomplete
--
OO Calc Conditional Formatting - Incorrect cell references after line or column
Yes, I still have this problem.
I think this bug has been there for quite a while but not detected
probably because this nice little feature is not frequently used. Myself
I detected it when porting Excel documents to Calc.
I attach an ods file as an example.
** Attachment added: Conditional
How do you view the conditional formatting rules that are applied, I
couldn't find them in the Format Cells menu.
Thanks,
Chris Cheney
--
OO Calc Conditional Formatting - Incorrect cell references after line or column
insertions
https://bugs.launchpad.net/bugs/235602
You received this bug
Oh nevermind I found it is hidden away under Format menu on the main
menubar.
--
OO Calc Conditional Formatting - Incorrect cell references after line or column
insertions
https://bugs.launchpad.net/bugs/235602
You received this bug notification because you are a member of Ubuntu
Bugs, which is
I now understand why I didn't see the bug I didn't look in the right
location before, the example file was very helpful and I found an
upstream bug report relating to the issue which I have linked.
Thanks,
Chris
** Bug watch added: OpenOffice.org Issue Tracker #4155
Another way of expressing this issue is that references for conditional
formatting and references explicitly given in corresponding cells shall
be treated (modified) in the same way when adding rows and/or columns to
the spreadsheet. Currently, this is not always the case.
--
OO Calc Conditional
Public bug reported:
Binary package hint: openoffice.org-calc
The OpenOffice.org 2.4.0 Calc Conditional Formatting does not work
properly in certain cases of absolute and relative addressing. This
occurres when adding rows or columns that affect the address of a cell
or cells that are part of a
33 matches
Mail list logo