Bug 99606 - Very long and complex furmulas in calc are shown unclear
Summary: Very long and complex furmulas in calc are shown unclear
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-01 13:03 UTC by Simona Pisano
Modified: 2016-05-03 12:07 UTC (History)
2 users (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 Simona Pisano 2016-05-01 13:03:59 UTC
The Calc module if you use very long and complicated formulas, the display is unclear. In particular in the top bar is not displayed more than one line of formulas, do not highlight the cells used with distinct color and are not shown in the spreadsheet, the letters designating the first line is often defaced that reports of columns, the formula is displayed even within the sheet, in the related cell, but this widens and makes it unreadable, because it blankets the surrounding cells. I think of those coming from Libreoffice Execel with long formulas 3-4 lines in both objective and practical difficulties. It would be great to be able to improve this aspect of what has now become a great package.
Comment 1 Simona Pisano 2016-05-01 13:05:26 UTC
The Calc module if you use very long and complicated formulas, the display is unclear. In particular in the top bar is not displayed more than one line of formulas, do not highlight the cells used with distinct color and are not shown in the spreadsheet, the letters designating the first line is often defaced that reports of columns, the formula is displayed even within the sheet, in the related cell, but this widens and makes it unreadable, because it blankets the surrounding cells. I think of those coming from Libreoffice Execel with long formulas 3-4 lines in both objective and practical difficulties.
Comment 2 m_a_riosv 2016-05-01 15:41:22 UTC
Hi @Simona, if I understand your question, at the right of the edit bar there is a little triangle to expand for more lines, and you can adjust the number of lines, resizing with the bottom line of the edit bar.
Comment 3 Simona Pisano 2016-05-01 16:18:52 UTC
Thx :-))) I will try.
Comment 4 Cor Nouws 2016-05-03 12:07:54 UTC
Thanks Miguel, I think this is resolved.