Page MenuHomeFeedback Tracker

BIS_fnc_exportCuratorCostTable broken - Formulas are incorrect
New, WishlistPublic

Description

Formulas seem mess up, the whole function is unusable.

Details

Legacy ID
384545754
Severity
None
Resolution
Open
Reproducibility
Always
Category
Zeus - General
Steps To Reproduce

Type [["A3_Characters_F_BLUFOR"],"ods"] spawn bis_fnc_exportCuratorCostTable;
in debug console

Paste into latest version of OpenOffice Calc

Notice how all the formulas are screwed

Event Timeline

PhonicGames set Category to Zeus - General.
PhonicGames set Reproducibility to Always.
PhonicGames set Severity to None.
PhonicGames set Resolution to Open.
PhonicGames set Legacy ID to 384545754.May 8 2016, 1:20 PM
PhonicGames added a subscriber: PhonicGames.

Doesn't work with google spreadsheet, excel 2010 or latest OpenOffice calc

In fact, there are many errors popping up in the arma 3 rpt.

Example:

_>
13:41:56 Error Max array size would be reached. Current size: 1000000, wanted size: 1000005.
13:41:56 File A3\functions_f_curator\Curator\fn_exportCuratorCostTable.sqf, line 395
13:41:56 Error in expression <%2 = [%1",_qt,_x,_row];
{
_text = _text + format ["&I%1",_x];
} foreach _rows;

artemoz added a subscriber: artemoz.May 8 2016, 1:20 PM

ODS version is being screwed with mismatching decimal symbol ("." or ",") in Windows.
GSheet is being screwed with excessive quotation marks.

Both can't make full table with empty addon filter (1st argument).

Fennek added a subscriber: Fennek.May 8 2016, 1:20 PM

mismatched decimal symbols - doesnt that depend on system/user settings?

Yeah but even after adjusting it, it originally didn't work.

I was able to get it to work to some extent after saving the broken stuff to a .ods file and then re-opening it (that magically fixed it).

However I don't think you can make a full table with that technique :/

ozdeadmeat added a subscriber: ozdeadmeat.EditedJun 26 2016, 4:37 PM

The xls dont work correctly for Office 2013 either. This is with version 1.60