[Libreoffice-bugs] [Bug 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #20 from QA Administrators --- Dear plasticassius, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #19 from QA Administrators --- Dear plasticassius, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- 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 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 TBeholder changed: What|Removed |Added CC||turbobehol...@mail.ru --- Comment #18 from TBeholder --- In other words, everything is pasted into cells with its own format, if at all possible — unless you paste it into during cell editing or into formula bar rather than cell. Seems to be the same, but appears in slightly different circumstances. I select a fragment of text from one cell and pasting into another via primary buffer (MMB in Linux, support in Options-LibreOffice-View). But this pastes text with its old format, even though it was just a selection, not cell. Format-Clear Formatting (Ctrl-M) resets to the cell's assigned old format. IMHO not too bad, just make it controllable, especially in case of Text Import dialog, much like Paste/Special does. That's most likely what causes another problem (I wanted to submit a bug, but now it looks like it would be a duplicate): there's no way to explicitly set the intended format, and the field's own format is circumvented by pasting, thus there's no way to avoid having pasted text like "00234E67" (hexadecimal value) converted (into 2.34E+69). Which is bad, because data is borked and Ctrl-M isn't going to fix this. -- 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 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Eike Rathke changed: What|Removed |Added CC||er...@redhat.com --- Comment #17 from Eike Rathke --- I'd rather say that if a column was already formatted to type Date(+Time) like MM-DD HH:MM then when pasting a text that can be forced to type Date should not alter the format already applied, as happens with the first attachment in the second column when forced to Date (DMY), but not with the ISO type dates of the second attachement in the first column if it is not forced to Date (YMD). (Provided "Detect special numbers" is checked in both cases) -- 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 103000] Text paste into spreadsheet clears cell formatting if in Text Import dialog Column type set to Date (YMD)
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Timur changed: What|Removed |Added Hardware|x86-64 (AMD64) |All Summary|text paste into spreadsheet |Text paste into spreadsheet |clears cell formatting |clears cell formatting if ||in Text Import dialog ||Column type set to Date ||(YMD) Severity|normal |minor Priority|medium |low --- Comment #16 from Timur --- Yes, that's what I didn't do. If I skip "paste & set Column type to Date (YMD)" and just simply press OK o Text Import, all is fine and format is Date -MM-DD HH:MM. But than title is wrong, simple text paste is OK, but the function "Column type" is unclear. I don't see this as a bug because steps involve mutually unnecessary steps of setting format to Date -MM-DD HH:MM and also setting Column type to Date (YMD). I'd rather turn this bug to Ducumentation to have explanation how this Column type set works. And after that we may open a bug for correct behavior. I see there was help page on "Text Import" in offline help, but I can't find it in online help. Help button on Text import doesn't work for me. I could find only https://help.libreoffice.org/6.2/en-US/text/scalc/guide/csv_files.html which doesn't explain options. -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Buovjaga changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #15 from Buovjaga --- (In reply to Timur from comment #14) > I failed to reproduce this in Windows on reported LO 5.1 and master LO 6.3+. > Maybe steps from Comment 10 are not precise enough. > I get Text import dialog on paste, not clear if relevant. > Xisco and Buovjaga, please test again. Still repro with 6.2 beta1 (Win). In the Text import dialog, you have to select the header that says "Standard" and change the column type from the drop down to Date (YMD) -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Timur changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #14 from Timur --- I failed to reproduce this in Windows on reported LO 5.1 and master LO 6.3+. Maybe steps from Comment 10 are not precise enough. I get Text import dialog on paste, not clear if relevant. Xisco and Buovjaga, please test again. -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #13 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #12 from plasticass...@gmail.com --- Yes I agree, it is the same for me also on version Version: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Locale: en_US.UTF-8 Unfortunately, I can't very well replicate my previous setup with LO 4 since I had Ubuntu 14.04 at the time. However, it did indeed preserve the formatting in cells when I pasted unformatted text to it. Now I don't know how it could do that, but it worked that way for me for so long that I got used to it and assumed that must be the correct way for it to work. -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Buovjaga changed: What|Removed |Added Keywords|regression | Status|UNCONFIRMED |NEW Version|5.1.4.2 release |3.5.0 release Ever confirmed|0 |1 OS|Linux (All) |All --- Comment #11 from Buovjaga --- (In reply to plasticassius from comment #10) > I can confirm problem exists in > > Version: 5.2.3.1 > Build ID: 01ec8f357e651ca9656837b783cf7e6a32ee4d92 > CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; > Locale: en-AU (en_US.UTF-8); Calc: group > > Procedure: > > select column A > set format to Date -MM-DD HH:MM > open p2.txt and copy contents > select cell A3 > paste & set Column type to Date (YMD) > cell A3 format is now Date DD/MM/YY HH:MM > > This is different than in LO 4 since the format of the cells > have now changed. I repro. Due to locale (Finnish), I get a different result DD.MM.YY HH:MM. However, I get this result in 4.4, 4.3, 4.1. What's more, I get this result even in 3.5. Are you sure this is different from LibO 4? Please recheck: https://wiki.documentfoundation.org/Installing_in_parallel Win 7 Pro 64-bit Version: 5.3.0.0.alpha1+ Build ID: 4b4abb73fcd7f2802e73102b3e7c30face8d309c CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: old; TinderBox: Win-x86@39, Branch:master, Time: 2016-10-31_02:54:50 Locale: fi-FI (fi_FI); Calc: group LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735 -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 plasticass...@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #10 from plasticass...@gmail.com --- I can confirm problem exists in Version: 5.2.3.1 Build ID: 01ec8f357e651ca9656837b783cf7e6a32ee4d92 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; Locale: en-AU (en_US.UTF-8); Calc: group Procedure: select column A set format to Date -MM-DD HH:MM open p2.txt and copy contents select cell A3 paste & set Column type to Date (YMD) cell A3 format is now Date DD/MM/YY HH:MM This is different than in LO 4 since the format of the cells have now changed. -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #9 from Buovjaga --- (In reply to Jean-Baptiste Faure from comment #8) > Please, could you give a try to current LO 5.2 ? Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #8 from Jean-Baptiste Faure --- Not reproducible for me with both master and 5.2.4.0+ version built at home under Ubuntu 16.04 x86-64. Please, could you give a try to current LO 5.2 ? Best regards. JBF -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #7 from plasticass...@gmail.com --- Yes, ### means that the cell size is too small to display the contents. The point is that the formatting is not preserved during the paste. The paste set yours to DD/MM/YY HH:MM. If you had set it to something else before the paste (ie: -MM-DD HH:MM), you would see that it is not the same after. Pasting plain text over cells that already had been formatted would preserve that formatting in previous versions, now it is reset. The format you are seeing (DD/MM/YY HH:MM) is likely calc's best guess at what a date should look like. If you check the cell format after the paste, it likely shows Number General rather than Date at all. If you had set the cell's format to Date, that formatting would have been 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #6 from Xisco Faulí --- In my case, if I open p2.txt in gedit or leafpad and then I copy the content to Calc, the cells look like ###. However, if a press Ctrl+1 the format code is DD/MM/YY HH:MM Version: 5.3.0.0.alpha0+ Build ID: 8974b0fafb18f9dd3f2c0e175a3255b80e4c249e CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; Locale: ca-ES (ca_ES.UTF-8); Calc: group -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #5 from plasticass...@gmail.com --- Created attachment 128184 --> https://bugs.documentfoundation.org/attachment.cgi?id=128184&action=edit example date column modifies format of cell it is pasted into -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #4 from plasticass...@gmail.com --- Created attachment 128183 --> https://bugs.documentfoundation.org/attachment.cgi?id=128183&action=edit example tab seperated, date column modifies format of cell it is pasted into -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 --- Comment #3 from Jean-Baptiste Faure --- Thank you for your answer. From your comment #2 it seems that the issue depends on the text to be copy-pasted. Could you attach an example of such a text? Best regards. JBF -- 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 103000] text paste into spreadsheet clears cell formatting
https://bugs.documentfoundation.org/show_bug.cgi?id=103000 tommy27 changed: What|Removed |Added Keywords||regression CC||ba...@quipo.it Summary|regression: text paste into |text paste into spreadsheet |spreadsheet clears cell |clears cell formatting |formatting | -- 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