Ask Your Question
0

LibreOffice Calc how to fill blank cells with value of last known cell that is not empty

asked 2019-04-11 17:58:03 +0200

dadao gravatar image

I have a CSV file opened in Calc, in Column1, the last cell with value is on row 8333, starting from 8334 onwards to the bottom of the file, the cells are all empty; I am wondering how to fill these empty cells with the value of Column1 on row 8333; even better is it possible that I can fill these blank cells with randomly selected values from rows (2 - 8333) for Column1. All the headers are on row 1.

Since the file has about 74k rows, so mouse clicking is tedious, is it possible to automatically select blank cells starting from 8334 to 74503?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-04-12 00:52:13 +0200

m.a.riosv gravatar image

Selecting a range or a cell [Ctrl+D] duplicates the cells above.

edit flag offensive delete link more
0

answered 2019-04-11 18:20:31 +0200

Opaque gravatar image

updated 2019-04-11 18:25:54 +0200

Just put the range A8334:A74503 to the Name Box

image description

If you want to change values in the range selected use Edit -> Find & Replace and assure Current selection only is checked.

edit flag offensive delete link more

Comments

I am using LibreOffice Version: 6.0.7.3, current selection only is grey out, how does find and replace work here?

dadao gravatar imagedadao ( 2019-04-11 18:30:10 +0200 )edit

From my pov it's strange but the range selected must have at least one value to have the option available.

Opaque gravatar imageOpaque ( 2019-04-11 18:40:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-11 17:58:03 +0200

Seen: 70 times

Last updated: Apr 12