Notes from 27 April 2020 ODF TC Teleconference call

[Patrick Durusau <patrick@durusau.net>]

Greetings!

Serious progress on a knotty issue! Thanks!

Notes from today are below.

Hope everyone is having a great week!

Patrick

************

Patrick: Quorum - yes
Patrick: Agenda - approved by consent
Patrick: Minutes 20 April 2020 - approved by consent
Patrick: 4.7 Empty Cell terminlogy
Patrick: Regina - empty cell - can have content that is not considered
for calculations
Patrick: Regina - don't say empty cell in general but say empty cell
when referenced by a formula
Patrick: Regina - can use whether office:value-type exists, if not, is
empty for purposes of calculations
Patrick: Andreas - tricky b/c don't use value types - know when cell is
"empty"
Patrick: 12 in my example - was representation of the 12
Patrick: Andreas - value type might be the right thing to do
Patrick: value type void - means we don't have a value
Patrick: void should be the behavior if the value type is not specified
at all
Patrick: Regina says void not listed in the schema -
Patrick: Francis - is there a function to return the type of a cell?
Patrick: (void has no attribute in Table 14) as as if attribute is missing)
Patrick: TYPE - returns number for type of value number, text, logical,
error, array in 6.13.33
Patrick: in table 14 - boolean, currency, dat, float, percentage,
string, time, void -
Regina Henschel: CELL has "b" (blank), "l" (label or text), "v" (number)
Patrick: Francis - will empty be an emergent property based upon others
being false?
Patrick: Francis - if using office:value-type - would need to make sure
it works
Patrick: Rich - would need to run it by internal contacts before stating
an opinion
Patrick: A cell is an empty cell when referenced by a formula and the
referenced cell has no office:value-type attribute.
Patrick: Blank would have an office:value-type attribute but no content
Patrick: Regina - when referenced in a formula - and no
office:value-type - empty
Patrick: Contextual use of "empty" - at least one is in the context of a
formula referencing a cell - it looks for the office:value-type - Not
defining "empty" in other contexts or usage
Patrick: Francis - use special typography for "empty cell" in this
context (from Regina)
Patrick: Alfred - will ask internal sources at MS if this is clear, etc.
Patrick: adjourned


-- 
Patrick Durusau
patrick@durusau.net
Technical Advisory Board, OASIS (TAB)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau

Attachment: signature.asc
Description: OpenPGP digital signature