Libre Office Calc: Hidden row/column values are still displayed when copying chart to Writer

Version: LibreOffice 4.2.8.2 (1:4.2.8-0Ubuntu2) EN
System: Linux Ubuntu 14.04

When creating a chart and If I need to hide some values using function (Hide row, hide column) I can create the perfect chart with data-values I need. But when I copy it straight to LibreOffice Writer then it will still display all the hidden values?
Am I doing something wrong? Or this functions does not work like that? Workaround is to take screenshot of table in Calc and insert in Writer, but it will make a poor quality paper that way.

Formatting this as a comment as I have no personal experience with this extension. Try http://extensions.libreoffice.org/extension-center/copy-only-visible-cells and see if it solves the problem

Upgrade to 5.0.2.2 ! sudo add-apt-repository ppa:libreoffice/ppa, then sudo aptitude update || sudo apt-get update, then sudo aptitude full-upgrade || sudo apt-get upgrade.