https://bugs.documentfoundation.org/show_bug.cgi?id=160720
Bug ID: 160720
Summary: $ at Sheet1.A1 cell contents appears when saving in
xlsx extension
Product: LibreOffice
Version: 7.6.6.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For example, a Sheet1 cell A1 content is '=+Sheet2.A2', after saving the
spreadsheet in xlsx extension, when I open it, the Sheet1.A1 content is now
'=+$Sheet2.A2. A '$' appears in front off any Sheet name. When I save it in
'ods' extension, it does not happen.
Steps to Reproduce:
1.At Sheet1.A1 cell, type +Sheet2.A2
2.Save As a xlsx type file.
3.Close spreadsheet.
4.Open spreadsheet and look at cell Sheet1.A1 content.
Actual Results:
At step 1, cell content is '=+Sheet2.A2'.
At step 4, cell content is '=+$Sheet2.A2'.
Expected Results:
The expected result is '=+Sheet2.A2'.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); UI: pt-BR
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
