Description: The Delete Sheet and Move/Copy Sheet options are greyed out. The spreadsheet has no protection i.e. these functions should be enabled. Steps to Reproduce: 1.Open spreadsheet 2.Select tab 3.Select Sheet/Delete or Move/Copy Actual Results: Delete and Move/Copy are greyed out (not available) Expected Results: Nothing. I had to port the spreadsheet to a Windoze machine and delete the sheets using Excel. Reproducible: Always User Profile Reset: Yes Additional Info: I've been using LibreOffice for years and used to be able to delete or move/copy sheets but the last three versions installed have acted as described above. LibreOffice/About LibreOffice: Version: 6.0.3.2 Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 CPU threads: 4; OS: Mac OS X 10.13.4; UI render: default; Locale: en-AU (en_AU.UTF-8); Calc: group Opened LibreOffice in Safe Mode and loaded the spreadsheet with the same results. (User profile OK). Enabling Open GL in LibreOffice Preferences produced the same results. GL currently disabled. Using Anti-aliasing. MacBook Pro 6,1 M540 @ 2.53 Ghz Intel CPU x 4 RAM: 8 Gb Renderer: NVIDIA GeForce GT 330M OpenGL Engine Vendor: NVIDIA Corporation Memory: 512 MB Version: 3.3 NVIDIA-10.4.14 310.90.30.05b27 Device: MacBookPro6,1 Shading language version: 3.30 Max texture size: 8192 x 8192 Max vertex texture image units: 16 Max texture image units: 16 Max geometry texture units: 16 Max anisotropic filtering value: 16 Max viewport size: 8192 x 8192 Max Clip Distances: 8 Max samples: 8 Extensions: 37 GL_APPLE_texture_range GL_EXT_framebuffer_multisample_blit_scaled GL_ARB_viewport_array GL_ARB_explicit_attrib_location GL_NV_texture_barrier GL_ARB_separate_shader_objects GL_ARB_texture_storage GL_ARB_texture_swizzle GL_EXT_texture_compression_s3tc GL_ARB_texture_cube_map_array GL_ARB_blend_func_extended GL_EXT_texture_sRGB_decode GL_EXT_texture_filter_anisotropic GL_APPLE_row_bytes GL_ARB_texture_query_lod GL_ARB_draw_buffers_blend GL_ARB_sample_shading GL_ARB_internalformat_query GL_EXT_texture_mirror_clamp GL_ARB_timer_query GL_ATI_texture_mirror_once GL_EXT_debug_marker GL_APPLE_rgb_422 GL_ARB_vertex_type_2_10_10_10_rev GL_EXT_debug_label GL_ARB_instanced_arrays GL_APPLE_container_object_shareable GL_ARB_ES2_compatibility GL_APPLE_client_storage GL_ARB_sampler_objects GL_ARB_occlusion_query2 GL_ARB_shading_language_include GL_EXT_depth_bounds_test GL_ARB_texture_rgb10_a2ui GL_APPLE_object_purgeable GL_ARB_shader_bit_encoding GL_APPLE_flush_render Core features v3.0 (100 % - 23/23) v3.1 (100 % - 8/8) v3.2 (100 % - 10/10) v3.3 (100 % - 10/10) v4.0 (28 % - 4/14) v4.1 (42 % - 3/7) v4.2 (15 % - 2/13) v4.3 (0 % - 0/23) v4.4 (0 % - 0/10) v4.5 (0 % - 0/11) v4.6 (0 % - 0/11) vARB 2015 (0 % - 0/12) OpenGL driver version check (Current: 3.3 NVIDIA-10.4.14 310.90.30.05b27, Latest known: ): Latest version of display drivers found According the database, you are running the latest display drivers for your video card. User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15
Can not confirm on Windows 10 Home 64-bit en-US with Version: 6.0.4.1 (x64) Build ID: a63363f6506b8bdc5222481ce79ef33b2d13c741 CPU threads: 4; OS: Windows 10.0; UI render: GL; Locale: en-US (en_US); Calc: CL STR Move sheet: 1. create two calc documents 2. add 3 sheets to first doc and add content to a few cells 3. add 2 sheets to second doc and add content to a few cells 4. select 3rd sheet of first doc 5. from main menu open Sheet -> Move or Copy Sheet... dialog 6. select the Move (or Copy )radio button 7. select To document (the other, or a new doc) 8. select the insert location 9. OK Sheet is moved from first doc to second doc, if copy rather than move RB is selected it copies. Delete sheet: 1. use the existing open docs 2. select one of the sheets 3. from main menu Sheet -> Delete Sheet... 4. on click of the menu entry the sheet is deleted. All entries on the Sheet menu seem to function as intended.
No repro with Version: 5.4.6.2 Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8 Threads CPU : 4; OS : Mac OS X 10.13.4; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group
No repro with Version: 6.0.3.2 Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 Threads CPU : 4; OS : Mac OS X 10.13.4; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group @adrians: please provide us with a sample problematic spreadsheet file with which we can test. Does the sheet have any copy/edit protection in place ? Setting to NEEDINFO pending requested information / test file.
@adrians: forget my question about sheet/cell protection, I see you have indicated that none is activated. Sample problematic file still necessary though a two separate QA testers have reported this as working. My steps : 1) Create a new Calc file. 2) Type some content into a random number of cells. 3) Add a new sheet. 4) Type some content into a random number of cells. 5) Select Sheet2 tab, right mouse button click, Copy sheet, select in front of Sheet1 as destination. 6) Select Sheet1 tab, right mouse button click, Move sheet to end. Both sheets were either successfully copied / moved as intended.
I created 2 new spreadsheets and added additional sheets. I was then able to copy/move and delete sheets (commands active). I still cannot do this on the spreadsheets created in a much earlier version. Should I try Reset Properties?
My apologies to all concerned. When I went into the file properties I found that I'd ticked 'Record Changes' under the security tab. When I unchecked this option the spreadsheet went back to normal operation i.e. able to Delete and Move/Copy. I've been using the program since years before the split with Apache, but clearly don't know all its ins and outs as a user. Many Thank You's to those who helped.
*** This bug has been marked as a duplicate of bug 56973 ***