QXlsx icon indicating copy to clipboard operation
QXlsx copied to clipboard

Count cells in a union cells

Open DamianoM opened this issue 5 years ago • 3 comments

How can I count the cells in a cell union. Example in VBA: NCeUn = Foglio2.Range("B" & riga).MergeArea.Count

DamianoM avatar Mar 14 '19 10:03 DamianoM

Dear @DamianoM I do not know vba at all. Could you explain what your code means?

j2doll avatar Mar 14 '19 11:03 j2doll

The code returns the number of cells present in a union of cells, for example if cells A1:A4 are joined cells returns 4

Il giorno giovedì 14 marzo 2019, Jay Two [email protected] ha scritto:

Dear @DamianoM https://github.com/DamianoM I do not know vba at all. Could you explain what your code means?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/QtExcel/QXlsx/issues/34#issuecomment-472822509, or mute the thread https://github.com/notifications/unsubscribe-auth/AuTUcbsQfTa5RNYuHWa6qQAJZv3Oc0Sbks5vWjmKgaJpZM4bzvhU .

DamianoM avatar Mar 14 '19 15:03 DamianoM

Thanks for reporting. There is no such function in QXlsx. I will register for enhancement.

j2doll avatar Mar 15 '19 00:03 j2doll