You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/10/25 19:16:18 UTC
[Bug 123549] New: per cent modifier of cell name inhibits highlight
of source data
https://issues.apache.org/ooo/show_bug.cgi?id=123549
Bug ID: 123549
Issue Type: DEFECT
Summary: per cent modifier of cell name inhibits highlight of
source data
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: wrightash@hotmail.com
CC: issues@openoffice.apache.org
Example
() for suggested data
In new sheet enter number A1 (20)
enter number B1 (10)
enter formula C1 = B1 / A1 (shows 0.5)
Double click on C1
Results A1 highlit in Blue B1 highlit in Red CORRECT
change formula in C1 to = A1 / B1% (shows 50)
Double click on C1
Results A1 no effect, B1 highlit in Blue WRONG
The non-highlight of the source cell only occurs when the "%" modifier is used.
In the case shown, the A1% is identical to (B1/100)
Entering in C1 = A1 / (B1/100) highlights both A1 and B1 on a
double click of C1
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123549] per cent modifier of cell name inhibits highlight of
source data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123549
Edwin Sharp <el...@mail-page.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |elish@mail-page.com
Ever confirmed|0 |1
OS|Windows XP |Windows, all
--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
=B1/A1 : B1 blue, A1 red
=A1/B1%: =200, A1 blue, B1 black
AOO410m1(Build:9750) - Rev. 1532700
Rev.1532700
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.