Nov 21, 2021 · Oct 10, 2020 · Oct 10, 2020 · Nov 5, 2020 · Dec 1, 2020 · Apr 22, 2021
diff --git a/lib/xlsx/xform/sheet/hyperlink-xform.js b/lib/xlsx/xform/sheet/hyperlink-xform.js
  }

  render(xmlStream, model) {
    xmlStream.leafNode('hyperlink', {
      ref: model.address,
      'r:id': model.rId,
      tooltip: model.tooltip,
    });
    if (this.isInternalLink(model)) {
      xmlStream.leafNode('hyperlink', {
        ref: model.address,
        'r:id': model.rId,
        tooltip: model.tooltip,
        location: model.target,
      });
    } else {
      xmlStream.leafNode('hyperlink', {
        ref: model.address,
        'r:id': model.rId,
        tooltip: model.tooltip,
      });
    }
  }

  parseOpen(node) {
        rId: node.attributes['r:id'],
        tooltip: node.attributes.tooltip,
      };

      // This is an internal link
      if (node.attributes.location) {
        this.model.target = node.attributes.location;
      }
      return true;
    }
    return false;
  parseClose() {
    return false;
  }

  isInternalLink(model) {
    // @example: Sheet2!D3, return true
    return model.target && /^[^!]+![a-zA-Z]+[\d]+$/.test(model.target);
  }
 }

 module.exports = HyperlinkXform;
diff --git a/spec/unit/xlsx/xform/sheet/hyperlink-xform.spec.js b/spec/unit/xlsx/xform/sheet/hyperlink-xform.spec.js
    xml: '<hyperlink ref="B6" r:id="rId1"/>',
    tests: ['render', 'renderIn', 'parse'],
  },
  {
    title: 'Internal Link',
    create() {
      return new HyperlinkXform();
    },
    preparedModel: {address: 'B6', rId: 'rId1', target: 'sheet1!B2'},
    get parsedModel() {
      return this.preparedModel;
    },
    xml: '<hyperlink ref="B6" r:id="rId1" location="sheet1!B2"/>',
    tests: ['render', 'renderIn', 'parse'],
  },
 ];

 describe('HyperlinkXform', () => {
Original file line number	Diff line number	Diff line change
Expand Up		@@ -6,11 +6,20 @@ class HyperlinkXform extends BaseXform {
		}

		render(xmlStream, model) {
		xmlStream.leafNode('hyperlink', {
		ref: model.address,
		'r:id': model.rId,
		tooltip: model.tooltip,
		});
		if (this.isInternalLink(model)) {
		xmlStream.leafNode('hyperlink', {
		ref: model.address,
		'r:id': model.rId,
		tooltip: model.tooltip,
		location: model.target,
		});
		} else {
		xmlStream.leafNode('hyperlink', {
		ref: model.address,
		'r:id': model.rId,
		tooltip: model.tooltip,
		});
		}
		}

		parseOpen(node) {
Expand All		@@ -20,6 +29,11 @@ class HyperlinkXform extends BaseXform {
		rId: node.attributes['r:id'],
		tooltip: node.attributes.tooltip,
		};

		// This is an internal link
		if (node.attributes.location) {
		this.model.target = node.attributes.location;
		}
		return true;
		}
		return false;
Expand All		@@ -30,6 +44,11 @@ class HyperlinkXform extends BaseXform {
		parseClose() {
		return false;
		}

		isInternalLink(model) {
		// @example: Sheet2!D3, return true
		return model.target && /^[^!]+![a-zA-Z]+[\d]+$/.test(model.target);
		}
		}

		module.exports = HyperlinkXform;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -15,6 +15,18 @@ const expectations = [
		xml: '<hyperlink ref="B6" r:id="rId1"/>',
		tests: ['render', 'renderIn', 'parse'],
		},
		{
		title: 'Internal Link',
		create() {
		return new HyperlinkXform();
		},
		preparedModel: {address: 'B6', rId: 'rId1', target: 'sheet1!B2'},
		get parsedModel() {
		return this.preparedModel;
		},
		xml: '<hyperlink ref="B6" r:id="rId1" location="sheet1!B2"/>',
		tests: ['render', 'renderIn', 'parse'],
		},
		];

		describe('HyperlinkXform', () => {
Expand Down