https://bugs.freedesktop.org/show_bug.cgi?id=73032
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Severity|major |critical Priority|high |medium Component|Spreadsheet |Libreoffice Ever confirmed|0 |1 --- Comment #8 from mariosv <[email protected]> --- Hi Diego, translation wasn't the matter, the question was about to know exactly what are you talking about. In my opinion, a spreadsheet it isn't the proper tool for a work with a such amount of data, better I think with a database tool. E.g. every time you change the font for more than 11 million of cells, calc needs to recalculate the high for every changed cell to set up the high for the row. If you keep undo steps for more than 0, all this changes needs to be kept, to make possible the undo. If you want to do it with calc, IMHO then you need reduce any special formats as much as possible. 1- There are two OLE objects, that seems they are there by error. To locate it, use Menu/View/Navigator [F5] 2- Reduce or better avoid the formats specially in long data table, and more specially the direct formats. 3- Use default format as much as possible, you can change it, Menu/Format/Styles&Formatting [F11] 4- Take care of the style's use, hierarchically sorted, you can change the font in default style, or in a hierarchy style level. Making much easier to maintain the formatting. 5- Delete conditional formatting if you can, or reduce it to a not large ranges. 6- Put every data table in their sheet. 7- Let formats for when you have finished the work, save a lot of work hours, and it makes easy find when the problems appear. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
