Bug 137775 - LibreOffice Calc - Sheets with per cent format don't actualize new data
Summary: LibreOffice Calc - Sheets with per cent format don't actualize new data
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-26 18:16 UTC by Bernardo Romay
Modified: 2020-10-26 18:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Bernardo Romay 2020-10-26 18:16:01 UTC
Description:
When I change the valours of a per cent formated sheet in a formula, the data don't change. Example:
Sheet A1 = 10
Sheet A2 = 5
Sheet A3 (per cent format) = A2/A1 = 50 %.
If I change A2 = 2; A3 doen't change to A3 0 20 %.

In previous versions, the values changed correctly.

Regards.

Actual Results:
When I change the valours of a per cent formated sheet in a formula, the data don't change. Example:
Sheet A1 = 10
Sheet A2 = 5
Sheet A3 (per cent format) = A2/A1 = 50 %.
If I change A2 = 2; A3 doen't change to A3 0 20 %.

In previous versions, the values changed correctly.

Regards.

Expected Results:
When I change the valours of a per cent formated sheet in a formula, the data don't change. Example:
Sheet A1 = 10
Sheet A2 = 5
Sheet A3 (per cent format) = A2/A1 = 50 %.
If I change A2 = 2; A3 doen't change to A3 0 20 %.

In previous versions, the values changed correctly.

Regards.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Ming Hua 2020-10-26 18:34:21 UTC
Thanks for reporting.  This issue actually has nothing to do with the percent format, but is a bug with auto-recalculation, and has been reported as bug 137248.  It has been fixed and the upcoming 7.0.3 release will contain the fix.

*** This bug has been marked as a duplicate of bug 137248 ***