fills the empty cells

3 0

Paste in empty cells of column , the value of the first filled cell situated above.

Project Description

Permet de coller dans les cellules vides d'une colonne, la valeur de la première cellule renseignée située au dessus.

A chaque ligne, la valeur présente dans la cellule active, est mémorisée et recopiée sur la ligne suivante si la cellule est vide, sinon la nouvelle valeur est à son tour mémorisée et ce principe répété jusqu'à la dernière ligne.

Cette macro est utile à ceux qui veulent, par exemple, copier le résultat d'un tableau croisé dynamique et renseigner les valeurs manquantes sous les regroupements ou si votre progiciel génère des extractions qui ne reprennent pas à chaque ligne, les valeurs des données de regroupement et que vous souhaitez en disposer.

lien vers VIDEO présentation


Calc Extension,

Homepage of the Project


Current Release

fills the empty cells - 1.0.3

Released Oct 28, 2015 — tested with:

LibreOffice 5.0,

Adding a keyboard shortcut (alt W) Works on the visible cells
More about this release…

File size: 51 kb

All Releases









Oct 28, 2015
    • LibreOffice 5.0
    Adding a keyboard shortcut (alt W) Works on the visible cells
    • LGPL-v2.1 (GNU Lesser General Public License Version 2.1)

    Legal Disclaimer and Limitations for Downloads

    The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
    websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.


    Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

    If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to for impartial consideration.