[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 Elmar changed: What|Removed |Added Status|NEW |UNCONFIRMED Ever confirmed|1 |0 --- Comment #7 from Elmar --- I think this has been resolved in v6.1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 --- Comment #6 from Elmar --- Afterthought: Interestingly, Excel 2013 quite happily accepts my Calc xls save - when I unmerge the cells, the first option (No) returns it the way it was before I merged. Of course, in the case of the Yes option, the 2nd and 3rd cells are empty as expected. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 --- Comment #5 from Elmar --- Created attachment 126515 --> https://bugs.documentfoundation.org/attachment.cgi?id=126515&action=edit Proposal for resolving the issue -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 --- Comment #4 from Elmar --- Buovjaga: yes, I go the same results. So this is an education issue. Problem: MS is the dominant player and thus many will have used Excel first before coming to Calc. Excel 2013 offers a number of options in the merge, but all of them convert the contents to text. What to do? The text in Calc says: "Should the contents of the hidden cells be moved to the first cell?" Here are some options: "Should the contents of the hidden cells be moved to the first cell and converted to text?" or "Should the contents of the hidden cells be moved to the first cell? Yes: convert to text No: selected cell determines what to display in merged view" You say 5.3 adopts the MS approach. I think there is a case to be made to keep the up-to-Calc 5.2 approach. The reason: have a look at the new example. If I have a formula which includes too much text to display in a cell I can simply merge cells which I don't need to display. This is a far more elegant solution that what is offered by Excel 2013 (which I have shown in the shaded text box.) In Excel, the contents of the merged merged cells is lost. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #3 from Buovjaga --- (In reply to Elmar from comment #1) > Created attachment 126407 [details] > merge cells loses formula > > cells c4 and c5 contained the same formula before the merge. > cells c4-e4 is the result after the merge Could repro in 5.1.4, if I answered "Yes" to the question of whether to move content of empty cells. In 5.3 it did not ask and there was no problem. With your document, I merged and centered C5-E5. Elmar: could you test with 5.2? 64-bit, KDE Plasma 5 Build ID: 5.1.4.2 Arch Linux build-1 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: c1b665fcdacd4141137f1e369527e2c0d94513ae CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on July 26th 2016 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 --- Comment #2 from Elmar --- Created attachment 126408 --> https://bugs.documentfoundation.org/attachment.cgi?id=126408&action=edit ms excel example after the merge cells provided for comparative purposes -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 101124] MERGE and centre cells loses formula
https://bugs.documentfoundation.org/show_bug.cgi?id=101124 --- Comment #1 from Elmar --- Created attachment 126407 --> https://bugs.documentfoundation.org/attachment.cgi?id=126407&action=edit merge cells loses formula cells c4 and c5 contained the same formula before the merge. cells c4-e4 is the result after the merge -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
