Created attachment 173681 [details] Formula apear in second line hebrew Formula is not shown in formula line. show in second line when expand. Open new or existing sheet. stand on a not empty cell. the formula line does not show the data that in the cell, just blank. in order to see the data you should do one of: a. enter the formula field. b. press the expand formula line. if you work with expand formula line, you will see the data shown in the second line. (instead of the first). this shown in the attachment screen shot. the data is in the second line but there is nothing in the first line. you can not enter it. It start behaving like this many months ago but just now I try to figure it out. Is there a switch that change it ? It is realy strange. Is there a tool like mozregression or log that can find easily the problematic code ?
Created attachment 173683 [details] Formula apear in first line English
I tried to chang the "user interface" in the "languge settings". In English it is ok. I attached screen shot. I dont know if the problem is also in Arabic, because of direction, or just in Hebrew.
same in ver 7.1.4.2 Make me work with english user interface or move sadly to another application.
(In reply to Anat from comment #2) > I tried to chang the "user interface" in the "languge settings". > In English it is ok. > I attached screen shot. > I dont know if the problem is also in Arabic, because of direction, or just > in Hebrew. riyadhtalal: can you please check if this bug is also in arabic user interface ?? thus we will know if it is 'right to left' problem or 'hebrew' problem. Lior: can you please check if this bug happened to you also, with hebrew user interface ? to double check if it is general or only in my machine.
(In reply to Anat from comment #0) > Is there a tool like mozregression or log that can find easily the > problematic code ? I'm not familiar with mozregression so don't know how it works, but in LibreOffice the QA people and developers use bibisection (binary bi-section) to find which code change causes a regression. More details at: https://wiki.documentfoundation.org/QA/Bibisect However unfortunately, available bibisection repositories are English only, and won't be useful for this particular bug.
Reproduced with 7.2.0 RC1 on Windows 10: Version: 7.2.0.1 (x64) / LibreOffice Community Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: zh-CN (zh_CN); UI: he-IL Calc: threaded
(In reply to Ming Hua from comment #6) > Reproduced with 7.2.0 RC1 on Windows 10: > Version: 7.2.0.1 (x64) / LibreOffice Community > Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc > CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: > win > Locale: zh-CN (zh_CN); UI: he-IL > Calc: threaded Ming: can you please check the arabic UI ? to distinguish if it is just he-IL or it is all RTL.
(In reply to Anat from comment #7) > (In reply to Ming Hua from comment #6) > > Reproduced with 7.2.0 RC1 on Windows 10: > > Version: 7.2.0.1 (x64) / LibreOffice Community > > Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc > > CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: > > win > > Locale: zh-CN (zh_CN); UI: he-IL > > Calc: threaded > > Ming: can you please check the arabic UI ? Sure. Also reproducible with Arabic UI: Version: 7.2.0.1 (x64) / LibreOffice Community Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: zh-CN (zh_CN); UI: ar-SA Calc: threaded
I want to report behaviour that maybe will help to find the cause of the bug. hope this detailed behaviour will help fixing and also debug it. I found the behaviour exidentaly, but manage to reproduce it and its rulls. Stand in an empty cell. move to full cell as many as you wish the forlmula look empty and stay enpty. if you expand, you will see the content show in the second line. if you stand on the formula field, the content will apear in the first line. Stand in a full cell. touch the expand arrow. the content show in the second line. close the expand by touching the arrow again. move to another full cell as many as you wish. the forlmula look full. and stay full. if you expand, you will see the content show in the second line. the formula with expnad close, is full, until enter an empty cell. when entering an empty cell, the bug of empty formula comes back. so the content of the cell is always on the second line when expand is open. the content of the formula field is empty or full, when expand close, depend on visiting an empty cel (make it show empty) or visit a full cell + expand open once + expand close once + not visit an empty cell after(make it show the content). standing on the formula field, does not make the content reapear for the next full cells. only for the current full cell. Only expand and close, make the content reapear for the next full cells. Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: he-IL (he_IL); UI: he-IL Calc: CL
Ming: Can you please try to reproduce in your machine the behaviour with the workaround I described last week ? Do you know who can fix the problem in those blocks and cc him ?
(In reply to Anat from comment #10) > Ming: > Can you please try to reproduce in your machine the behaviour with the > workaround I described last week ? Not sure exactly what "workaround" you are describing, also I don't see much benefit in reproducing a workaround. > Do you know who can fix the problem in those blocks and cc him ? Sorry, I don't know any developer on a personal level. CC'ing people individually on a specific bug should be done with caution, and I consider adding meta bugs to "Blocks:" field adequate for attracting developers' attention. You can go to the QA team's [1] IRC or mailing list for additional help if wish. 1. https://wiki.documentfoundation.org/QA
(In reply to Anat from comment #9) > I want to report behaviour that maybe will help to find the cause of the bug. > hope this detailed behaviour will help fixing and also debug it. > I found the behaviour exidentaly, but manage to reproduce it and its rulls. > > Stand in an empty cell. > move to full cell as many as you wish > the forlmula look empty and stay enpty. > if you expand, you will see the content show in the second line. > if you stand on the formula field, the content will apear in the first line. > > > Stand in a full cell. > touch the expand arrow. > the content show in the second line. > close the expand by touching the arrow again. > move to another full cell as many as you wish. > the forlmula look full. and stay full. > > if you expand, you will see the content show in the second line. > the formula with expnad close, is full, until enter an empty cell. > when entering an empty cell, the bug of empty formula comes back. > > > so the content of the cell is always on the second line when expand is open. > > the content of the formula field is empty or full, when expand close, > depend on visiting an empty cel (make it show empty) or visit a full cell + > expand open once + expand close once + not visit an empty cell after(make it > show the content). > > standing on the formula field, does not make the content reapear for the > next full cells. only for the current full cell. > Only expand and close, make the content reapear for the next full cells. > > > Version: 7.1.4.2 (x64) / LibreOffice Community > Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 > CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: > win > Locale: he-IL (he_IL); UI: he-IL > Calc: CL Ming: it is not realy a workaround, it is the bug behaviour or how to reproduce it. I copied it here above. Maybe, that is why it was not raised before. cause it depend on what you do few steps. I will try your suggestion. Hope some one will see the bug soon. thank you
can someone please try fix this bug ? it is in hebrew and arabic. RTL. I put, a year ago, directions above exactly how to reproduce it.
(In reply to Anat from comment #13) > can someone please try fix this bug ? You're misunderstanding the state of affairs of LibreOffice. There are ~17,000 open bugs, and very very few developers. If we nag and nag, TDF may devote some resources to solve a bug we find important, once even couple of years or so. Other RTL bugs do get resolved at some rate, but it's rather slow, and it's not really based on users making demands on the bug page. Remember - LibreOffice is a free software project, with a small budget and a small income from occasional donations. > I put, a year ago, directions above exactly how to reproduce it. That is why its status is NEW rather than UNCONFIRMED...
Marking as a duplicate of newer bug 149777, as there is more information there. *** This bug has been marked as a duplicate of bug 149777 ***