Description: LibreOffice Calc auto fill suggestion box only works for one sheet. I feel it should auto fill all sheets in the document. I would like to use this for for accounts where a month is on its own sheet and I have awkward company names I have to type multiple times like "Shenzhenshigeduowangluokejiyouxiangongsi" Steps to Reproduce: 1.create sheet 2.type something in a cell 3.type same thing in cell, auto fill should appear. 4.create another sheet. 5. type same thing into cell. . Actual Results: Auto fill doesn't work Expected Results: The software should Auto fill across sheets. It's more logical than how it works at the moment. Reproducible: Always User Profile Reset: No Additional Info: I am on a older version, I doubt this has been fixed on newer versions.
I was able to reproduce this. Although I am not sure if this is a bug or design feature, so I won't change the status yet. Version: 24.8.3.2 (AARCH64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Have you tried selecting both sheets with [Ctrl+click]
I think it is designed that way. Office 365 excel has the same behavior. Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Autofill uses data from cell above on the same sheet. It isn't a bug at all. But possibly it can be discussed by UX-team?
(In reply to m_a_riosv from comment #2) > Have you tried selecting both sheets with [Ctrl+click] Works perfectly => WF (actually invalid as the function exists) Please also consider users who not want to run a feature somewhere else not clearly visible.
(In reply to Heiko Tietze from comment #5) > (In reply to m_a_riosv from comment #2) > > Have you tried selecting both sheets with [Ctrl+click] > Works perfectly => WF (actually invalid as the function exists) > > Please also consider users who not want to run a feature somewhere else not > clearly visible. Heiko, Miguel, I don't think Robert wanted to enter some data to all sheets at once. I think the idea here to have Autofill feature that uses data from sheet1 on sheet2and others For example: Sheet1 contains in A column: AAA BBB CCC And where you start enter something in A1 cell on empty Sheet2, for example started by B letter, then Autofill should offer BBB using data from Sheet1.
(In reply to Roman Kuznetsov from comment #6) > I think the idea here to have Autofill feature that uses data from > sheet1 on sheet2and others There is no blocker to use =$Sheet1.A1. But okay, let's hear Robert => NEEDINFO