--------------Boundary-00=_3M66XTCF212UZZSU9D7T Content-Type: text/plain Content-Transfer-Encoding: 8bit hi, I added to my previous patch : -Fix bug when you write a formular (=sum(A1:B5)) and there is a cell Merged. Now when a cell is obscuring you don't use it into formular. Could you test it please. thanks bye --------------Boundary-00=_3M66XTCF212UZZSU9D7T Content-Type: text/plain; name="patch40.diff" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="patch40.diff" PyBwYXRjaDI5LmRpZmYKPyBwYXRjaDI2LmRpZmYKPyBrd29yZC5rd2QKPyBmb250cy5kaXIKPyB0 b3RvLmNzdgo/IHRvdG8yLmtzcAo/IEtTcHJlYWRMb2NhdGlvbi5kaWZmCj8gPz8/Cj8gS1NwcmVh ZENlbGxJZmFjZV9zdHViLmgKPyBLU3ByZWFkQ2VsbElmYWNlX3N0dWIuY3BwCj8gdG90by5rc3AK PyBmaWx0ZXJzL01ha2VmaWxlLmluCj8gZmlsdGVycy9NYWtlZmlsZQo/IGZpbHRlcnMvY3N2L01h a2VmaWxlCj8gZmlsdGVycy9jc3YvTWFrZWZpbGUuaW4KPyBmaWx0ZXJzL2Nzdi9jc3ZmaWx0ZXIK PyBmaWx0ZXJzL2tvbW1hL01ha2VmaWxlLmluCj8gZmlsdGVycy9rb21tYS9NYWtlZmlsZQo/IHBp Y3MvQGtkZV9taW5pZGlyQApjdnMgc2VydmVyOiBEaWZmaW5nIC4KSW5kZXg6IGtzcHJlYWRfY2Fu dmFzLmNjCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT0KUkNTIGZpbGU6IC9ob21lL2tkZS9rb2ZmaWNlL2tzcHJlYWQva3Nw cmVhZF9jYW52YXMuY2MsdgpyZXRyaWV2aW5nIHJldmlzaW9uIDEuMTQ3CmRpZmYgLXUgLXAgLXIx LjE0NyBrc3ByZWFkX2NhbnZhcy5jYwotLS0ga3NwcmVhZF9jYW52YXMuY2MJMjAwMC8wOC8zMSAw Nzo1MjozNQkxLjE0NworKysga3NwcmVhZF9jYW52YXMuY2MJMjAwMC8wOC8zMSAxODozOTo0MQpA QCAtNTQzLDggKzU0MywyMCBAQCB2b2lkIEtTcHJlYWRDYW52YXM6OmNob29zZUdvdG9Mb2NhdGlv biggCiAgIEtTcHJlYWRDZWxsKiBjZWxsID0gdGFibGUtPmNlbGxBdCggeCwgeSApOwogICBpZiAo IGNlbGwtPmlzT2JzY3VyZWQoKSAmJiBjZWxsLT5pc09ic2N1cmluZ0ZvcmNlZCgpICkKICAgewot ICAgIHkgPSBjZWxsLT5vYnNjdXJpbmdDZWxsc1JvdygpOwotICAgIHggPSBjZWxsLT5vYnNjdXJp bmdDZWxsc0NvbHVtbigpOworICAgIGludCBtb3ZlWD1jZWxsLT5vYnNjdXJpbmdDZWxsc0NvbHVt bigpOworICAgIGludCBtb3ZlWT1jZWxsLT5vYnNjdXJpbmdDZWxsc1JvdygpOworICAgIGNlbGwg PSB0YWJsZS0+Y2VsbEF0KCBtb3ZlWCwgbW92ZVkgKTsKKyAgICBRUmVjdCBleHRyYUNlbGw7Cisg ICAgZXh0cmFDZWxsLnNldENvb3Jkcyhtb3ZlWCxtb3ZlWSxtb3ZlWCtjZWxsLT5leHRyYVhDZWxs cygpLG1vdmVZK2NlbGwtPmV4dHJhWUNlbGxzKCkpOworICAgIGlmKCAoeC1jaG9vc2VNYXJrZXJD b2x1bW4oKSkhPTAgJiYgZXh0cmFDZWxsLmNvbnRhaW5zKGNob29zZU1hcmtlcigpKSkKKyAgICAg ICAgeD1jZWxsLT5leHRyYVhDZWxscygpK3g7CisgICAgZWxzZSBpZigoeS1jaG9vc2VNYXJrZXJS b3coKSkhPTAgJiYgZXh0cmFDZWxsLmNvbnRhaW5zKGNob29zZU1hcmtlcigpKSkKKyAgICAgICAg eT1jZWxsLT5leHRyYVlDZWxscygpK3k7CisgICAgZWxzZQorICAgICAgICB7CisgICAgICAgIHkg PSBtb3ZlWTsKKyAgICAgICAgeCA9IG1vdmVYOworICAgICAgICB9CiAgIH0KIAogICBpbnQgeHBv cyA9IHRhYmxlLT5jb2x1bW5Qb3MoIHgsIHRoaXMgKTsKSW5kZXg6IGtzcHJlYWRfaW50ZXJwcmV0 ZXIuY2MKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PQpSQ1MgZmlsZTogL2hvbWUva2RlL2tvZmZpY2Uva3NwcmVhZC9rc3By ZWFkX2ludGVycHJldGVyLmNjLHYKcmV0cmlldmluZyByZXZpc2lvbiAxLjQ3CmRpZmYgLXUgLXAg LXIxLjQ3IGtzcHJlYWRfaW50ZXJwcmV0ZXIuY2MKLS0tIGtzcHJlYWRfaW50ZXJwcmV0ZXIuY2MJ MjAwMC8wOC8xMCAyMjo0MTowNAkxLjQ3CisrKyBrc3ByZWFkX2ludGVycHJldGVyLmNjCTIwMDAv MDgvMzEgMTg6Mzk6NDcKQEAgLTIxMDQsNyArMjEwNCw3IEBAIGJvb2wgS1NwcmVhZEludGVycHJl dGVyOjpwcm9jZXNzRXh0ZW5zaW8KICAgICAgIHJldHVybiBmYWxzZTsKICAgICB9CiAKLSAgICBp ZiAoIGNlbGwtPmlzRGVmYXVsdCgpICkKKyAgICBpZiAoIGNlbGwtPmlzRGVmYXVsdCgpIHx8IChj ZWxsLT5pc09ic2N1cmVkKCkgJiYgY2VsbC0+aXNPYnNjdXJpbmdGb3JjZWQoKSkpCiAgICAgICBj b250ZXh0LnNldFZhbHVlKCBuZXcgS1NWYWx1ZSggMC4wICkgKTsKICAgICBlbHNlIGlmICggY2Vs bC0+aXNWYWx1ZSgpICkKICAgICAgIGNvbnRleHQuc2V0VmFsdWUoIG5ldyBLU1ZhbHVlKCBjZWxs LT52YWx1ZURvdWJsZSgpICkgKTsKQEAgLTIxNjksOCArMjE2OSw4IEBAIGJvb2wgS1NwcmVhZElu dGVycHJldGVyOjpwcm9jZXNzRXh0ZW5zaW8KICAgICAgICAgICBjID0gbmV3IEtTVmFsdWUoIDAu MCApOwogICAgICAgICBlbHNlCiAgICAgICAgICAgYyA9IG5ldyBLU1ZhbHVlKCBjZWxsLT52YWx1 ZVN0cmluZygpICk7Ci0KLSAgICAgICAgbC0+bGlzdFZhbHVlKCkuYXBwZW5kKCBjICk7CisgICAg ICAgIGlmICggIShjZWxsLT5pc09ic2N1cmVkKCkgJiYgY2VsbC0+aXNPYnNjdXJpbmdGb3JjZWQo KSkgKQorICAgICAgICAgICAgICAgIGwtPmxpc3RWYWx1ZSgpLmFwcGVuZCggYyApOwogICAgICAg fQogICAgICAgdi0+bGlzdFZhbHVlKCkuYXBwZW5kKCBsICk7CiAgICAgfQpjdnMgc2VydmVyOiBE aWZmaW5nIGR0ZApjdnMgc2VydmVyOiBEaWZmaW5nIGV4dGVuc2lvbnMKY3ZzIHNlcnZlcjogRGlm ZmluZyBmaWx0ZXJzCmN2cyBzZXJ2ZXI6IERpZmZpbmcgZmlsdGVycy9jc3YKY3ZzIHNlcnZlcjog RGlmZmluZyBmaWx0ZXJzL2tvbW1hCmN2cyBzZXJ2ZXI6IERpZmZpbmcgcGljcwpjdnMgc2VydmVy OiBEaWZmaW5nIHBsdWdpbnMKY3ZzIHNlcnZlcjogRGlmZmluZyBwbHVnaW5zL2NhbGN1bGF0b3IK Y3ZzIHNlcnZlcjogRGlmZmluZyBwbHVnaW5zL2NhbGN1bGF0b3IvcGljcwpjdnMgc2VydmVyOiBE aWZmaW5nIHNjcmlwdHMKY3ZzIHNlcnZlcjogRGlmZmluZyB0YWJsZXN0eWxlcwpjdnMgc2VydmVy OiBEaWZmaW5nIHRvb2xiYXIKY3ZzIHNlcnZlcjogRGlmZmluZyB0b29sYmFyL2hpY29sb3IKY3Zz IHNlcnZlcjogRGlmZmluZyB0b29sYmFyL2xvY29sb3IK --------------Boundary-00=_3M66XTCF212UZZSU9D7T--