Bug 41304 - EDITING: Cell formula shown without colors, colored frames missing around referenced cells (see comment 17)
Summary: EDITING: Cell formula shown without colors, colored frames missing around ref...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 47094 117979 (view as bug list)
Depends on:
Blocks: Cell-Formula Cell-Reference
  Show dependency treegraph
 
Reported: 2011-09-28 10:52 UTC by stallersattel
Modified: 2021-06-05 15:58 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample Document, see Comment 1 (21.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-29 06:27 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description stallersattel 2011-09-28 10:52:02 UTC
Action: Double click on a cell containing a formula. 
Result: The formula will reappear and each cell included in the formula will be 
        color coded.

Unfortunately this does not apply to cells
(1) which reside within a sheet whose sheet name contains space and/or dash 
    (e.g.).
    In other words:
    The problem appears if a cell reference in the formula is prefixed with
    a sheet name which contains space and/or dash. Any cell referenced 
    this way will not be color coded.

    Workaround: eliminate any spaces and dashes in sheet names of affected 
                sheets

(2) which are referenced in a formula followed by "%", e.g. cell C1 contains 
    =B1/A1%.
    For clarification: cell A1 will not be colour coded when C1 is double
    clicked whereas B1 will be color coded.

    Workaround: add a space between cell reference and %: =B1/A1 %
Comment 1 Rainer Bielefeld Retired 2011-09-29 06:25:33 UTC
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]", see attached sample document!
1 Problem is that colors will not be shown in document, second problem is that non colored cell references in formula will not show colored frame around the referenced cells.
Comment 2 Rainer Bielefeld Retired 2011-09-29 06:27:12 UTC
Created attachment 51755 [details]
Sample Document, see Comment 1

@Kohei:
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 3 Rainer Bielefeld Retired 2011-10-23 23:44:28 UTC
"Bug 41915 - named cells not highlighted when editing formulae" seems to show an additional aspect of the problem
Comment 4 Björn Michaelsen 2011-12-23 13:23:14 UTC Comment hidden (obsolete)
Comment 5 stallersattel 2011-12-26 20:59:13 UTC
The same issues could be detected in LOdev 3.5.0 beta2.
Comment 6 ign_christian 2013-10-19 09:52:55 UTC
*** Bug 47094 has been marked as a duplicate of this bug. ***
Comment 7 ign_christian 2013-10-19 09:54:04 UTC
Changing Version & Plattform fields based on Bug 47094
Comment 8 QA Administrators 2015-04-01 14:40:09 UTC Comment hidden (obsolete)
Comment 9 Buovjaga 2015-04-20 15:20:48 UTC
Confirmed with attachment 51755 [details].

Win 7 Pro 64-bit Version: 5.0.0.0.alpha0+ (x64)
Build ID: 211c12b9c64facd1c12f637a5229bd6a6feb032a
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-18_01:51:17
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 10 QA Administrators 2016-09-20 09:32:09 UTC Comment hidden (obsolete)
Comment 11 Lorrin 2017-04-01 05:22:08 UTC
I can confirm that the problem still exists as described. Observed on:

Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial1
CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 12 Xavier Van Wijmeersch 2017-07-16 15:15:04 UTC
Confirmed with attachment 51755 [details].

Version: 6.0.0.0.alpha0+
Build ID: 8c82e4877181f55f2fe186b341d504e5782a4f9c
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 13 David 2018-06-03 10:51:13 UTC
I can confirm this: https://bugs.documentfoundation.org/show_bug.cgi?id=117979

Very odd behavior. Highlighting is quite important to reduce risk of errors. How should someone figure out that the sheet cannot use spaces in between?
Comment 14 Buovjaga 2018-06-03 11:00:12 UTC
*** Bug 117979 has been marked as a duplicate of this bug. ***
Comment 15 QA Administrators 2019-06-04 02:50:37 UTC Comment hidden (obsolete)
Comment 16 QA Administrators 2021-06-04 04:05:14 UTC Comment hidden (obsolete)
Comment 17 Rainer Bielefeld Retired 2021-06-05 14:57:10 UTC
(1) is NO LONGER reproducible with Installation of Version 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE, Theme 'Elementary'
Calc: threaded

(2) is still visible in this Version. Due to "only 1 issue per report" a new report for (2) might be appropriate so that this report can be closed for (1)?
Comment 18 Buovjaga 2021-06-05 15:58:05 UTC
(In reply to Rainer Bielefeld Retired from comment #17)
> (1) is NO LONGER reproducible with Installation of Version 7.0.5.2 (x64)
> Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
> CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
> Skia/Raster; VCL: win
> Locale: de-DE (de_DE); UI: de-DE, Theme 'Elementary'
> Calc: threaded
> 
> (2) is still visible in this Version. Due to "only 1 issue per report" a new
> report for (2) might be appropriate so that this report can be closed for
> (1)?

I think we could in this case just keep this open - adjusting summary to point to your comment.