User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586 Build Identifier: LibreOffice 5.0.6.3 I download my statements in excel or cvs format from various sites and then put them in a workbook. When using the Move/Copy Sheet to a different workbook actions are grayed out and copy is the only choice so after I copy the sheet, I have to delete the original. Besides the extra step from what I'm used to with Office, there's always the chance of deleting the wrong sheet. Reproducible: Always Steps to Reproduce: 1. Download a cvs or excel format file from a site. 2. Click on the sheet tab and choose Move/Copy Sheet. 3. Note the Actions are grayed out and the button is set to copy. Actual Results: A copy of the sheet is inserted into the other workbook and then the original sheet will need to be deleted. Expected Results: A user should be able to move the sheet in one step. [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Reset User Profile?No
Not reproduced. By "workbook" I assume you mean "document". Please try with 5.1.x Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: e1ca24369142af3e721e789bf757be671e1905b7 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on June 10th 2016 Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
I haven't found version 5.1 to download yet. I'm using Version: 5.0.6.3. To be clearer, the steps are: 1. open a sheet that has been saved (.xls or .ods). 2. open a different sheet and right click on the tab of the second sheet. 3. choose Move/Copy sheet. 4. the actions are grayed out with "copy" as the selection.
http://www.libreoffice.org/download/libreoffice-fresh/(In reply to Terry Kyriss from comment #2) > I haven't found version 5.1 to download yet. I'm using Version: 5.0.6.3. To > be clearer, the steps are: > 1. open a sheet that has been saved (.xls or .ods). > 2. open a different sheet and right click on the tab of the second sheet. > 3. choose Move/Copy sheet. > 4. the actions are grayed out with "copy" as the selection. Ok now I get it, but I don't know if this is intentional. If you add another sheet to the 2nd document before opening the Move/copy dialog, then the actions are not greyed out. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: e1ca24369142af3e721e789bf757be671e1905b7 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on June 10th 2016
Markus on IRC confirmed that this is a bug and looks like it is caused by this change: https://cgit.freedesktop.org/libreoffice/core/commit/?id=9e96d3e1e53d72453bdd5cfa6447b0d58a3d85c1
Personally, I don't consider this a bug and I'd recommend this be closed as NotaBug or WintFix. I'd do it myself should there be no previous comment. LO cannot delete the last sheet and have empty workbook. If there's 1-sheet document, it's normal to have only copy and delete the document. Move the only sheet doesn't make sense.
This is not a bug. At least one sheet should be exist in a workbook (spreadsheet). If the only sheet is deleted, the spreadsheet is not a spreadsheet anymore.
Well, Timur & Kevin, please talk to Markus about it.
Timur & Kevin, did you have the change to talk to Markus?
No, but I think compromise is to rename this to "Copy" only. Move doesn't make sense. Even than it's trivial, because you can add empty sheet.
** 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
Still repro in 6.1.1.1 but I want add my 5 cents. We can: Variant 1: In case when we have only one sheet in workbook we should have only one variant "Copy sheet" in dialogue "Move/Copy sheet". Variant 2: Don't touch dialogue, but if we moved (copy and then delete) sheet when there is only one sheet, then should be insert a new empty sheet in source workbook. Variant 3: make two different item "Copy sheet" and "Move sheet" and two dialogue. And when there is only one sheet user shouldn't see item "Move sheet" Variant 4: close this bug as WONTFIX, because it works as expected now and user can't shot in his own leg @Heiko: what do you think? We need some UX help
(In reply to Roman Kuznetsov from comment #11) > @Heiko: what do you think? We need some UX help Question goes to all UX folks: c4, c5, and c11.
Looking at Kohei's commit (comment 4) I don't see this as a bug. The behavior makes sense--you can not move the last sheet from an ODF Spreadsheet document in Calc and have it remain a valid spreadsheet/workbook. With ref commit, documents containing multiple sheets do allow moving sheet to other document. IMHO => NAB & WF
Let me remind that I renamed "Move/Copy" to just "Copy" and marked "trivial" because you can add empty sheet and than copy. Bug doesn't make much sense, but we may keep it and thus prevent some future duplicates.
Okay, so let's close as NAB. Duplicates can be done anyway.
I just checked and now both move and copy are grayed out if there is only one sheet in a workbook although the sheet can be moved. Having the ability to move a sheet is necessary when a user downloads a spreadsheet and wants to put it into a workbook that he/she has already created. This is a trivial bug but it involves two steps when there could be one (as is the case in Excel).
(In reply to Terry Kyriss from comment #16) > Having the ability to move a sheet is necessary when a user downloads a > spreadsheet and wants to put it into a workbook that he/she has already > created. This is a trivial bug but it involves two steps when there could > be one (as is the case in Excel). All this talk about Excel started bothering me, so I tested with Excel 2013. The claim is false: Excel does not allow you to move a sheet, if it is the sole one in the document. It shows an error dialog, if you attempt it.
I'm a bit late but: I can live with NAB but from usability perspective I prefer proposal (variant) 2 of Roman's comment 11: 'Don't touch dialogue, but if we moved (copy and then delete) sheet when there is only one sheet, then should be insert a new empty sheet in source workbook.' Technically the actual behavior os logical but not from normal user's perspective. There is no difference between moving one of some sheets and moving of the only sheet of a spreadsheet. This difference now lead on to questions like this bug report or to an explanation in the help files. For what? We wouldn't need any explanation with the above proposal. The user is free to move whatever wherever he wants. For me that's the best usability solution.
*** This bug has been marked as a duplicate of bug 56973 ***