[Libreoffice-bugs] [Bug 142598] New: The result of Calc formula with CHAR(9) is not equal to a tab of IDE

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 1 10:48:34 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=142598

            Bug ID: 142598
           Summary: The result of Calc formula with CHAR(9) is not equal
                    to a tab of IDE
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nukool at gmail.com

Description:
In LibreOffice for Linux - Copy the result of CHAR(9) of Calc formula and paste
in LibreOffice CALC BASIC IDE,the tab length is shorter than the tab length of
the IDE. On the other hand, it is equal in LibreOffice for Windows.

Steps to Reproduce:
1.Open LibreOffice Calc for Linux
2.Enter '0' to cell A2 and cell B2
3.Enter 'ABC' to cell C2
4.Enter a formula,
  =CONCAT(CHAR(9),"oSheet.getCellByPosition(",A2,", ",B2,")",".String =
","""",C2,"""")
  to cell D2
5.Open BASIC IDE
6.Edit any code area
7.Copy from cell D2
8.Paste in IDE code area


Actual Results:
The tab length from the result of CHAR(9) is only 1, but the default tab length
of the IDE is 4. 

Expected Results:
The tab length from the result of CHAR(9) must be equal to the default tab
length of the IDE.


Reproducible: Always


User Profile Reset: No



Additional Info:
Ref:
https://ask.libreoffice.org/en/question/312106/copy-the-result-of-char9-of-calc-formula-and-paste-in-libreoffice-calc-basic-ide/

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210601/42c15d00/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list