Excel - Element List dialog: Present the localized version of formulas (#9144)#11329
Conversation
I'm not sue about this one. |
|
@LeonarddeR wrote:
If I'm not wrong, it is, as of #9257,.
I was rather thinking of using the structure as already retrieved on the Python side.
This is indeed what I did. Do you mean you'd prefer I rename the member? Or include both versions in the structure? |
Yes, you're correct, I"m sorry.
I think it all depended on whether the structure was our own or not. As it is ours, I think it is OK to leave this as is. Just forget my earlier comment ;) |
My only concern with this is if NVDA / other code (addons?) is looking for "known values" in the non-localized version of this. It seem unlikely if it is just the formula, but it would be good to spend a little time to see if that is possible. |
Indeed only the formula is concerned by the proposed change. EDIT: Regarding the possible customized processing of some specific spreadsheet as might be required by our customers here at Accessolutions, we could not foresee a case where the same code would need to apply in different locale, thus the localized version still meets our needs in that matter. Only speaking in our name, though. |
|
I am fine with reusing the existing struct member for the localized formula. I cannot think of a situation where an appModule developer could fairly argue they wanted to match logic against a raw formula. |
feerrenrut
left a comment
There was a problem hiding this comment.
Yep, I think this is fine in that case. It would be worth putting something detailed in the "changes for developers" section of the change-log to call attention to this. I'll merge this shortly.
|
I wasn't able to work out a good way to explain this change as it might appear to an add-on developer. I didn't add anything to the changes for developers section for this. Suggestions / PR welcome! |
Link to issue number:
Fixes #9144
Summary of the issue:
In Microsoft Excel, the Elements List dialog presents formula in their English version, whatever the locale of the user.
Description of how this pull request fixes the issue:
Present instead the localized version of the formula, as Excel itself presents it to the user.
Testing performed:
From local source, opened the Elements List dialog in Excel 2016 with French locale on a worksheet containing formulas.
Known issues with pull request:
To reduce the diff and limit the API impact for add-ons, I did not rename
ExcelCellInfo.formulanor add aformulaLocalmember. Instead, I simply filled the existing structure member with the appropriate value.Please let me know if you feel this is less readable and prefer I proceed otherwise.
Change log entry:
Section: Changes or Bug fixes, as you see fit.
In Microsoft Excel, the Elements List dialog now presents formulas in their localized form.