2.5.185 NoteRR

The NoteRR structure specifies a revision record for a comment associated with a cell.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

rrd (14 bytes)

...

...

...

A

B

reserved1

row

col

C

D

reserved3

E

F

G

H

I

guid (16 bytes)

...

...

...

ichEnd

...

cchNote

...

stAuthor (variable)

...

unused2

rrd (14 bytes): An RRD that specifies the revision record information used to track changes in a shared workbook. The rrd.revt MUST be equal to 0x000D. The rrd.tabid MUST NOT be 0xFFFF.

A - bitfDelNote (1 bit): A bit that specifies whether the revision record deletes the comment.

B - bitfAddNote (1 bit): A bit that specifies whether the revision record adds text to the comment.

Value

Meaning

0

Text has not been added to the comment.

1

A new comment is being added or additional text is being appended to an existing comment.

reserved1 (14 bits): MUST be 0 and MUST be ignored.

row (2 bytes): A RwU that specifies the row of the cell associated with the comment.

col (2 bytes): A ColU that specifies the column of the cell associated with the comment.

C - reserved2 (1 bit): MUST be 0 and MUST be ignored.

D - fShow (1 bit): A bit that specifies whether the comment is shown.

reserved3 (5 bits): MUST be 0 and MUST be ignored.

E - fRwHidden (1 bit): A bit that specifies whether the row specified by row is hidden.

F - fColHidden (1 bit): A bit that specifies whether the column specified by col is hidden.

G - reserved4 (2 bits): MUST be 0 and MUST be ignored.

H - unused1 (1 bit): Unused and MUST be ignored.  

I - reserved5 (4 bits): MUST be 0 and MUST be ignored.

guid (16 bytes): A GUID as specified by [MS-DTYP] that identifies the comment, specified by a NoteSh structure, which is modified by this revision record. The GUID for a comment is specified in the Obj record specified by the idObj field in the NoteSh structure. In the Obj record, the GUID is stored in the nts.guid field. If bitfDelNote is 1, this field MUST be zero.

ichEnd (4 bytes): An unsigned integer that specified the length of the comment before the revision is made.

cchNote (4 bytes): An unsigned integer that specifies the length of the string that was added to the comment in the revision record. The sum of ichEnd and cchNote MUST be less than or equal to 32767.     

stAuthor (variable): An XLUnicodeString that specifies the original author of the comment. The length MUST be greater than or equal to 1 and less than or equal to 54.

unused2 (2 bytes): Undefined and MUST be ignored.