DesktopEditors icon indicating copy to clipboard operation
DesktopEditors copied to clipboard

Spreadsheet replicate data top-down or left-right + fill with series.

Open rin67630 opened this issue 2 years ago • 5 comments

This issue is unique.

  • [X] I have used the search tool and did not find an issue describing my idea.

Environment.

Operating System Windows 10 and macOS Version information Version: 7.0.1.37

Your idea.

Replicating data top-down or left-right + filling cells with series is a basic feature the should not miss in a spreadsheet program. I was not able to find this functionality in OnlyOffice spreadsheets. Is that functionality just well-hidden or is is just not implemented yet? Please consider making it available or easier to find. Thank you for the great job you already did.

Laszlo

rin67630 avatar Apr 24 '22 12:04 rin67630

Hi, not sure that we understand what you mean

Could you provide a link to documentation of this feature for LibreOffice/MS Office or video how it implemented?

ShockwaveNN avatar Apr 25 '22 08:04 ShockwaveNN

Sorry I have only a German Excel here: image image Here you can mark an area of cells and replicate the first one top down, bottom up, left to right right to left to all others. Or fill cells with increasing decreasing series of values. This is an essential feature of a spreadsheet.

rin67630 avatar Apr 25 '22 13:04 rin67630

here the fill menu in Libre-Office: image

rin67630 avatar Apr 25 '22 14:04 rin67630

Hello! @rin67630, Thank you for enhancement. I created issue 56852 in our private issue tracker.

VladimirProkofiev52 avatar Apr 25 '22 15:04 VladimirProkofiev52

Hello! @rin67630 Your request has been partially fulfilled.
Feel free to explore the new functionalities in the editor version 8.0.1.

To utilize this feature, simply input data into multiple cells, then select the range containing the entered data, and drag it in any direction while holding down the right mouse button. A menu with various options will then appear.

Please be aware that while we've made some progress, the remainder of your request will be addressed later. This issue has been assigned the number #66607.

We appreciate your feedback!

VladimirProkofiev52 avatar May 07 '24 11:05 VladimirProkofiev52